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

Forms and the Switchboard

P: n/a
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
rkc

"aaaaaa" <aa**@ntlworld.com> wrote in message
news:ng********************@newsfep2-win.server.ntli.net...
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view


If you go into design view of the switchboard form and take a look
at the code behind it you will see that the forms are opened using
DoCmd.OpenForm with no argument for veiw type. Since there
is no argument supplied, the view defaults to form view. This is true
even if the form is set to datasheet-true and allow form view-false in
it's own property sheet.

You may have to edit the switchboard code if you want a form to
open in datasheet view.

Nov 12 '05 #2

P: n/a
aaaaaa wrote:
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view

Thanks

If it a switchboard you created using an unbound form with command
buttons, you must specify Datasheet view in the OpenForm argument:
DoCmd.OpenForm "FormName", acFormDS

If the switchboard is one created using the Access Switchboard wizard,
there is quite a bit more work you must do. Post back if this is the
switchboard used and I'll dig out the information for you.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
Nov 12 '05 #3

P: n/a
"rkc" <rk*@yabba.dabba.do.rochester.rr.nope> wrote in message news:<A9******************@twister.nyroc.rr.com>.. .
"aaaaaa" <aa**@ntlworld.com> wrote in message
news:ng********************@newsfep2-win.server.ntli.net...
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view


If you go into design view of the switchboard form and take a look
at the code behind it you will see that the forms are opened using
DoCmd.OpenForm with no argument for veiw type. Since there
is no argument supplied, the view defaults to form view. This is true
even if the form is set to datasheet-true and allow form view-false in
it's own property sheet.

You may have to edit the switchboard code if you want a form to
open in datasheet view.


I also would like to know the answer to this. How do we go about
'editing the switchboard code' to make it load in datasheet view?

Terry
Nov 12 '05 #4

P: n/a
fredg wrote:
aaaaaa wrote:
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view

Thanks

If it a switchboard you created using an unbound form with command
buttons, you must specify Datasheet view in the OpenForm argument:
DoCmd.OpenForm "FormName", acFormDS

If the switchboard is one created using the Access Switchboard wizard,
there is quite a bit more work you must do. Post back if this is the
switchboard used and I'll dig out the information for you.


It's make more sense, if it's added work, to follow your Docmd example by
placing it into a module as a function and call the Form by running code or a
macro,
Nov 12 '05 #5

P: n/a
"rkc" <rk*@yabba.dabba.do.rochester.rr.nope> wrote in message news:<A9******************@twister.nyroc.rr.com>.. .
"aaaaaa" <aa**@ntlworld.com> wrote in message
news:ng********************@newsfep2-win.server.ntli.net...
Hi,
I created some forms and during the wizard I chose the Datasheet View,
and when I open the forms from the main objects window they open up in
datasheet view. But when I created a switchboard which opens the same
form it doesnt load them in datasheet, it loads them in other, columnar
(me thinks), view.
Is there a way to make the switchboard load these forms in a simple
datasheet view


If you go into design view of the switchboard form and take a look
at the code behind it you will see that the forms are opened using
DoCmd.OpenForm with no argument for veiw type. Since there
is no argument supplied, the view defaults to form view. This is true
even if the form is set to datasheet-true and allow form view-false in
it's own property sheet.

You may have to edit the switchboard code if you want a form to
open in datasheet view.

I've found a solution! Edit the switchboard code as follows:

Open switchboard in Design View, click on Code in the toolbar, scroll
down to 'Open a form, change the code from:

DoCmd.OpenForm rs![Argument]
to:

DoCmd.OpenForm rs![Argument], acFormDS

This works on my 2K Access.

Terry
Nov 12 '05 #6

P: n/a
Terry wrote:
I've found a solution! Edit the switchboard code as follows:

Open switchboard in Design View, click on Code in the toolbar, scroll
down to 'Open a form, change the code from:

DoCmd.OpenForm rs![Argument]
to:

DoCmd.OpenForm rs![Argument], acFormDS

This works on my 2K Access.

Terry


Instead of messing with the switchboard code Much easier to follow and cleaner. Few people need or want to mess
with the generated switchboard code. And if you even need to rebuild it you may forget to add the DS again.
Nov 12 '05 #7

P: n/a
Salad wrote:
Terry wrote:
I've found a solution! Edit the switchboard code as follows:

Open switchboard in Design View, click on Code in the toolbar, scroll
down to 'Open a form, change the code from:

DoCmd.OpenForm rs![Argument]
to:

DoCmd.OpenForm rs![Argument], acFormDS

This works on my 2K Access.

Terry


Instead of messing with the switchboard code Much easier to follow and cleaner. Few people need or want to mess
with the generated switchboard code. And if you even need to rebuild it you may forget to add the DS again.


I meant to say use RUN MACRO or RUN CODE in the switchboard.
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.