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

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)

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.

"Harm Ozinga" wrote:

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)

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.

"Ofer" wrote:

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.

"Harm Ozinga" wrote:

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)

"Harm Ozinga" wrote in message

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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

http://www.members.shaw.ca/AlbertKal...s/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.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

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

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

"Dirk Goldgar" wrote:

"Harm Ozinga" wrote in message

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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" wrote:

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

http://www.members.shaw.ca/AlbertKal...s/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.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

"Harm Ozinga" wrote in message
...
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 (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

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

http://www.members.shaw.ca/AlbertKal...erFriendly.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..


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal