Results 1 to 6 of 6
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    How do I request the user type a date for a report date?

    I have several reports requiring a date that may not be the current date. How do I get the user to enter the date and only have the user do it one time for several reports? I am at a loss on how to do this. Any help will be appreciated. I know there has to be a way. Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,529
    Have the user enter the date on a form, and have the reports/queries get it from there.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I realize I could make the user enter dates on a form linked to a table, but isn't there a way to have the date entered at print time?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,529
    I wouldn't typically use a form linked to a table, I'd use an unbound form just used to enter criteria for reports. You can use the brackets method that you probably already are, but as you've seen the criteria has to be entered for each report.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    Thanks for the suggestions.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,529
    No problem. Most professionals use a form to gather user input, so I think you'll be happy with it in the long run.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-28-2014, 10:44 PM
  2. Replies: 11
    Last Post: 07-20-2014, 06:22 PM
  3. Replies: 18
    Last Post: 11-12-2013, 04:06 PM
  4. Replies: 3
    Last Post: 09-23-2013, 10:43 PM
  5. Replies: 1
    Last Post: 07-07-2010, 04:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums