Is there a way

[James Warpup]

I would like to open a form, preferably from a desktop link, without opening
the entire access interface. Can I do that with access? If not can I do it
with SQL?

Thanks in advance

Jimmy

[Albert D. Kallal]

Post by James Warpup
I would like to open a form, preferably from a desktop link, without
opening the entire access interface. Can I do that with access? If not
can I do it with SQL?
Thanks in advance

First, "sql" is simply a query lanages that Sql server, Oracle, MySql,
Sybiase, and even the access 'jet' database engine uses. Sql has no ability
to allow you to build forms, reprots or any code of user internace.

As for opening a form..yes, you can hide the ms-access interface...

So, you most certainly can, and should hide all of the ms-access interface.
The options to complete hide and keep people out of the ms-access interface
can easily be done using the tools->start-up options. Using those options
allows you to complete hide the ms-access interface (tool bars, database
window etc). Also, using these options means you do not have to bother
setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

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

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

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

[James Warpup]

thanks, that's all very cool.

The file WordMerge07Hide.accdb is exactly what I want to do, but i can't
figure out how you did it. can you offer any more help? Idiot proof step
by step instruction would be best...

thx, i know that's a bit to ask.

Jimmy.

Post by Albert D. Kallal

Post by James Warpup
I would like to open a form, preferably from a desktop link, without
opening the entire access interface. Can I do that with access? If not
can I do it with SQL?
Thanks in advance

First, "sql" is simply a query lanages that Sql server, Oracle, MySql,
Sybiase, and even the access 'jet' database engine uses. Sql has no
ability to allow you to build forms, reprots or any code of user
internace.
As for opening a form..yes, you can hide the ms-access interface...
So, you most certainly can, and should hide all of the ms-access
interface. The options to complete hide and keep people out of the
ms-access interface can easily be done using the tools->start-up options.
Using those options allows you to complete hide the ms-access interface
(tool bars, database window etc). Also, using these options means you do
not have to bother setting up security.
Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options.
If want, you can even disable the shift key by pass. I have a sample mdb
file that will let you "set" the shift key bypass on any application you
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada