ms access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

MS Access

resolvedResolved · Low Priority · Version 2003

replyReply Wed 18 Feb 2009, 16:27Delegate Rob said...

Rob has attended:
Access Introduction course

MS Access

How can I make Access open a specific form when the file is opened? Rather than being presented with tables, reports etc.

For upcoming training course dates see: Pricing & availability

replyReply Sun 22 Feb 2009, 23:08Trainer Rajeev said...

RE: MS Access

Dear Rob

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.


Yes it is possible to open a certain form as your start-up database object!!

Please follow these steps:

1. Open the database file where you would like the form to appear.

2. Choose the Tools > Start up...

3. In the Display Form/Page drop down arrow choose the form that you wish to appear when the database is opened! Press OK.

Close the Database and if neceassary close teh entire Access program.

When you open the database you'll notice that the form you set up in the start up dialog box opens automatically.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 2 Mar 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft-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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard