ACCESS REMINDER

W

whill1

Hi All,
I am trying to set up a reminder that will notify me before an upcomming appointment. getting a macro to remind me on a particular date is no problem. However I am not sure about the correct syntax to use for the time field. working with times seems to be more elusive than dates. for example in a macro contition [TableName].[DateField] = Date() or [TableName].[DateField] = Date()-1 or similiar conditions. If I want a reminder to alert me say two hours before an appointment what is the correct syntax? I have a table with both Date and appointment time but cannot figure this out
Thanks for any feedback!!!
 
J

Jeff Boyce

Take a look at Access HELP on the DateAdd() function, which includes methods
for time units.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Code to create reminders in Outlook from Excel 0
Outlook 2003 Reminder 0
Reminder issues in Outlook 2003 0
Outlook Reminder Problem after Re-scheduling Appointment using Access VBA 0
Outlook 2003 Reminder Issue 0
Outlook 2003 Calendar reminder for incoming accepted appointments 0
Outlook Appointment Reminders 4
Reminders DUE IN xx DAYS 3

Top