Beginner: Open Main Switchboard Item in Datasheet view?

[Terry]

I have created a Main Switchboard in Access 2000 and it has a button
which opens a Form. I have set the form Properties Default View to
Datasheet and this always opens in datasheet view.

When I open the Form from the Main Switchboard it always opens in form
view.

Can this be changed so that it always opens in Datasheet View?

Terry

[Karina]

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...

I have created a Main Switchboard in Access 2000 and it has a button
which opens a Form. I have set the form Properties Default View to
Datasheet and this always opens in datasheet view.

When I open the Form from the Main Switchboard it always opens in form
view.

Can this be changed so that it always opens in Datasheet View?

Terry

Change the code of the OnClick event of your command button on the
Switchboard to the following:

DoCmd.OpenForm "YourFormName", acFormDS

Also see Access Help under OpenForm Method. There it explains the
different views for opening forms, by default it is acNormal (Form
view).

Karina

[Terry]

ka*****@iprimus.com.au (Karina) wrote in message news:<fc**************************@posting.google. com>...

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...

I have created a Main Switchboard in Access 2000 and it has a button
which opens a Form. I have set the form Properties Default View to
Datasheet and this always opens in datasheet view.

When I open the Form from the Main Switchboard it always opens in form
view.

Can this be changed so that it always opens in Datasheet View?

Terry

Change the code of the OnClick event of your command button on the
Switchboard to the following:

DoCmd.OpenForm "YourFormName", acFormDS

Also see Access Help under OpenForm Method. There it explains the different views for opening forms, by default it is acNormal (Form
view).

Karina

I put the following code in the OnClick Event for the command button
as you suggested:

DoCmd.OpenForm "Tets Taken", acFormDS

but it has no effect, the Form still opened in Form view. After
reading the Access Help on OpenForm Action I also tried usimg a Macro
to set the OpenForm Action View to Datasheet. This also had no effect.
The Form still opened in Form view.

Terry

[Karina]

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...

ka*****@iprimus.com.au (Karina) wrote in message news:<fc**************************@posting.google. com>...

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...

I have created a Main Switchboard in Access 2000 and it has a button
which opens a Form. I have set the form Properties Default View to
Datasheet and this always opens in datasheet view.

When I open the Form from the Main Switchboard it always opens in form
view.

Can this be changed so that it always opens in Datasheet View?

Terry

Change the code of the OnClick event of your command button on the
Switchboard to the following:

DoCmd.OpenForm "YourFormName", acFormDS

Also see Access Help under OpenForm Method. There it explains the

different views for opening forms, by default it is acNormal (Form
view).

Karina

I put the following code in the OnClick Event for the command button
as you suggested:

DoCmd.OpenForm "Tets Taken", acFormDS

but it has no effect, the Form still opened in Form view. After
reading the Access Help on OpenForm Action I also tried usimg a Macro
to set the OpenForm Action View to Datasheet. This also had no effect.
The Form still opened in Form view.

Terry

I've tested this on different forms and it always works. I can't think
of why it wouldn't work for you. Maybe create a simple test form and
open it through a command button from another form with the above
code. If this works there might be a problem with your "Tets Taken"
form. That's all I can think of at the moment.

Karina

[Terry]

ka*****@iprimus.com.au (Karina) wrote in message news:<fc**************************@posting.google. com>...

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...

ka*****@iprimus.com.au (Karina) wrote in message news:<fc**************************@posting.google. com>...

tc*****@merseymail.com (Terry) wrote in message news:<38**************************@posting.google. com>...
> I have created a Main Switchboard in Access 2000 and it has a button
> which opens a Form. I have set the form Properties Default View to
> Datasheet and this always opens in datasheet view.
>
> When I open the Form from the Main Switchboard it always opens in form
> view.
>
> Can this be changed so that it always opens in Datasheet View?
>
> Terry
Change the code of the OnClick event of your command button on the
Switchboard to the following:

DoCmd.OpenForm "YourFormName", acFormDS

Also see Access Help under OpenForm Method. There it explains the

different views for opening forms, by default it is acNormal (Form
view).

Karina

I put the following code in the OnClick Event for the command button
as you suggested:

DoCmd.OpenForm "Tets Taken", acFormDS

but it has no effect, the Form still opened in Form view. After
reading the Access Help on OpenForm Action I also tried usimg a Macro
to set the OpenForm Action View to Datasheet. This also had no effect.
The Form still opened in Form view.

Terry

I've tested this on different forms and it always works. I can't think
of why it wouldn't work for you. Maybe create a simple test form and
open it through a command button from another form with the above
code. If this works there might be a problem with your "Tets Taken"
form. That's all I can think of at the moment.

Karina

Will do. I'll get back as soon as I can. Must rush off now. Thanks.

Terry