Hide main database window

Question

HI All

I want to open a access file ( for eg.  : A.accdb)  from another access file ( for eg.  : B.accdb), I use some method like : opencurrentdatabase methode and No problem

How can I open the databse ( B.accdb ) with (A.accdb) without visible it's ( B.accdb ) main database window ( I need to Hide this )

regard

Answer 1

Right... you want to...

1. Open A
2. Open a Form from B via A BUT hide B's window

I am saying I don't believe that will work... at least, as far as I know.  I know you can hide the current installation, see...

http://www.access-programmers.co.uk/forums/showthread.php?t=217400

Perhaps someone else will pass by with a solution.

Answer 2

Hi

I don't want to hide a form , I want to hide the main access window

for clearly , like use of Hideaccess function to hide the access window for a file itself but my question is  Hide the access window file for a file when I open it by another one

for better undrestand please put below cod to a module and call " Hideaccess "

dont forget put a button to Quite and use Docmd.restore on onload the form

code : ( windows mus be 32 bit):

Option Compare Database

Public Declare Function ShowWindow Lib "user32.dll" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long

Public Sub HideAccess()

Call ShowWindow(Access.hWndAccessApp, 0)

End Sub

I am waiting to give a correct answer for my main Question

regard

Answer 3

Did not realize you also wanted to open a Form.  I thought you just wanted to retreive some data from that file.  In light of that, the answer is no, you can't open B.ACCDB to use a Form and keep it hidden.

Answer 4

Hi

How can I link to it when I want to open a form of it (B.accdb)

regard

Answer 5

Why not just link to it?  Then no need to open at all...