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

how to force form to load in datasheet view

P: n/a
I am using a switchboard to load a form that I would like to display in
datasheet view or table view. But it does not go into that mode when using
the switchboard wizard to launche the form.

is there a way to set this on the form's load property?
Danny
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hotmail.com> wrote:
I am using a switchboard to load a form that I would like to display in
datasheet view or table view. But it does not go into that mode when using
the switchboard wizard to launche the form.

is there a way to set this on the form's load property?
Danny


Just have the switchboard call a macro or a VB procedure that opens the form
in Datasheet view. Works like a charm.
Nov 13 '05 #2

P: n/a
Thanks

how can I call the function with a parameter. Also, where do I put this
function?
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:7h********************************@4ax.com...
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hotmail.com> wrote:
I am using a switchboard to load a form that I would like to display in
datasheet view or table view. But it does not go into that mode when usingthe switchboard wizard to launche the form.

is there a way to set this on the form's load property?
Danny

Just have the switchboard call a macro or a VB procedure that opens the

form in Datasheet view. Works like a charm.

Nov 13 '05 #3

P: n/a
Just create a function or macro to open the specific form in question, and
call that macro or function. When you need another one, add another one.

On Fri, 16 Jul 2004 17:08:45 GMT, "Danny" <da********@hotmail.com> wrote:
Thanks

how can I call the function with a parameter. Also, where do I put this
function?
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:7h********************************@4ax.com.. .
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hotmail.com> wrote:
>I am using a switchboard to load a form that I would like to display in
>datasheet view or table view. But it does not go into that mode whenusing >the switchboard wizard to launche the form.
>
>is there a way to set this on the form's load property?
>Danny
>


Just have the switchboard call a macro or a VB procedure that opens the

form
in Datasheet view. Works like a charm.


Nov 13 '05 #4

P: n/a
Actually, an easier way might be to set the form's property sheet on
the Format tab to 'Allow Form View' = False, and 'Allow Datasheet
View' = True.

James

Steve Jorgensen <no****@nospam.nospam> wrote in message news:<7h********************************@4ax.com>. ..
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hotmail.com> wrote:
I am using a switchboard to load a form that I would like to display in
datasheet view or table view. But it does not go into that mode when using
the switchboard wizard to launche the form.

is there a way to set this on the form's load property?
Danny


Just have the switchboard call a macro or a VB procedure that opens the form
in Datasheet view. Works like a charm.

Nov 13 '05 #5

P: n/a
That would be easier, except it doesn't work. The DoCmd.OpenForm (which is
what the Switchboard uses), overrides any and all form settings regarding what
views to show, allow, and disallow. It overrides these things with its
default values if no parameters are specified, so there is simply no way to do
it with Form properties alone.

On 16 Jul 2004 21:39:02 -0700, dr*********@hotmail.com (James) wrote:
Actually, an easier way might be to set the form's property sheet on
the Format tab to 'Allow Form View' = False, and 'Allow Datasheet
View' = True.

James

Steve Jorgensen <no****@nospam.nospam> wrote in message news:<7h********************************@4ax.com>. ..
On Fri, 16 Jul 2004 14:58:21 GMT, "Danny" <da********@hotmail.com> wrote:
>I am using a switchboard to load a form that I would like to display in
>datasheet view or table view. But it does not go into that mode when using
>the switchboard wizard to launche the form.
>
>is there a way to set this on the form's load property?
>Danny
>


Just have the switchboard call a macro or a VB procedure that opens the form
in Datasheet view. Works like a charm.


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.