Solutions database

[sxu-mic]

I've seen a couple of references to examples of certain features in the solutions database. Where can I get this database?

I'm trying to use calender controls for user input parameters to run a report and I am having lots of trouble.

 

[Autoeng]

Don't know what solutions database that you are refering to but I'll tell you what I do. First, Have you successfully created a popup calendar to use? If not, search for "calendar" on this website and also look at www.tek-tips.com under Microsoft Access: Forms in the Faqs area. There are 2 good posts there for the creation of a calendar. Create a popup form with fields to accept whatever dates you might need (I assume a start and stop). Attach the calendar return to these fields. Put a command button on the form to start the query. In the criteria of your query put:

Between [Forms]![yourform]![yourfieldname] And [Forms]![yourform]![yourotherfieldname]

This should do what you need if I'm reading it correct.

Autoeng

 

[ghudson]

The Access 97 version of the Solutions.dmb db came with the original install CD. It was extracted from the "Building Applications with Microsoft Access 97" HTML guide that came with the CD.