access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2003 / 2007 Forms

Access 2003 / 2007 Forms

resolvedResolved · High Priority · Version 2003

Pete has attended:
Access Intermediate course
Excel Advanced course

Access 2003 / 2007 Forms

I'd like to attach a permanent, uneditable stamp on a record once its entered - date&time record first entered, and the initials/name of the person who entered it, from a drop down menu. How can I make sure that this initial stamp isn't changed?

RE: Access 2003 / 2007 Forms

Hi Pete, thanks for your query. When the user enters the information into the form and it is submitted, simply include a few more bits of information to be added to the database behind the scenes. I think we discussed lifting the user name from the local profile of the machine, but this might be using a sledgehammer to crack a nut. Provide an "initials" textbox on the form and make it a required field, then append whatever the user puts into the text box that to the record when the form is submitted. Same with the date, all though remember you could append "=now()" to a date field on the record to automate this.

Hope this helps,

Anthony

Thu 1 Apr 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Server loaded in 0.08 secs.