Message Box

[cbrsix]

I have a table that has a list of states where we have certain licenses and their respective expiration dates. These dates have to be monitored and I would like to have a message box that automatically comes up when access is opened that shows the state and the expiration date. I want this message box to appear about a month before the actual expiration date. How can I go about accomplish this?



Thanks.

[pbaldy]

If you search here on reminders or expiration you should find similar threads. Basically, create a query that displays any records due within a month. Test that query with a DCount when the db opens. If it returns any records, open a form based on the query to display the results to the user.

[cbrsix]

What do you mean when you say to test the query with a DCount when the db opens? Is this necessary if I have a query created that returns the proper fields when run?

[pbaldy]

The reasoning would be that you don't want to open the form if there are no records to display. One way to avoid that is to test the underlying query before opening the form.