470,836 Members | 1,880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,836 developers. It's quick & easy.

Beginner: Open Main Switchboard Item in Datasheet view?

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
Nov 12 '05 #1
4 9195
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
Nov 12 '05 #2
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
Nov 12 '05 #3
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
Nov 12 '05 #4
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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ogilby1 | last post: by
1 post views Thread by Simon Matthews | last post: by
2 posts views Thread by existential.philosophy | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.