I received VD code and it is working fine. However, other than 1 exception, I cannot add anything to it or I screw it up and it stops working. This code allows me to add, edit, or delete records from my MS Access database.
I'd like to add 2 fields that are automatic (require no entry) where we can track who made the update and also their IP address. So, when the form is submitted from the VD code above these 2 fields add to the database AND the results of those 2 fields also adds to the results section of the VD code.
The 2 fields I'd like to add are;
DateLastUpdated .......(most recent if updated several times)
Updater_IP .......(of person making the update)
Basically the original data in the database comes from another form. The VD code above allows me (or a secretary) to add, edit or delete records from that database. We want to know when the latest updates occurred and who made them.
for - Ajz