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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Forms

microsoft access courses - Forms

ResolvedVersion Standard

Fri 29 Jun 2007, 10:57 Delegate Stacie said...

Stacie has attended:
Access Intermediate course

Forms

I understand how to create a form that enables you to scroll through the data one at a time.

However, how do you create a form that opens as a front page when you open the database picks information from a queries or tables according to selected parameters selected on the from.

Stacie

Fri 13 Jul 2007, 12:19 Trainer Andrew said...

RE: Forms

Hi Stacie

First create your form then from the Tools menu choose Startup...
This dialogue box allows you to select your form so it opens when Access is launched.

I hope this helps - let us know if we can be of further assistance.

Kind regards,

Andrew

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

microsoft access courses - Forms

Forms

RE: Forms

Access articles

Access tip:

Prefixed Autonumbering