Question Locked

Use Switchboard without opening Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi. I am working on a switchboard that may not really require the user to need MS Access to be open... Is there anyway to jus open the switchboard without access opening? Or even is there is way to turn an existing switchboard into an .exe? I just need the switchboard to be open and not Microsoft Access...

3 replies

by tinusrensburg

Hi

I am trying to get the same thing working.
Please let me know if you find a way this can be done.

Regards

by joie.sales

If you want to use the forms so they only show and not the surrounding "Access Window" then you can do it like this:

First, set up an AutoExec macro to do two things. The first is to use the Run Command "AppMinimize." Then you need to open up a form. The form should be set as "popup."

Now in order for this to work properly, you need to remember a couple of key things:

1. You must always close your form before trying to maximize the application window.
2. You must always minimize the application window before opening a form.
3. All forms must be set as popup
4. In order to view a report, you must first, close the form, run the command AppMaximize and then open the report (use the maximize also on the report's on open event).
5. In the report's on close event, put the AppMinimize and open form commands.

So, if you do that, you will be able to create an Access app that looks like it runs by itself without Access open.

Hope this helps!

This discussion is closed to new replies.