Problem Switchbboard and data sheet view

[Steve]

I have a button in the switchboard that opens a form showing a single record
form the table. I have set the form to Default View to Datasheet. When I
open the form, it open as a datasheet which is the way I want it. When I
open it with the swichboard button, it opens as a single record.

I'm missing something, how do I set the switcboard button to also open it as
a datasheet?

Thanks, Steve

 

[Joseph Meehan]

I have a button in the switchboard that opens a form showing a single
record form the table. I have set the form to Default View to
Datasheet. When I open the form, it open as a datasheet which is the
way I want it. When I open it with the swichboard button, it opens
as a single record.

I'm missing something, how do I set the switcboard button to also
open it as a datasheet?

Thanks, Steve

What exactly is that button doing? Is it running a macro (macros have
an option to open in datasheet) or code (how about posting that) or what?

 

[Steve]

In the switchboard, the Command line reads: "Open Form in Edit Mode"

Steve

 

[Jeff Conrad]

See this page on my site:

http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#datasheet

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[fredg]

I have a button in the switchboard that opens a form showing a single record
form the table. I have set the form to Default View to Datasheet. When I
open the form, it open as a datasheet which is the way I want it. When I
open it with the swichboard button, it opens as a single record.

I'm missing something, how do I set the switcboard button to also open it as
a datasheet?

Thanks, Steve

Regardless of the Default View setting of a form, if you wish to open
it from a command button event you MUST specify datasheet view.

Using code it would be:
DoCmd.OpenForm "FormName", acFormDS

If you are using the built in Access switchboard, you need to change
the code. Open the form's Code window.
Find the HandleButton_Click function and add the following to the list
of Constants:
Const conCmdOpenFormDS = 9

Then, further down in the code, add the following to the Select Case
statement:

Case conCmdOpenFormDS
DoCmd.OpenForm rst![Argument], acFormDS

Save the changes.
Open the Switchboard Items table. Find the table name that you wish to
open in datasheet view and change it's Command value from 3 to 9.

 

[Steve]

Thanks to all... I got it working with Fred directions.

Steve

I have a button in the switchboard that opens a form showing a single record
form the table. I have set the form to Default View to Datasheet. When I
open the form, it open as a datasheet which is the way I want it. When I
open it with the swichboard button, it opens as a single record.

I'm missing something, how do I set the switcboard button to also open it as
a datasheet?

Thanks, Steve

Regardless of the Default View setting of a form, if you wish to open
it from a command button event you MUST specify datasheet view.

Using code it would be:
DoCmd.OpenForm "FormName", acFormDS

If you are using the built in Access switchboard, you need to change
the code. Open the form's Code window.
Find the HandleButton_Click function and add the following to the list
of Constants:
Const conCmdOpenFormDS = 9

Then, further down in the code, add the following to the Select Case
statement:

Case conCmdOpenFormDS
DoCmd.OpenForm rst![Argument], acFormDS

Save the changes.
Open the Switchboard Items table. Find the table name that you wish to
open in datasheet view and change it's Command value from 3 to 9.