Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Resize/Move Access Application Window
- Thread starter PWise
- Start date
I know there are VBA codes for it, though I can't think exactly what they are at the moment. Of course, there's the Shell commands and such that you can run from VBA or other languages as well, I believe..
What is it specifically you're wanting to do with the Access window? I've used some code for quite some time now for databases which someone posted some time back (few years) that will hide the Access window altogether.
What is it specifically you're wanting to do with the Access window? I've used some code for quite some time now for databases which someone posted some time back (few years) that will hide the Access window altogether.
- Thread starter
- #3
What I have is an Access Application that has no menu bar no status bar no access application window just the form.
What I want it should open to a certion position/size on the scerrn
and my next request would be that it should not be able to be resized or moved
What I want it should open to a certion position/size on the scerrn
and my next request would be that it should not be able to be resized or moved
- Thread starter
- #4
I believe you can set all those options you're talking about within the form itself and/or in the database startup options.
Have a look under form properties, specifically "format" and "other". I believe everything you need will be listed there or possibly under start-up options for the database.
One of these properties is "pop-up" which was mentioned in the other thread. Make sure it's set to yes/true, otherwise, the other Access code won't do what you expect it to do.
I've used similar code in a database I've used at my church now for I think 5 years or a little longer. On Windows Vista, it starts up with the main window hidden, but if you switch windows, then switch back to the Access database, it ends up showing the Access main page in the back, even though you can't do anything with it... so just a fair warning that with Office 2007 and Windows Vista, there's at least a possibility that something doesn't work quite the same as it did/does with older versions..
Have a look under form properties, specifically "format" and "other". I believe everything you need will be listed there or possibly under start-up options for the database.
One of these properties is "pop-up" which was mentioned in the other thread. Make sure it's set to yes/true, otherwise, the other Access code won't do what you expect it to do.
I've used similar code in a database I've used at my church now for I think 5 years or a little longer. On Windows Vista, it starts up with the main window hidden, but if you switch windows, then switch back to the Access database, it ends up showing the Access main page in the back, even though you can't do anything with it... so just a fair warning that with Office 2007 and Windows Vista, there's at least a possibility that something doesn't work quite the same as it did/does with older versions..
- Status
Similar threads
- Locked
- Question
- Locked
- Question