microsoft/access/training/courses - On Starting Database, show specific form

Resolved · Low Priority · Version Standard

Tue 27 Nov 2007, 13:06 Delegate Paul said...

Paul has attended:
Access Intermediate course
Access Advanced course

On Starting Database, show specific form

How do I tell Access to open a specific form (The Menu) when I open my database?

Tue 27 Nov 2007, 14:03 Trainer Pete said...

RE: On Starting Database, show specific form

Hi Paul, Thanks for your post, I hope you have enjoyed your Training with Best Training. In response to your question there are 2 ways in which this can be accomplished.
1. From the Database window, choose the Menu option Tools, Startup, in the dialog box that appears, from the right hand Text box drop down, choose the form that you wish to display, (The Menu). The next time you open that database the form will display automatically.
2. Create an AutoExec macro (name your macro AutoExec) which opens a Form of your choice, (The Menu) then when you open the database, Access will run the Macro before anything else.
3. There is another method which would entail you creating a Switchboard, on the switchboard you would have a click option to open your chosen Form.
Hope that helps, regards Pete.

Tue 27 Nov 2007, 14:23 Delegate Paul said...

RE: On Starting Database, show specific form

Thanks Pete

It was the Auto Exec that Carlos told me on my course, but I had forgotten it!!

Thanks Again

Paul

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds