Opening a form from switchboard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave_FFM - 17 May 2007 16:29 GMT

Hi,
I have tried answers given to similar questions on here to no avail, so
maybe you can help me.
I am trying to open a form from a switchboard in datasheet view, although
when i try this it opens as a single form. I have set the properties on the
form to show datasheet only and this still does not work. When i open the
form normally it will open in datasheet view and it's only from the
switchboard that i'm having trouble. I only want one of my forms to do this.

Thanks in advance

Dave FFM

Reply to this Message

BruceM - 17 May 2007 16:53 GMT

It would have helped had you mentioned what you have tried, and posted the
code you are using to open the form. The code behind the command button
should be something like:
DoCmd.OpenForm "FormName", acFormDS

If you are using the switchboard wizard or manager or whatever it's called,
I don't think I can help. I think it uses macros, with which I am
unfamiliar. In any case I haven't used the switchboard manager since some
early Access lessons.

> Hi,
> I have tried answers given to similar questions on here to no avail, so
[quoted text clipped - 10 lines]
>
> Dave FFM

Reply to this Message

Dave_FFM - 18 May 2007 11:11 GMT

It would help me if you had actually read my original post. I stated that i
had set the form properties to "datasheet view" only, and yes i am using the
Switchboard Manager. The code for the switchboard will be the default for
opening a form in edit mode, and all i really wanted to know is if the code
needed to be changed anywhere and what it should be changed to. If you don't
know how to use the switchboard then what was the point in posting?

> It would have helped had you mentioned what you have tried, and posted the
> code you are using to open the form. The code behind the command button
[quoted text clipped - 20 lines]
> >
> > Dave FFM

Reply to this Message

BruceM - 18 May 2007 12:28 GMT

Go back and read YOUR original posting. You mentioned a switchboard, but
not that you had set it up using the switchboard manager. You mentioned
that the code wasn't working, but not what the code actually is. You
assumed that your few words contain all of the necessary information, when
in fact they could mean any number of things.
Now take the time to look at my reply. I pointed out that your OP was short
on details, but that given a certain set of assumptions there was something
you could try; given another set of assumptions I couldn't really suggest
anything.

> It would help me if you had actually read my original post. I stated that
> i
[quoted text clipped - 36 lines]
>> >
>> > Dave FFM

Reply to this Message

Dave_FFM - 18 May 2007 13:25 GMT

Points noted. Sorry i didn't mean to be like that just had a bad morning.
I'll post more detail next time. Sorry again

> Go back and read YOUR original posting. You mentioned a switchboard, but
> not that you had set it up using the switchboard manager. You mentioned
[quoted text clipped - 46 lines]
> >> >
> >> > Dave FFM

Reply to this Message

BruceM - 18 May 2007 15:08 GMT

I appreciate your reply. My morning didn't get off to such a hot start
either, or I would probably have simply said to myself "Hmm. Somebody's
having a bad day."

> Points noted. Sorry i didn't mean to be like that just had a bad morning.
> I'll post more detail next time. Sorry again
[quoted text clipped - 60 lines]
>> >> >
>> >> > Dave FFM

Reply to this Message

KARL DEWEY - 18 May 2007 00:39 GMT

Have switchboard call a macro and it open the form in datasheet view.

Signature

KARL DEWEY
Build a little - Test a little

> Hi,
> I have tried answers given to similar questions on here to no avail, so
[quoted text clipped - 8 lines]
>
> Dave FFM

Reply to this Message

Dave_FFM - 18 May 2007 11:17 GMT

Thanks very much, works a treat

> Have switchboard call a macro and it open the form in datasheet view.
>
[quoted text clipped - 10 lines]
> >
> > Dave FFM

Reply to this Message