Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access - automatically update date
Name: Erik B Date: February 3, 2009 at 09:54:45 Pacific OS: Windows XP Subcategory: General
Comment:
I am creating a form to track information for numerous construction jobs. The form has about 20 fields. One of the fields I have created is a "Last Update" field. I want this field to update to the current date if any field in the form is changed/updated.
Name: wizard-fred Date: February 10, 2009 at 15:14:27 Pacific
Reply:
You need some programming logic. If any field is updated then change date field. Traditional method is to store all fields and compare on exit of record.
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this gets data from 2 tables.) "country" (has values o...
Summary: I'm currently working on a Access project, and I am in need of a certain validation rule. I am trying to find a rule which will only allow dates to be chosen from "todays date" up until 2 months in fr...
Summary: I have created a small access database with a form interface and would like to be able to update totals on a daily basis with as little effort as possible. I have received,stock on hand. issued out an...
0 
