opening an Access form without Access window 4

[Donkeygirl]

I am working on an Access form for users in the office to be able to take inventory of the phone calls received throughout the day. Due to the need for the users to be able to have other browers active, and to take such inventory quickly, I need them to be able to open the form without the Access window opening behind it. I have heard that this is not hard. Either in the properties, or a specific code, I have search and been unsuccessful in finding the cmd for this action. If anyone has the answer, please let me know.
Thank you,
ISresearcher
:

 

[Rohdem]

Are you referring to the database window that shows the tables, queries, forms, etc.? Or are you talking about starting the Access application itself? You cannot open a microsoft database without either Access or Access runtime starting. If you want to simply hide the database window, go to the tools menu and select 'startup'. Uncheck the box next to 'display database window'. This can also be done in code:

CurrentDb.Properties("StartUpShowDBWindow&quot = False


Mike Rohde
rohdem@marshallengines.com

 

[Donkeygirl]

I am talking about the Access browser, and I know it can be done. I have seen it. I just have not seen HOW it is done. I have been told code or cmd, but I cannot seem to figure it out. Even if it could just be fitted to the size of the form, that would be want I am looking for. Well, thank you for trying and if you figure this out, I will be searching til I get an answer!

 

[merlin72]

Run this program and see if this is what you want. If it is look in the macro section in the autoexec area first line. Good program to learn from.

http://www.mvps.org/access/downloads/MiniCalendar.zip

Regards
Jim.

 

[Rohdem]

Good call, Merlin!!! I'll give you a star for that one. That's a very handy little database to study. It looks like it opens Access, but then hides everything but the form.

One thing I discovered while playing with it that you want to be careful of is make sure your form's pop-up property is set to yes or it will disappear along with the Access window.
Mike Rohde
rohdem@marshallengines.com

 

[Donkeygirl]

Wow, thank you all for your help. I will look at that zip just to get a feel of it, Merlin. I actually figured it out, be ready to rotf and lyao....All you have to do is decrease the window so it is smaller than the form. Exit out if it, and when you start the app back up, the window stays the size you left it...smaller than the form!
I can't believe how much code I searched through. What a learning experience!
Thanks again guys....
IS

 

[MattBegg]

I have used the module and macro, from the minicalender database, in a database application of my own built in Access 2000.

After setting my form's pop up status to yes I still find that the forms are not displayed.

Have I missed something ??
Regards

Matt

matt@begg-uk.co.uk

 

[emzadi]

i would love to see this database, but am unable to get it to open... looks like access starts, but then everything disappears, and it is not listed as running in the task manager.. help? Susan M. Wagner
LAPELS
susanw@lapels.com

 

[Rohdem]

Susan, have you tried holding the shift key at startup to get to the database window?

Matt, did you change to macro so that it runs your startup form?
Mike Rohde
rohdem@marshallengines.com

 

[emzadi]

Mike,

Yes, I did try that, to no avail. Susan M. Wagner
LAPELS
susanw@lapels.com

 

[ahmun]

any tips on how to implement this in Access 2000? Earnie Eng
Newbie Access Programmer/DBA
(I just got a job! yay!)

---------------------------------

If you are born once, you will die twice.
If you are born twice, [i