Running A Database w/ out seeing Access!? 9

[Joel27]

Is it possible to run a database, but not seeing access.

I'm using popup menus but I would like to know if its possible to run the database without seeing the access background.

 

[Rohdem]

I have a sample database and will post the link where it can be downloaded...

Mike Rohde
rohdem@marshallengines.com

 

[Rohdem]

Wow, I didn't anticipate the demand for this. You guys can download it now at:

http://www.therohde.com/TableEditor.mdb

A few notes about the database:

This is a little program I wrote to allow me to add fields/tables to a database at night when no one is working in them. It is an Access 97 database. We use a custom system.mdw workgroup file here at work, so if you have troubles opening the database, import the objects into a new database.

The part you are interested in is the 'hide or show access window module'. I actually got this code from another memeber of tek-tips, but unfortunately, I can't remember who. The autoexec macro calls the ' fAccessWindow'
function. Please note that all your forms need to be pop-up or they will disappear.

If you copy the module and the autoexec macro and change the startup form in the macro to your startup form, you should be ready to go as long as your forms are pop up.

To view the database window, hold the shift key when you open the database. You will probably want to make a custom exit button (as I did) that uses Application.quit and disable the close button on your forms. Otherwise, you will end up with multiple instances of Access running on your machine that you can't see.

If you would like to use the database as it was written to update tables, feel free to, but I, of course, provide no support/documentation and am not responsible for any problems it may cause.

Enjoy Mike Rohde
rohdem@marshallengines.com

 

[InfoNow]

Hi Mike,

Thanks for the awesome utility. I have one question for you. I am trying to add a Print Report on the Switchboard, but it doesn't print because it is not a pop up. It just disappearred. Is there anyway to enable pop up on a report?

TIA,
Quang

 

[Rohdem]

No, I don't believe there is. You might try unhiding the Access window when the report is opened and rehiding it when the report is closed.....or you could just send the report directly to the printer Mike Rohde
rohdem@marshallengines.com

 

[AArt]

Very Cool! This will make some of my Apps look like I really know what I'm doing.

 

[FollowTheSon]

This code works for Access97 but not for Access2000. Does anyone have any ideas for 2000?

 

[Laois]

You will find an example that works for Access 2000 here

http://www.mvps.org/access/api/api0019.htm

Dermot

 

[FollowTheSon]

Actually I tried that code as well. It worked except it got rid of every form, even the one I set as popup. Is there anything else I need to set?

 

[dirkg]

I have just converted it to Access 2002. I guess the problem is the same as in 2000: you have to create a reference to DAO and then change your database, recordset, etc. declarations to DAO.Database, DAO.Recordset, etc. and then it works perfectly.

Thanks Mike!

Greetz,

Dirk

 

[Laois]

FollowTheSun,

The only way I could get it to work is by setting the form as Popup and Modal. It is just not practical to make all your forms Popup and Modal plus if something does go wrong your application could just vanish. This may work with a small application that has a just a few forms but for a large complex application with 30 - 40 forms I just don't think it would be worth the trouble.

Dermot

 

[OneGreen]

Just wanted to let you know that even a year later your advice (and your database sample ) has made my life loads easier.

Thanks!

 

[waldemar]

If don't need the preset ActiveX DataObjects Library, just remove it when you add the DAO 3.6. This way you should not need to update everything to "DAO."