|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 14th, 2010, 02:58 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Date Increase
I currently have a form for entering current passwords for systems. I have a
field to enter the date the password was last changed, and another field for the date the password expires, which is every 30 days. Is there anyway i can set the date password expires field to update automatically? 
|
|
#2
January 14th, 2010, 03:32 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Date Increase
The 2nd field is just calculated from the 1st and better left as a
calculation in a query rather than a field in a table. There are no triggers at the table level in Access. Dan Wood wrote: I currently have a form for entering current passwords for systems. I have a field to enter the date the password was last changed, and another field for the date the password expires, which is every 30 days. Is there anyway i can set the date password expires field to update automatically? -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1
|
|
#3
January 14th, 2010, 04:52 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Date Increase
On Wed, 13 Jan 2010 18:58:02 -0800, Dan Wood
wrote: Is there anyway i can set the date password expires field to update automatically? The expires field should simply *not exist*. Instead use a calculated field in a query: Expires: DateAdd("d", 30, [dateset]) or use the same expression in the control source of a textbox. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
