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

Beginner: Open Main Switchboard Item in Datasheet view?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.