Form shortcut to open in data sheet

[BFish via AccessMonster.com]

I have some users that for simplicity sake I have created a desktop shortcut
to open the only form in the db that is of use to them. This form is a data
sheet default, but when opened with the shortcut it will only open in form
view. I have tried DoCmd.open in the on open event to no avail. Is there a
way around this problem?

Thanks,

Bill Fischer

 

[Guest]

You have to specifically specify in the openform method that you want to
display the form in datasheet mode e.g.:

DoCmd.OpenForm "frmMyForm", acFormDS

HTH
Good luck

 

[BFish via AccessMonster.com]

Sorry I wasn't clear, but yes did previously use the full statement and
received run-time error 2174----You can not switch to different view at this
time. Which after I figured with Access Help that it is not possible to open
a form with DoCmd.Open with this event in this way.

Even though this form is set to open as a datasheet (and will do when called
on from the database window) it looks like by default it will only open in
form view when called from a shortcut. I was hoping there is a work around
or back door approach to accomplish this end.

Thanks,

Bill

You have to specifically specify in the openform method that you want to
display the form in datasheet mode e.g.:

DoCmd.OpenForm "frmMyForm", acFormDS

HTH
Good luck

I have some users that for simplicity sake I have created a desktop shortcut
to open the only form in the db that is of use to them. This form is a data

[quoted text clipped - 5 lines]

Bill Fischer

 

[Guest]

Oh...so you just right clicked on the form in the database window and
selected create shortcut? If you right click on the shortcut it gives you a
choice of how to open the form (datasheet, design...). You might be able to
modify the shortcut if you open it with notpad not get rid of the right click
and directly do this in the left click.
Besides that I would suggest creating a shortcut to the db rather then an
individual object and setting the form to come up under tools--startup...!
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de

Sorry I wasn't clear, but yes did previously use the full statement and
received run-time error 2174----You can not switch to different view at this
time. Which after I figured with Access Help that it is not possible to open
a form with DoCmd.Open with this event in this way.

Even though this form is set to open as a datasheet (and will do when called
on from the database window) it looks like by default it will only open in
form view when called from a shortcut. I was hoping there is a work around
or back door approach to accomplish this end.

Thanks,

Bill

You have to specifically specify in the openform method that you want to
display the form in datasheet mode e.g.:

DoCmd.OpenForm "frmMyForm", acFormDS

HTH
Good luck

I have some users that for simplicity sake I have created a desktop shortcut
to open the only form in the db that is of use to them. This form is a data

[quoted text clipped - 5 lines]

Bill Fischer