Opening MSAccess Form from Desktop shortcut without Access window itself opening

[goels]

Hi all,

I have an MS Access form which is used to display reports according to the combination chosen in it's combo boxes. I wanted to know if there is a way in which i could create a shortcut for the form on my desktop so that whenever i click it the form opens but without the accompanying window of MS Access. I have tried creating an autoexec macro which opens this form in the 'Dialog' view and have set the 'Dont display databse window' in startup but still the main Access window is displayed.

Chow
Goels

 

[JinaneKarhani]

why don't u change some properties of the form:
In other, change the pop-up to yes
& in ONOpen Event Put the code DoCmd.Maximise

it will work just fine.

 

[yeatmanj]

The don't display database window is referring to the window that shows queries, forms, tables, etc. not Access itself. Also, 'dialog' view is really only for changing the border type of the form.

There is a way to remove the access and just see the forms but it requires development steps that make the database more of a stand alone program. I am not familiar with the methods, but I'm sure someone else here is.

Also, this isn't really a module question. It belongs in forms or general. Probably general.