Database Window

[cardgunner]

Is there a way to keep the database window open where it could not be minimized or restored, or minimized or maximized?

I know I can do that for forms in properties by changing the Min Max Button setting to none.

I want to set the Database Window to none.

The user has lost the window a couple of times over the last 5 years and can't find it. He brings in the database I find it resize it and bring it back up into the viewing area. Not a huge problem but one that I think can be permenent fixed. I tried walking him thru it but no luck.

 

[KenHigg]

See if this helps

http://www.mvps.org/access/general/gen0031.htm

 

[cardgunner]

Thanks Ken,

I seen that in the options for the Start up and I did not know of that piece of code however neither of those work for me.

There are three stages for any window min, restore, and max right?

What happened both times was while in the restore state it got resized to the size of what it would be if it was min. Then it got dragged about 5 pages down. Don't ask me how, he doesn't know. So when he leaves the main form and wants to write a query or open a form or etc he just staring at a grey screen.

I asked him over the phone to look for the scroll bars wti the bottom and right of the grey screen and he said there was none.

With the db window so far down in his defense they where real small, however he could find them. Brought in his laptaop and I resized it and pushed up.

Seeing it has happened twice in the 5 years it's not a big thing. I could use that code for a button from the main form but that seems like a bigger ordeal then it's worth, for me.

I thought there was a setting for the proerties of that window so it could not be resized or it would stay in in whatever state you told it to.

 

[KenHigg]

I'm sure there's an api thing to do this but that's a bit beyond my ability

 

[cardgunner]

Well I don't even know what an api thing means so it's WELL beyond my ability.LOL

 

[MSAccessRookie]

Well I don't even know what an api thing means so it's WELL beyond my ability.LOL

API stands for Application Programming Interface

 

[KenHigg]

You can write vb code that works with stuff at the Windows (Operating System) level. Things like resizing the MS Access application window size and location, etc. It is often referred to as 'API calls'. I think it stands for 'Advanced Programming Interface'. Here's a link:

http://www.geocities.com/SiliconValley/Lab/1632/apitutor.html

 

[KenHigg]

Yeah - What rookie says: 'Application' not 'advanced'.

 

[cardgunner]

Thanks again Ken for your help.

If there was a place I could get to easy to change a dropdown menu or click a check box I'd do it.

I'm not going to travel a down a road designated for 4wd with roller skates.

I'll fix it again for him in a couple of years if need be.