Follow via:
RSS
Email Alert
Question
0 Votes
+ -

Access: how can I set the date and time when a record is saved in a form?

hi, could you please help me? I need to keep the record when a form is saved on access. I know how to save the time and date when a new record is open but what I need is to keep the record of date and time when the form is saved.
Tags: software
28th Nov 2011

Answers (1)

0 Votes
+ -
Puzzled.
On a new record you'd set your date time column to now.
On an update you set it to now.
Pick a suitable event. BeforeRecordUpdate, should do it.
29th Nov 2011
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.