Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    12

    DISPLAY INPUT PARAMETERS ON THE REPORT


    My application uses MS Access 2000 .I have some reports based on underlying queries...i just want to display two input parameters DATE A and DATE B on my report.The scenario is as follows;
    At the query design grid,field name ATE OF PURCHASE has an expression "Between[Start Date] And [End Date]"....How can I display on the report header, both parameters [Start Date] And [End Date] after they have been entered ?????

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275

    Re: DISPLAY INPUT PARAMETERS ON THE REPORT

    Quote Originally Posted by fadone
    My application uses MS Access 2000 .I have some reports based on underlying queries...i just want to display two input parameters DATE A and DATE B on my report.The scenario is as follows;
    At the query design grid,field name ATE OF PURCHASE has an expression "Between[Start Date] And [End Date]"....How can I display on the report header, both parameters [Start Date] And [End Date] after they have been entered ?????
    One simple way: use unbound TextBoxes in the report header for those dates, and then use the Report's Open event sub to grab them from the form:

    Code:
    Me!DateA = Forms("MyForm").Controls("DateA").Value
    Me!DateB = Forms("MyForm").Controls("DateB").Value

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

Similar Threads

  1. Replies: 0
    Last Post: 08-07-2008, 07:02 PM
  2. Replies: 0
    Last Post: 02-15-2007, 03:07 PM
  3. Passing parameters to a report
    By elmousa68 in forum Access
    Replies: 0
    Last Post: 12-07-2006, 01:38 AM
  4. Replies: 4
    Last Post: 01-05-2006, 02:36 AM
  5. Input parameters
    By GloriaLuz in forum Reports
    Replies: 0
    Last Post: 11-14-2005, 09:38 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