 |
| Access VBA Discuss using VBA for Access programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
October 12th, 2004, 03:50 PM
|
|
Authorized User
|
|
Join Date: Sep 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Opening Switchboard with VBA
Hi All,
Does anyone know how to open a switchboard (main switchboard / switchboard pages) using VBA. I have tried a couple of things but cant find anything that works.
Regards
Thanks
Rhys
|
|
October 13th, 2004, 12:26 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
What exactly are you trying to do?
Clive Astley
|
|
October 13th, 2004, 04:59 PM
|
|
Authorized User
|
|
Join Date: Sep 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
No Offense mate but how dull are you?
I think my first post describes what i am trying to do!
Quote:
|
quote:Does anyone know how to open a switchboard (main switchboard / switchboard pages) using VBA.
|
Doesnt this say to you that i am trying to opena switchboard . switchboard page with VBA (Visual Basic for Applications, you know when you press Alt-F11?)
Rhys
|
|
October 14th, 2004, 07:51 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sorry, I find your reply very offensive.
Switchboards are normally opened in Access automatically - set it in the startup properties dialog.
In VBA:
DoCmd.OpenForm ("switchboard")
where "switchboard" is the name of your switchboard form
Clive Astley
|
|
October 14th, 2004, 08:08 AM
|
|
Authorized User
|
|
Join Date: Sep 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Im sorry you find my reply offensive, but i dont care. You obviously didnt read my first post correctly!
I know how to open the switchboard, but how do i open the switchboard at a specified page?
|
|
October 20th, 2004, 01:40 PM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
What I don't understand is why you are using a switchboard at all. Custom forms are much more controllable and look and act better.
If you are not opening the switchboard from startup, then create a button with the button wizard and tell it to open that form (the switchboard name.) The button code attached to the button's onclick event is "DoCmd.OpenForm stDocName" where stDocName is the name of the switchboard, as rhysduk pointed out.
And try decaffeinated. :D
mmcdonal
|
|
October 20th, 2004, 04:56 PM
|
|
Authorized User
|
|
Join Date: Sep 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I know how to opena switchboard at the main switchboard page, you just open the switchboard with the DoCmd.OpenForm sytnax..
But i want to open the switchboard at a specified page, you know when you craete different pages within the Switchboard Manager? I want to open on one of these pages!!
Rhys
|
|
October 22nd, 2004, 08:34 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
I don't know what you mean by "page" then. Is that a form or a Report? Or is a "page" something else? I don't know why this would be a problem since the awful button manager does all that for you.
And why are you using switchboards and the switchboard manager? Ick. 
mmcdonal
|
|
February 5th, 2014, 12:31 AM
|
|
Registered User
|
|
Join Date: May 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
Originally Posted by rhysduk
I know how to opena switchboard at the main switchboard page, you just open the switchboard with the DoCmd.OpenForm sytnax..
But i want to open the switchboard at a specified page, you know when you craete different pages within the Switchboard Manager? I want to open on one of these pages!!
Rhys
|
Hi
An old post but still had to ask.. did you ever find a method to accomplish this?
|
|
|
