By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,319 Members | 2,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,319 IT Pros & Developers. It's quick & easy.

MS Access 2002 Switchboard manager problem

P: n/a
Can you help me?
I have 9 forms in the base. 2 forms are opening as single and 7 as
datasheet. Thats OK, but when I used Switchboard manager, with him all of my
forms are opened as single. How can I solve this problem. Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Dejan,

When opened from another form, the second form must be
opened specifically in Datasheet View.

If this switchboard was made using the Add-in Switchboard manager, as
I suspect, you can add a command to the switchboard code to open the
form in Datasheet View.
Here's how.

Open the Switchboard in design view.
Open the Code window and find the

Private Function HandleButtonClick(intBtn As Integer) function.

Add the following to the list of Constants already there:

Const conCmdOpenFormDS = 9
(Note: I've used 9, however check to see what the highest Const number
already in use by the code is.
It may or may not be 8. Use the next higher number.)

Scroll down within this function until you come to

Select Case rst.Command

with it's series of Case statements.
Add the following to the series, just before the Case Else statement:

' Open Form in Datasheet View
Case conCmdOpenFormDS
DoCmd.OpenForm rst![Argument], acFormDS

Next, open the Switchboard Items Table and find the form name in the
Argument field that you wish to open.
Change that record's Command field number (it's probably a 2) to a 9.
Save the table change.

Open the switchboard. Your form should
now open in Datasheet view when you click the command button.

Hope this has helped.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Dejan M." <de*****@blic.net> wrote in message
news:bo**********@ariane.blic.net...
Can you help me?
I have 9 forms in the base. 2 forms are opening as single and 7 as
datasheet. Thats OK, but when I used Switchboard manager, with him all of my forms are opened as single. How can I solve this problem. Thanks!

Nov 12 '05 #2

P: n/a
if you want to continue using the switchboard, you need to create a
new type of command (ie. open form in DS mode)

go to the switchboard form, view code
go to the HandleButtonClick event code
create a new constant
Const conCmdOpenFormDS = 9

add this code to the case statement
Case conCmdOpenFormDS
DoCmd.OpenForm rst![Argument],acFormDS,,,acAdd

go to the switchboard items table and change the 'command' field to 9
for the 2 forms that should open in DS mode
note. the switchboard wizard won't know about this new command (9)

the alternative is to create a 'menu form' with 9 command buttons that
open the forms as required

"Dejan M." <de*****@blic.net> wrote in message news:<bo**********@ariane.blic.net>...
Can you help me?
I have 9 forms in the base. 2 forms are opening as single and 7 as
datasheet. Thats OK, but when I used Switchboard manager, with him all of my
forms are opened as single. How can I solve this problem. Thanks!

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.