Date Query with Pop Up

[Tansar]

Hi,
I would like to know if I can have some sort of pop up that shows dates which have expired.

Basically I want access to automatically tell me (upon opening which items/products have expired).

Is it poss? Hope to hear.
Thanks

 

[Guus2005]

Yes, you can. (Giving you the same information as you did)

 

[Tansar]

Yes, you can. (Giving you the same information as you did)

Ok, ok...get the hint (sorry). Just asking a question on behalf of someone.

There is a start date to some road works and an expiry date. If the expiry date is passed then we'd like Access to remind us (ie project 123 has expired, etc), rather than running a query (of some kind) everyday we log in.

Does that help?
Thanks

 

[Guus2005]

Yes, that does help.

Access is not a service. In that respect you can't expect it to give you messages about roads that need mending. You need to start your application in order to do something.
When you boot the computer you can start the application (in the startup section) using a commandline to pass in some parameters. With these parameters you can then let access give you a message about expire dates and additional information.

Because Access is not a service it doesn't run in the background. However that behaviour can be faked using a form and a timer.

Commandline, Form and Timer examples can be found all over the site.

HTH