Auto Update Date Field In Table
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The table has a hidden field for date. I would like this field auto populated which I am able to do. The problem I am running into is 3rd shift 11p -7a. I would the like the field to auto populate with the previous date until 7am then start to use the new date.
1. If I add a field called Date_Further_Info_Reqd, then is it possible to auto generate a date in this field if the Review_Status field value = Require Further Information? (Note if theReview Status field is changed later, then the Date_Further_Info_Reqd date must remain unchanged.
2. If I add a field called Date_Completed, is it possible to auto generate a date in this field if the Review_Status field value = Complete?
3. If I add a Y/N field called Watchlist, is it possible to auto generate a date in a field called Watch_Date when the Watchlist field = Y?
I have used "=Date()" for the default value for that field, but it only updates new records with the current date.
How do I get the 1200 records to update with today's date automatically?
I have a Membership Database created in Access. The main table, Members Table, includes a field for Next Renewal. The Next Renewal Date should be one year from the last membership update. To date, the end user has been putting the Next Renewal in manually. What I want to do is to have it auto-entered by the program by writing a calculation that basically says =([LastUpdate]+365 and automatically posts the answer into the Next Renewal field.
Now, I know I cannot do calculations in a table, but I can in a form. So I wrote the calculation in the form, but when entries are made on the form that should update in the table, the Next Renewal field shows blank in the table.
I need that field in the table because I have to run a query based on the Next Renewal and I can't run a query based on a form field.
Can what I wish to do be done? How would I go about it
I’m trying to auto-populate a field in the form based on another field. For instance, I have a field named “Date seen” (which is manually filled in) and another field named “Due Date”. I’m trying to auto-populate the “Due Date” field so that it auto-populates with a date exactly 6 years after the “Date Seen” field.
I can do the first bit (ABC-DE001-FG-) but Im unable to find a way to get the information from another field (Date) to the end of this auto generated unique reference ID.
the problem is when you click select it will not auto input the date