Dates

[dave1234]

Can anyone please tell me or show me how to put be prompted to put in two dates so you can see records between to alocated dates, Im only doing this in Access not visual basic.

Regards Dave.

 

[Mile-O]

In a query you can put as the criteria:

Between [Enter Start Date] And [Enter End Date]

This prompts the user to type in the date but can produce errors depending on what they type. Date format may be wrong. They could even type "ghfjjfhgjkf" and the query would try to process it.


So, another method is to put two textboxes on a form txtStart and txtEnd and reference them.

Between [Forms]![frmMyForm]![txtStart] And [Forms]![frmMyForm]![txtEnd]


Final idea is to use the Calendar Control combined with the previous suggestion. Example