Automating a date

[krismegna]

I am a novice Access user, attempting to build a rather complex client
database. Silly me. Anyway, when we get new clients, we are required to
file certain documents within a certain period of our appointment. I
want Access to automatically add the date of the appointment with the
given deadline time period to a new field. Is this possible? By the
way, I am using Access 2003.

Thanks for the support!
Kris

 

[Jeff Boyce]

Kris

Access has a bit of a steep learning curve. I hope you have plenty of time
to devote to learning how!<g>

You actually probably DON'T want to add a "calculated value" into your
database. This leads to much more work on your part, ensuring that the
various pieces are kept in synch.

Instead, if you have a known, fixed length of time from the appointment
date, use a query to calculate and display this on-the-fly.

How many people will need to use this application? How "savvy" are they
about Access? Will you need to "user-proof" the application? Do you have a
network/LAN?

You can throw together some tables in Access without a great deal of effort.
Putting together a user-friendly, user-proof, reasonably-performing Access
application is a bit more work... I like to caution my clients that "easy
.... is HARD!"

Regards

Jeff Boyce
Microsoft Office/Access MVP