Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record Source (2000)

    I created some Pivot Table forms. I am trying to see what query I used behind the Pivot Table form but the Record Source is blank. Is there a way to tell what query I used to create these types of forms? I created quite a few and I am not sure what query goes with what Pivot table form.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Record Source (2000)

    The subject of your post says 2000. Pivot tables and pivot charts were introduced in Access 2002 (XP). What exactly do you mean?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record Source (2000)

    I have Access 2000. Under forms | new there is a Pivot Table Wizard. That is what I used to create the Pivot table forms. When I click on Help and click on "About Microsoft Access" , It says Access 2000.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Record Source (2000)

    OK, I see what you mean. The Pivot Table Wizard in Access 2000 creates an Excel pivot table object as an OLE control on your form. The form itself is unbound. Does the OLE control have a Row Source property?

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record Source (2000)

    The row source of the Ole control is blank.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Record Source (2000)

    Sorry to be so vague, it's been a while since I used older Access versions.
    The Excel pivot table uses MS Query to get the data from Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •