return info to table after processing

[Abbosy]

Hi there forum,

I really need your assistance with this problem.

I have a table (tblInstallations) which has records of date installed (for machines).
It is calculating that "next due maintenance" is one year after installation.
Sometimes we need to visit the site to maintain or service the machine before/after the specified date in "next due maintenance" and we need this to be calculated to reflect a year after date of visit.
I have a table called "tblMaintenance" which takes information about the machine an engineer is visiting from where originally the information are kept and that is in "tblInstallations".
My question/problem is: How can I link the new date of the visit to update the record for "next due maintenance"

Many thanks for your help in advance

 

[BlueIshDan]

DateAdd("yyyy", 1, [date-field]) As [Field Name]

Add this to your insert queries fields?

 

[BlueIshDan]

Found here

 

[Abbosy]

Hi there BlueIshDan,

Thanks very much for your reply to the msg. I have tried this (and will keep trying) but for some reason it didn't work; may be it was something wrong in the format of one or more of the fields.

There used to be a button to click on it and say thank you, but I couldn't find it but for sure it's a thank you from me.


Regards
Abbosy

 

[BlueIshDan]

If it is within VBA that you're doing all of this. Try adding an On Error. And display your error message if it is not being displayed.

Also, make sure that your data types are correct.