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

access

ResolvedVersion 2007

Linda has attended:
Access Intermediate course

Access

How to create a form

RE: Access

Hi Linda, thanks for your query. The simplest way to do this is to use the Autoform tool. When you open a table, or one generated by a query, look on your toolbar for the table icon with the lightning bolt on it. That is the Autoform tool and when you click it a form will be automatically generated.

Hope this helps,

Anthony

Tue 4 May 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.