message box

  • Thread starter Thread starter nathan
  • Start date Start date
N

nathan

Hi
I am not sure how to do this or if it can be done, but
here goes.

Within my database there is a field 'Valid Certificate'
which checks the expiry date of someones membership
against the current date.
Instead of members just being deleted when their
membership runs out, I want the database to alert me.
Is it possible to have a message box appear when I first
log on to the database listing all the members whose
membership will be expiring within a week. This will then
give me time to contact the members to renew their
membership.

Thankyou for any help.
 
I would create an "AutoExec" Macro to run a query to
inspect the dates and then generate a messagebox with the
results.

A macro named "AutoExec" will run each time the database
is opened.

G
 
Nathan,

Instead of going to all the trouble of programming a message box, why not create
a pop-up form based on a query that displays all the members whose membership
will be expiring within a week and make this form the opening form for your
database. Just go to Tools - Startup and set the name of the form at the top
right.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
Back
Top