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

	98.1 % recommend us
	More live stats...

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

Training information:

Access 2007

Resolved · Low Priority · Version 2007

Reply Mon 28 Feb 2011, 16:41Delegate David said...

David has attended:
Access Introduction course

Access 2007

How can I add a date onto the heading on the form

For upcoming training course dates see: Pricing & availability

Reply Tue 1 Mar 2011, 13:06Trainer Simon said...

RE: Access 2007

Hi David,

Thank you for your question and welcome to the forum.

As I am training at a customer site today I do not have access to Microsoft Access.

However please use the link I have placed below:

http://office.microsoft.com/en-us/access-help/insert-the-date-and-time-into-a-form-or-report-HA010099588.aspx

I hope this helps you.

Let me know.

Regards

Simon

Tue 8 Mar 2011: Automatically marked as resolved.

Access articles

· An Essential Guide To Using The Northwind Database In Access 2010
· Get More Out of MS Access Courses
· How To Create Calculated Fields In Access 2010 Tables
· Cheating With Access Templates
· Find Microsoft Access Templates For Any Task

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

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

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy