Post reply

I need HELP

  • October 27, 2005 at 1:42 pm

    #67923

    I have a Client server application that use Access and SQL server 2000.

    I've created all the tables and links and everything seems to work. The last steps was the reports. The reports are supposed to take data from a form and compile the information, but when I enter the criteria [form]![... it doesn't work. Can I create a view that receives a date parameter from the access front end then create a report based off of this view. The users need to pick a report from a switchboard enter date information and preview and print a report.

    Any help would be appreciate

    Thanks in advance

     

    -WM

  • October 28, 2005 at 1:18 am

    #600812

    Hi,

    Enter the name of the paramete in the InputParameter property of the report.

     

    Here is an example

     

    Forms!frmReports!txtYearMonth

    in the reportDatasource enter the name of the usp

     

    when the report opens it evaluates the parameter and supplies it automatically to the usp.

     

  • October 28, 2005 at 6:20 am

    #600864

    Thanks

     

    -WM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply