Query+switchboard

[Khalil Handal]

Hi,
I have an access database used for a library. I am working manualy with it.

1- Is it possible to create a switch board for it?
2- In the Query I change the criteria manuly to specify two dates.
How can I create a dialog box asking to insert "starting date" and "ending
date" in order to priint all record between these two dates?
Note: It is important for this dialog box to show the last two dates used .

Thanks in advance
Khalil

 

[Tom Wickerath]

Hi Khalil,

Yes, it is certainly possible to create a switchboard. I recommend that you build your own, based
on an unbound form (ie. no recordsource) instead of using the switchboard wizard.

I can send you some sample files that show you how to build your own switchboard, and also answer
your second question. Please let me know first if you would welcome receiving an e-mail message
with attached files.

Tom
_______________________________

"Khalil Handal" wrote in message
Hi,
I have an access database used for a library. I am working manualy with it.

1- Is it possible to create a switch board for it?
2- In the Query I change the criteria manuly to specify two dates.
How can I create a dialog box asking to insert "starting date" and "ending
date" in order to priint all record between these two dates?
Note: It is important for this dialog box to show the last two dates used .

Thanks in advance
Khalil

 

[Khalil Handal]

Hi Tom

With great pleasure.

Email:
(e-mail address removed)

Thanks a lot

 

[Tom Wickerath]

Hi Khalil,

You should have received the files by now. I sent the attachments, and shortly thereafter lost my
Comcast service....it's been restored now.


Tom
______________________________

"Khalil Handal" wrote in message
Hi Tom

With great pleasure.


Thanks a lot