Auto-Update for dates

S

style214

I am still fairly new to building Access databases, and I have ran into
a problem I cannot find any information on.

I have a database that houses several different pieces of data, and I
am trying to set it up so certain information is automatically updated.


The first one:

I want to pull a date from one field insp_date, when a radio button is
checked, and add 1 month to it, and drop that date into another column,
grndchk_date. A coworker suggested doing this via the form, but I do
not know how to do this. I only want this to occur if the radio button
is checked. I currently have the field set to a Yes/No option.

The second one:

I want to pull the same inspection date, and output to a separate field
based off of one of 3 options. These options would add either 90 days,
1 year, or 3 years.

I would guess that if I can get a solution to the first one, I can
modify it to use it for the other 3 options. I am not a complete expert
on this, so any help would be greatly appreciated. If there is any
further information needed, please let me know.
 
V

Vande

Can it be set to automatically do the update and add the information to
the field in the database from the form?
 
V

Vande

I need the information in both output locations to update whenever the
original date is updated. The first one will only be used in specific
cases, but the second set, the 3 possible categories, are required for
all the entries in the database. There will be a limited number of
users accessing this database, and I am working to eliminate the human
factor, and also to use this a build up to a future addition that will
push tasks out to Outlook to automate scheduling inspections. I am
looking at the options on how to get the dateadd function to only run
when the radio button is checked, to see if I can do this simple, or if
I am going to have to try and build a Vbscript to do all of this.
 
V

Vande

I will still need to find how to pull a date based off of a separate
fields data. By only running it in the queries, forms and reports, it
seems like it would end up with a lot of extra code, but with doing the
calculations in the actual input form, I would not have to worry about
it. My biggest problem is I still have not been able to get the code to
work just using the dateadd function...any suggestions?
 
Top