Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I've spent a goodly amount of time designing a report within Access that does just what I need it to. I need the same exact layout and format (using the same fields in fact) for a 2nd query. I've been able to copy and paste the existing report but am stumped how I can change the source Query from looking at A to look at B. Any suggestions are appreciated. Thanks, Pete

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Pete,

    Open the form in design mode.
    Right Click the box in upper left corner (see below)
    Click Properties
    Select the Data Tab
    Use the dropdown arrow in the Record Source property to select the desired record source query
    Save the form
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following 2 Users Say Thank You to RetiredGeek For This Useful Post:

    burtenr (2014-10-11),mpineda7 (2016-03-07)

  4. #3
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Brilliant! Thanks for helping out a rookie, greatly appreciated.

  5. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by Pete Sweeney View Post
    Brilliant! Thanks for helping out a rookie, greatly appreciated.
    Always glad to help.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #5
    New Lounger
    Join Date
    Mar 2011
    Location
    Cincinnati, OH
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I was struggling with sam problem for days. "RetiredGeek" was absolete correct. Thanks.

  7. #6
    New Lounger
    Join Date
    Oct 2014
    Posts
    1
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by RetiredGeek View Post
    Always glad to help.
    I was also struggling with this problem. Thanks very much.

    Slight addition to RetiredGeek's answer, you need to turn on the Ruler to see his 'square'

  8. #7
    New Lounger
    Join Date
    Nov 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks for addition

    Quote Originally Posted by burtenr View Post
    I was also struggling with this problem. Thanks very much.

    Slight addition to RetiredGeek's answer, you need to turn on the Ruler to see his 'square'
    I was having a hard time finding the box because I didn't have the rulers showing. Thanks!

  9. #8
    New Lounger
    Join Date
    Dec 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I'm fairly new to Access and I found this thread to be very useful.

    What I would like to know is if there is a way for a report to change which query it uses based on a different user each time. What I am trying to do is:

    1) I have five users who need to use this database, but their only purpose is to generate reports from tables that are imported from each of their own Excel sheets. The excel sheets however will be in the same format.
    2) There a several reports that each has to use. I was able to make copies of these reports and just replace the source like it was done above.

    What I am trying to avoid is to have to make these reports 5-times over just to change which query it comes from. Is this possible, would I be able to code and If function to make this possible?

    Thank You,

Posting Permissions

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