Create a pop-up

[macdoum]

Hello !

I Have a table with a ODBC link. I build a query and a report to get
the worker's schedules.

everything is working fine. The query looks up bewteen date to show the
results. A criteria «BETWEEN» is used in the query.

Is it possible to create a sort of pop-up window that would ask me
between what dates I would like the query to look for the worker's
scedule ?

What I would like is for the pop-up window to ask me between what dates
and when I would enter the two dates, the reports prints itself.


Can it be possible ?


Thanks...

Sorry abour my english, I'm french ! PLease don't hold that against me
!!!!!

Marc.

 

[Jeff L]

Yes the statement would be Between [StartDate] And [EndDate]. Then
when your query is run, you will be asked for StartDate and EndDate.

To auto print the report, you would need
DoCmd.OpenReport "YourReportName", acViewNormal
in an event of some kind, such as the On Click event of a Command
Button.

Hope that helps!

 

[macdoum]

Thanks !


Jeff L a écrit :

Yes the statement would be Between [StartDate] And [EndDate]. Then
when your query is run, you will be asked for StartDate and EndDate.

To auto print the report, you would need
DoCmd.OpenReport "YourReportName", acViewNormal
in an event of some kind, such as the On Click event of a Command
Button.

Hope that helps!

Hello !

I Have a table with a ODBC link. I build a query and a report to get
the worker's schedules.

everything is working fine. The query looks up bewteen date to show the
results. A criteria «BETWEEN» is used in the query.

Is it possible to create a sort of pop-up window that would ask me
between what dates I would like the query to look for the worker's
scedule ?

What I would like is for the pop-up window to ask me between what dates
and when I would enter the two dates, the reports prints itself.


Can it be possible ?


Thanks...

Sorry abour my english, I'm french ! PLease don't hold that against me
!!!!!

Marc.