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

Opening form in datasheet view

P: n/a
I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.

Dec 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 21 Dec 2005 14:42:41 -0800, davegb wrote:
I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.


To open a form from an event, regardless of the form's default view
setting, you MUST specify datasheet view:

DoCmd.OpenForm "frmdtsCWEmployeeAll", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Dec 22 '05 #2

P: n/a

fredg wrote:
On 21 Dec 2005 14:42:41 -0800, davegb wrote:
I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of special command to get it to do this?
Right now, the button command is:

DoCmd.OpenForm "frmdtsCWEmployeeAll"

Why doesn't this open the form the same way I see it when I double
click on the form?
Thanks.


To open a form from an event, regardless of the form's default view
setting, you MUST specify datasheet view:

DoCmd.OpenForm "frmdtsCWEmployeeAll", acFormDS

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Thanks! Works great now.

Dec 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.