can i run a form without Acces, or that i can't see access itself?

[Guest]

I have a MSAccess db and I want to run just a form without Access itself to
open.
the db is for people how are afraid of Access ore other programs they don't
know.
maybe it is possible to hide Access and just show the forms

Harm Ozinga
(The Netherlands)

 

[Guest]

Put the form you want to displey on the startup, so when access will come up
the form will be displayed, and in the form unload properties put the code
application.quit

You can create a run time application, so you wont have to install Access in
the compters, also save having license for each user.

 

[Guest]

I think you didn't understand me quit right because I want that user won't be
able to see Access. The way you explained you can see access but when you
what click at somthing other than the form Access will close.

 

[Dirk Goldgar]

I have a MSAccess db and I want to run just a form without Access
itself to open.
the db is for people how are afraid of Access ore other programs they
don't know.
maybe it is possible to hide Access and just show the forms

You can turn off all menus except the ones you yourself create, and
disable the use of shortcut keys to show the database window. It's also
possible, under certain circumstances, to hide the application window
and show only your forms, but each form must be popup (and usually
modal), which restricts the things you can do with your application.
For information about that, see this page:

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

 

[Albert D.Kallal]

Try downloading and running the sample I have here:
(3rd one)

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

The above hides all of ms-access, and takes no code. The only part that
users see is "your" application part....

The settings to do the above are all in the tools->startup.

 

[Guest]

Thank you for your brilant code, this is the solution!
It is not working jet for me but i think i can figure it out.
many thanks!

Harm Ozinga

 

[Guest]

Thanx this code is great!
it's not working jet for me , but i will figure it out!
Many thanks
Harm Ozina

 

[Guest]

I tryed that one but the way i can se it is not hiding Access it's self.
the problem i have with the code is when i put fSetAccessWindow(0) it in
the onopen event of a form i get a error message. but when i set the same
code in a onclick event of a button de code wordks fine.

Harm Ozinga

 

[Albert D.Kallal]

I tryed that one but the way i can se it is not hiding Access it's self.

Well, you can't see any part of ms-access in my example. The fact is, sure
you see a main window, but that window has NONE of ms-access stuff and ONLY
has the things I put there.

I am not really sure if hiding the window is such a need, or even a big
deal?

For about 14 years now, users first program they are introduced to is word.
Word has a main window area, and then each document is a window that remains
inside this. it is not like your users are going to be confused. Further,
Excel works this way also. This what is called the MDI (multiple document
interface). And, to be fair, the Apple Mac also works this way.

So, when you use word, Excel, or in fact ms-access (which is also part of
office by the way), all of these applications has a main menu bar, and then
child windows inside. I don't think you should waste your time trying to
code and change the way Microsoft office works?

I distributed many ms-access applications, and the users do NOT know it is
ms-access, and never see ANY of the ms-access stuff. I really doubt the
efforts to try and hide the main window, and change the way ms-access (or
word, or Excel) has worked for 15 years makes any sense.

Is not hiding all of the ms-access stuff, and replacing as my example shows
good enough?

You can certainly grab that code at the access web, but it kind of a kludge,
and comes with warnings as to its use.

Why not go with the way word, Excel and most of office has worked for in the
last 15 years?

 

[Albert D.Kallal]

Also, take a quick read and look at the following screen shots of ms-access:

http://www.members.shaw.ca/AlbertKallal/Articles/UseAbility/UserFriendly.htm

The above screen shots are from commercial applications I have written using
ms-access, and the users NEVER even know that the product is written in
ms-access. The applications simply look, feel, and run like any other of the
office applications..

 

[Guest]

I agree with you, with all the arguments you named.
But my problem is that my boss want this feature, maybe if let him reed your
reply he will change his mind.
by the way I make this program, but when it is finished someone else is
keeping up the program. that person kwows only the basics of office.
so there's another reasone follow up you advices.
I gess i will chet with my boss and try to make change his mind.

thanks for all your replies
Harm Ozinga

 

[Dirk Goldgar]

I tryed that one but the way i can se it is not hiding Access it's
self. the problem i have with the code is when i put
fSetAccessWindow(0) it in the onopen event of a form i get a error
message. but when i set the same code in a onclick event of a button
de code wordks fine.

You may have to force the form to become visible first. Try inserting
the line

Me.Visible = True

before you attempt to hide the Access window.