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

Problem getting datasheet view in forms

P: n/a
Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don
Dec 13 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
If you open the form programmatically, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dw******@gmail.comwrote in message
news:c3**********************************@e10g2000 prf.googlegroups.com...
Hi Group,

I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.

Regards

Don
Dec 13 '07 #2

P: n/a
On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
If you open the form programmatically, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<dwasb...@gmail.comwrote in message

news:c3**********************************@e10g2000 prf.googlegroups.com...
Hi Group,
I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.
Regards
Don- Hide quoted text -

- Show quoted text -
Thank you Allen
Dec 13 '07 #3

P: n/a
On Dec 13, 8:03 am, "dwasb...@gmail.com" <dwasb...@gmail.comwrote:
On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:


If you open the form programmatically, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<dwasb...@gmail.comwrote in message
news:c3**********************************@e10g2000 prf.googlegroups.com...
Hi Group,
I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.
Regards
Don- Hide quoted text -
- Show quoted text -

Thank you Allen- Hide quoted text -

- Show quoted text -
The generic switchboard maintenance does not allow for that type of
open.

One way around that is to create a blank form and place your designed
form on it as a child form and make them the same size and then have
the switchboard open the blank form (obviously with a specific name).

Ron
Dec 13 '07 #4

P: n/a
On 13 Dec, 19:08, Ron2006 <ronne...@hotmail.comwrote:
On Dec 13, 8:03 am, "dwasb...@gmail.com" <dwasb...@gmail.comwrote:


On Dec 13, 1:05 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
If you open the form programmatically, you need to specify the view you
want, e.g.:
DoCmd.OpenForm "Form1", acFormDS
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<dwasb...@gmail.comwrote in message
>news:c3**********************************@e10g200 0prf.googlegroups.com...
Hi Group,
I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets. Although I
have the default view set to datasheet and when opened directly the
form opens in datasheet view, as soon as I try to open the same form
from the mainenance switchboard it opens in single form view. I'm
using Access 2000. Sorry if its a basic error on my part but cant see
what I've missed.
Regards
Don- Hide quoted text -
- Show quoted text -
Thank you Allen- Hide quoted text -
- Show quoted text -

The generic switchboard maintenance does not allow for that type of
open.

One way around that is to create a blank form and place your designed
form on it as a child form and make them the same size and then have
the switchboard open the blank form (obviously with a specific name).

Ron- Hide quoted text -

- Show quoted text -
Ron,

Many thanks for your reply, I did try that but although it did work it
meant I had more forms than I really wanted. I've now had a chance to
use Allens suggestion and that works fine.

Many thanks to you both.

Regards

Don
Dec 14 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.