I have created a Sample Search Form for both 97 and 2002 that have a number of code routines that may help forum users. Included also is a word document that outlines a couple of features.

Code examples are for:

Search Filter with message box display, (If no data).
Printing Filtered Data via a Report
View Filtered Data via a Form
Add a Record
Export Data into a Excel Spreadsheet
Calendar Routine (not third part, only VBA code)
Specified Icon in Top Right corner of a form
Day Date Time displayed on Main Form

Like with all examples they can be improved upon. So feel free to improve where necessary.


Cheers!!!!!!!

Lou

Since this was saved as a 2002 version from 2003 I have added the missing Excel 10 Library and hopefully fixed any errors that some where having when opening the 2002 version demo. If you still have problems convert the 97 version in Access 2002 and all should be ok.


Edited by: GlenKruger on Tue Sep 20 17:33:55 EDT 2005.