Quick Links ▼

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft access courses - Forms

Resolved · Low Priority · Version Standard

Reply Fri 29 Jun 2007, 10:57Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Fri 13 Jul 2007, 12:19Trainer 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 articles

· Mining For Data With Access
· Microsoft Access: Unleash the True Potential Today
· How To Filter And Sort Data In Access 2010 Tables
· User-Proofing Your Access Database: Part 2
· How To Understand Access As A Relational Database

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips