Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access 2003 / 2007 Forms

Resolved · High Priority · Version 2003

Reply Tue 23 Mar 2010, 16:23Delegate Pete said...

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 25 Mar 2010, 16:41Trainer Anthony said...

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.

Access articles

· Why Do I Need To Use Access?
· So You Want To Create Forms In Access 2007?
· Keeping Your Access Database Updated
· Making The Transition To Access - Why You Might Need It
· Growing A Customer Base For A New Business - With The Help Of Access

Please browse our web site to find out more about
access course and other Microsoft training courses.

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.

View all Access hints and tips