Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Form Without Opening Access Window 1

Status
Not open for further replies.

atzsea

Programmer
Jun 1, 2005
49
JP

Tell me how to open a form directly without displaying a glimpse of Access Window in the opening of Access Application ,just like VB applications.

c.f.
I already know how to hide Access Window.
 
Hi degahidaka,
according to my knowlege, it is not possible in Access.

I am wondering what do you mean by "I already know how to hide Access Window".

Ja
 
If it's only how to hide Access Window, many who join this forum. They could display a form just like VB applications.

But the matter is in the opening of a form.
What irritates me is the appearing of Access window before hiding itself.
 
I'm an Access fan. I prefer using Access to VB. Usually I don't use VB.
 
degahidaka said:
What irritates me is the appearing of Access window before hiding itself.
Well, Access has to finish loading itself before it can do whatever startup procedure you want it to do, which apparently is to show a form. How could it possibly do otherwise?

 

************************
Thanks, TimTang
************************

I've also got a perfect answer.
In fact, I have not thought there is an answer for that.
You made me happy.

Good day.
and to everybody associated with my threads.
 
degahidaka,

Look over at thread702-798009

I've been using the code given in that thread now for 4 years, and it's worked great!
[thumbsup2][thumbsup2]

--

"If to err is human, then I must be some kind of human!" -Me
 
Thank you, kjv1611.

I've also found a code as of jan 2005, just like what you suggested.

Very recently, I serched in this forum, literally using "Serch" tab of this page,
and found the one like the following, though I forgot the exact thread url.


*******************************************************
Private Declare Function ShowWindow Lib "user32" _
(ByVal hwnd As Long, ByVal nCmdShow As Long) As Long

Dim lngret As Long

Public Sub HideWindow()
lngret = ShowWindow(hWndAccessApp, 0)

End Sub

Public Sub RestoreWindow()
lngret = ShowWindow(hWndAccessApp, 1)

End Sub
*********************************************

This may be the simplest way.

<reference>
ShowWindow(hWndAccessApp, 2) makes a form minimized
ShowWindow(hWndAccessApp, 3) makes a form maximized

A complete set of simplest Hiding Access Window can be seen at the site ;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top