MS Access Start-up Question

[eforce]

I have Office XP Developer and thought that once I created a stand-alone program using it that I wouldn't get the MS Access frame running in the back of my Switchboard. When the user runs my program, I just want my form (switchboard) to pop up not the screen in the back drop (file menu ect..)

My switchboard doesn't take up the whole page but I want it like that. Does anyone know how I can have the back drop not show. I already have built in menus on my form.

Thanks,
E-force

 

[Elana]

Have you changed your startup options to not show the database window?

 

[eforce]

Hi,
I've went into the Start-up options screen and removed all the checks from checkboxes including in the advance tab. I'm speaking of the window that my program opens up into.

It has "File" ect... It's like a frame.

Thanks,
Danny

 

[ghudson]

No, the "Access" background will always be there unless you have all of your forms maximized. To give it a more polished look and to also keep your visitors out of where they do not belong, I suggest that you remove all of the toolbars, menubars and status bar. This code will do just that...

'Put this in your ''main'' forms OnOpen event:
Application.SetOption "Show Status Bar", False
Dim I As Integer
For I = 1 To CommandBars.Count
CommandBars(I).Enabled = False
Next I

An added bonus is the right click option is disabled if the menu bars are disabled.

HTH

 

[Rich]

Not strictly true, ghudson, you can run the appplication so just the form shows, but it requires complex code, doesn't work very well and really isn't worth the bother.
You can change the some of the look of the window to make it more interesting though.

 

[eforce]

I appreciate everyones response. I have Office XP Developer but I'm not all that of what it is capable of. Does that make any difference in what I'm trying to accomplish?

Eforce

 

[Pat Hartman]

The developer's edition does NOTHING to your db. It does NOT change it in any way. It simply gives you a license to distribute the runtime version of MSAccess.exe.

Once you remove all the built-in menus and toolbars, your users will have no way of printing. You'll need to provide the printer dialog functions via VBA code that you attach to some button or custom menu item.

 

[eforce]

My program is self sufficient. You can do everything via my forms (built in buttons) My orginal question is how to get rid of, place behind my form or shrink the gray background frame with the tool bar that's left (File, Edit ect.) appears behind my forms. Something that just hit me was too probably create a form that takes up the whole screen and then have my program run on top. Sort of like a Splash screen that comes up when I start my program.
If you view this jpeg it'll give you a sample view of my app and I have circled in red what I want removed.

Thanks,
E-force

 

[Rich]

Set that forms popup to true and maximize it.