MS Access 2002 Switchboard manager problem

[Dejan M.]

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!

[Fredg]

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 HandleButtonCli ck(intBtn As Integer) function.

Add the following to the list of Constants already there:

Const conCmdOpenFormD S = 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 conCmdOpenFormD S
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.n et> 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!

[Roger]

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 HandleButtonCli ck event code
create a new constant
Const conCmdOpenFormD S = 9

add this code to the case statement
Case conCmdOpenFormD S
DoCmd.OpenForm rst![Argument],acFormDS,,,acA dd

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.n et> 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!