Multiple users

Resolved · Low Priority · Version 2003

Thu 19 Aug 2010, 15:47 Delegate Elisya said...

Elisya has attended:
Access Advanced course
Access Intermediate course

Multiple users

With multiple users editing the same record, is it possible to have an automated date stamp + user initials each time a record is edited?

Tue 31 Aug 2010, 16:28 Trainer Simon said...

RE: Multiple users

Hi Elisya,

Thank you for your question.

I believe there is no way of achieving this using Access in the front end of the database.

Please find a link below that has answers with VBA code:

http://thedailyreviewer.com/office/view/record-the-date-and-time-of-record-change-106207953

I hope this helps.

Regards

Simon

Tue 7 Sep 2010: Automatically marked as resolved.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Multiple users

Multiple users

RE: Multiple users

Access articles

Access tip:

Prefixed Autonumbering