The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Open event

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Open event

Resolved · Medium Priority · Version 2007

ReplyWed 17 Mar 2010, 15:46Delegate Aquila said...

Open event

Hi.

I want my workbook to be on a specified sheet when it is opened. How would I go about doing this? Would it be in my macro codes, or is there a excel setting for this?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 17 Mar 2010, 16:17Trainer Stephen said...

RE: Open event

Hi Aquila

Thanks for the question

In the project explorer select the "ThisWorkbook" object.

Select the Workbook object (from the left hand combo above the code window). This will automatically create an on open event.

Then write the code to select the worksheet, e.g

sheets(2).select

Hope this helps

Regards

Stephen

Wed 24 Mar 2010: Automatically marked as resolved.

Access articles

· Different Ways To Use Forms In Access 2007
· Microsoft Access Courses
· Get More Out of MS Access Courses
· How To Use The New Navigation Form In Access 2010
· Create A Simple Form In Access

Please browse our web site to find out more about
microsoft access 2002 training and other Microsoft training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips

If you base a query on a form, and you change the query why does it not reflect in the form? How can this be done?

» Forum post: Acess

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions