New User Question

[ignignoct5d]

Hello,

I'm a pretty new user to Access. What little experience I have is from directly playing around with sample databases. Currently I'm helping a small non-profit organization here with data management.

My question is, are there any simple ways to create a sort of alert or scheduled notification based on the current date and some trigger criteria. Basically when a client enters the program, we input a load of data on them manually. And periodically we have to check back with them for stuff such as 6 month testing, X/hours testing, monthly checks etc.

Idealy I'd like to set up something that would start when the database is opened and alert any volunteer or staff person that soandso people need to be called to do soandso.

Macros? Reports? I have no idea where to begin.

Sorry in advance if this is one of those obvious answer questions. I find access intimidating sometimes, especially when so much information is in there thats vital to our program.

Thanks for any suggestions!

 

[The_Doc_Man]

Alternatively, if you already had a startup form, you can add VBA code to the form's OnLoad event code to open another form such as Pat described.

Or you can simply define a query to test your critera and then, using the OnOpen event, use a DCount( "*", "yourqueryname" ) to find out the population of the query. If it is not zero, open a message box to notify folks.

Several ways to skin this cat. Depends on how much VBA you like to play with. You claimed to be new to Access. But if you are not new to programming in general, the above solution should be fairly easy.