Opening MSAccess Form from Desktop shortcut without Access window itself opening

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
GoelsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
moduloConnect With a Mentor Commented:
PAQed with no points refunded (of 250)

modulo
Community Support Moderator
0
 
DhaestCommented:
I don't think it's possible, because a form is like a child-window in an MDI-application.
If you open the subform, you'll always have to open the main-form.
0
 
GoelsAuthor Commented:
But isn't there some say 'Hide Window' command or such which could be used in VBA, with window being the name of the main Access window.

0
 
DhaestCommented:
Found at another forum. Don't know if it works

Forms!frmname.Visible = True
fSetAccessWindow (SW_SHOWMINIMIZED)
DoCmd.OpenForm "frmname"

I just visible=false the forms rather than minimize them.
Then this code hides the access window again and unhides the form.


http://www.utteraccess.com/forums/printthread.php?Cat=&Board=83&main=532529&type=thread
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.