Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: how to open form without open access window


(!)

Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
13-Feb-2012, 04:14 AM #1
Solved: how to open form without open access window
I am working on database for user who completely blind to microsoft access. So I make a form for them to work with.

Since the access window is kind of distracting, does anybody know how to open form without the access window open?

Thanks in advance!
Elvandil's Avatar
Computer Specs
Moderator with 51,993 posts.
 
Join Date: Aug 2003
Location: Vermont
Experience: "Been through the mill."
13-Feb-2012, 05:07 AM #2
What program would you use to open the file if not Access? If you can find one that has a minimal window, you can use that.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
13-Feb-2012, 08:43 AM #3
Thanks for your reply. A friend of mine said he once made a database with only the form visible. It's a long time ago so maybe using access 2003, but he forgot how to do it..

Can anyone help? Thanks
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
13-Feb-2012, 09:09 AM #4
You can completely hide the Access database window, look at the Startup options.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
13-Feb-2012, 09:21 AM #5
Is it in access options? I am using access 2007 btw. Which tab should i choose? have tried it this afternoon but can not find it.

Thanks OBP
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
13-Feb-2012, 10:12 AM #6
Yes well that is the nice working interface that Office & Access 2007 uses.
Try
MS Office Button>Access Options>Current Database.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
13-Feb-2012, 06:42 PM #7
Wow, thanks for your reply. I have tried uncheck the "display navigation pane" and "allow full menu". It's working hiding all the button but the window still open. Is this what you mean? And it is customize in access option so if the user open it in different computer it will be visible again, right?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
14-Feb-2012, 06:44 AM #8
I don't know as I have Access 2003.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
16-Feb-2012, 07:28 AM #9
can you print screen the resulting database after hiding the access window (2003)? i'll just make sure that's the one my friend was talking abt. thanks!
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
16-Feb-2012, 09:27 AM #10
Would this be what you want?
Attached Files
File Type: zip send v 0.0.zip (84.3 KB, 841 views)
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
16-Feb-2012, 07:15 PM #11
My friend said the access window is completely hidden, but I guess yours is ok, at least the user won't screwed up my tables and queries. If you know any other way pls let me know.

Thanks!
rulerpeaceful's Avatar
rulerpeaceful rulerpeaceful is offline
Member with 2 posts.
 
Join Date: Feb 2012
Experience: Beginner
17-Feb-2012, 12:01 AM #12


How skilled are you with the VBA language? We recently had an interesting thread on this. In this thread we were able to hide the MS Access application and show the form only. Your form must be set to popup and Modal. Let me know if this helps at all. There are ways to resize the application window and hide the menus etc. just depends on what approach you would like to take.
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
17-Feb-2012, 12:25 AM #13
I'm quite new with VBA language. Don't understand every detail syntax but have done some commands in my form using google. So just copying the code used by others. But I do know how to make my form pop up. Can you explain "modal"? Pls help if you know how, since completely hiding access window will make my database have a really good package ^^. Thx
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
17-Feb-2012, 07:10 AM #14
As rulerpeaceful says you can use VBA to hide the window when all Forms are set to Popup, apparently you shouldn't need Modal as well.
You need an Autexec macro to run the following code in a Module

fAccessWindow ("Minimize", False, False)

So you need to create a Module and then create a macro called Autoexec to "call" the new Module.
__________________
OBP
I do not give up easily
Jayabhadra's Avatar
Jayabhadra Jayabhadra is offline
Member with 52 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Familiar
17-Feb-2012, 07:30 AM #15
Really sorry but I don't know what a module is, I am quite new to coding.. Can you explain more?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
access, access window, form

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑