Would like Access to Query on startup and then perform an action. How?

[SomeGuy]

I am interested in having Access do a query of two fields in a particular table on start up.
One of the fields is Application Date and the other is Status of Application (this has four possible selections from combo box - Funded, Not Funded, Pending and Unknown).

I would like to have Access query the Status of Application to determine if the entered value is Pending or Unknown. If it is, I would like it to check the Application Date to determine if it has been Pending or Unknown for more than 3 months.

If the Application Date is more than 3 months previous, it would be nice to have a little box pop up to notify the user that there are records that require updating or something to that effect.

If that works, it would also be neat to have a selection to run a report to see which ones are outdated and need to be updated.

I know this is a lot to ask but ANY help would be appreciated.

 

[Pat Hartman]

Create a function in a code module to do the various tasks. Then create a macro to run the function. Name the macro - Autoexec. Access runs any macro with this name at startup.

 

[SomeGuy]

Thanks!