Results 1 to 2 of 2

Thread: pliz help !!!

  1. #1
    Join Date
    Jun 2003

    Unanswered: pliz help !!!

    hi everybody !

    i need to create a query that calculates sthg using the value of a specific form control...
    i dont know how to do this...

    pliz help me!

    if you want to talk to me directly send me an email telling me at what time U can meet me on msn messenger tomorrow to the following account:
    ps: tell me in what country you are 'coz i'm in france...

    thx again
    Last edited by lifeman; 06-19-03 at 21:53.

  2. #2
    Join Date
    Jun 2003
    Here is a similar answer I did using two dates as criteria but the concept is the same (query by form).

    Have a form perhaps called MyForm with the following 2 controls:

    And have a command button on the form to open the report with something like the following code behind the OnClick property:
    DoCmd OpenReport "MyReport", A_PREVIEW
    DoCmd Maximize

    Of course the form could also have a command button to open another form with something like the following code behind the OnClick property:
    DoCmd OpenForm "MyOtherForm"
    DoCmd Maximize

    Base the report on a query. In the query's criteria for the date field perhaps put in something like the following:
    Between [Forms]![MyForm]![ctrDateMin] And [Forms]![MyForm]![ctrDateMax]

    And of course if the command button were opening a form instead of a report, the form could also be based on the same query or a similar one.
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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