G
Guest
I am building a Access 2003 database where I am using the DateSerial
calculator. I am able to get the future date to calculate using two fields in
a form but I am not able to figure out how to calculate a future date from a
column of dates. As an extra twist the column of dates is in a subform of
the mainform with the field containing the future calculated date.
Example: I have a form that displays a Procedure on Equipment with a field
showing next Review Due Date and in that form is a subform with the Review
Date history with a column of dates the procedure was reviewed, a comment
and name field is also included in the field.
I also like the smart tag idea and when I used it on the Next Due Date Field
I succeeded in having Outlook open an email or schedule meeting window. It
was limited to inserting the Review Due Date from the field with the smart
tag but I was hoping it would also insert information about the procedure
needing review into Outlook.
calculator. I am able to get the future date to calculate using two fields in
a form but I am not able to figure out how to calculate a future date from a
column of dates. As an extra twist the column of dates is in a subform of
the mainform with the field containing the future calculated date.
Example: I have a form that displays a Procedure on Equipment with a field
showing next Review Due Date and in that form is a subform with the Review
Date history with a column of dates the procedure was reviewed, a comment
and name field is also included in the field.
I also like the smart tag idea and when I used it on the Next Due Date Field
I succeeded in having Outlook open an email or schedule meeting window. It
was limited to inserting the Review Due Date from the field with the smart
tag but I was hoping it would also insert information about the procedure
needing review into Outlook.