Access 2007

Working with Access 2007

I wish to set up my Access database so that no (gray) background appears when my users start up the database. Basically, I want everything (other than form) hidden from the users.

I was able to get the form to appear but the gray background wont go away.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
1. open your form in the maximize mode.
2. click on Office Icon > access option > current database > Navigation - Uncheck  Display navigation Pane

3. you can also hide the ribbon by placing this line in he Open event of your default form

docmd.ShowToolbar "ribbon",acToolbarNo
Jabal_AwliyaAuthor Commented:
Hi there....thanks so much for responding

My display navigation pane is unchecked. This option, as I noticed, removes the navigation pane up top. However I am would like the gray background (behind the form to disappear. Only the form can show.

Rey Obrero (Capricorn1)Commented:
did you do number 1 above?
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

Jabal_AwliyaAuthor Commented:
yes, I did :)
Rey Obrero (Capricorn1)Commented:
so, what happen?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
API: Manipulate Access Window
This same function can also be used to completely hide Access window and just show your form on the desktop. Make the form popup and from it's Open Event, ...
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What's your reason for doing this? It's counter-intuitive to the Access environment, and comes with a host of issues you'll have to get around. There seems to be little reason to do this, since you lose all of the great features the Access environment provides you with no code (the Ribbon, the QAT, tabbed windows, etc)
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I dunno about tabbed windows, lol. Reminds me of the DOS environment. WindowS is plural for a reason.
But the Ribbon and QAT (et al) for sure.
Jeffrey CoachmanMIS LiasonCommented:
Not really to be taken as a solution, ..just some notes.

1. I am not sure even if that code works in the acc 2007 environment.
But you can give it a go...

Note that with the Access "Application" hidden, you will have to build all of the missing functionality int your forms (Sorting, Filtering, Printing, ...etc)

2. Also consider how you will "Manage" the database in Design view, with no Access features.
(Modify table/query properties, and manage forms and reports in design view...)

It has been a long time since I played with that code, ...but I am not sure there was any provision (hotkey, ...etc) to open the database for "Development" (with the Access environment un-hidden)

3. Hiding the Access environment sounds like a cool thing to do, ...and perhaps this was true back in the pre-Access 2007 days, but IMHO, ...not now.

4. So unless your application is ridiculously simple, I would use Rey's suggestion.
And also look into other Access Options like turning off he menus and maxiizing the form when opened.

Jabal_AwliyaAuthor Commented:
Jabal_AwliyaAuthor Commented:

To answer your last question. This is what happened. See screenshot.

Rey Obrero (Capricorn1)Commented:
your form is not  maximize

try placing this codes in the Open event of the form

Jabal_AwliyaAuthor Commented:
Where can I find the open event of the form?
Rey Obrero (Capricorn1)Commented:
open the form in design view, then hit F4
click on the Event Tab
scroll down to On Open
select [Event Procedure] from the drop down
click on the ... at the right of the drop down arrow

the VBA editor window will show with this on focus

Private Sub Form_Open(Cancel As Integer)
  ' this where you will place the command

End Sub

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jabal_AwliyaAuthor Commented:
Thanks Rey....

I have tried all those steps with the combination of your original steps. Still, the gray background shows.

Rey Obrero (Capricorn1)Commented:
can you copy the codes you created in the open event and post here.
Jabal_AwliyaAuthor Commented:
I think I got it work...

I also decided not to pursue this route as it doesn't go well with my overall design.

Thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.