Access won't stay maximised

[eckles]

Hi. I've designed a database in Access 2003 and converted it to 2007. The autoexed main menu opens ok but when I run a query and close it the main window goes back half size. I've gone into the properties and selected what I THINK is the relevant options but its still happening. I'm a basic user. Also..is there a way you can get in and alter the existing tables, queries, marcos etc?? Thanks for any help.

[nicknameoscar]

Do you have a DoCmd.Maximize statement in the Form Open (or Form Load) event?

[eckles]

I tried adding it to the code but there's a lot of places it could go. I'm a newb and am probably putting it in the wrong part of the form anyway. I take it I add it to the Form-Load? Lost at sea here!!! Visual Basic 101!

[nicknameoscar]

This is what I have in one of my forms:

 
Private Sub Form_Load()
 
DoCmd.Maximize
 
End Sub

To put the above code into VBA open your form in Design View. Make sure the little square box in the extreme upper left corner of the form has a blackened square inside that square box. If it doesn't just click inside that square box. (I use Access 2000, not sure how other versions of Access handle that). Click on the Properties icon on the Toolbar or right click on the box and select Properties. On the property sheet click on the Events tab. Double click on the text box just to the right of On_Load and then click the ellipsis (box with ... inside it). The VBA editor should open up. Copy and paste the DoDmd.Maximize statement between the "
Private Sub Form_Load()" and "End Sub" statements. Save and close the form and reopen as normal. Hopefully everything will work as desired.

[eckles]

That's what I got!!! It ain't workin'!! Have tried a few different options but nothing seems to get rid of it. I'm starting to think I should just set the whole thing to half size, that way it won't look so odd. I've taken it back to Access 2003 to get some more usability but its still happening. I just can get my head around the 2007 version. Its lost me!!!

[nicknameoscar]

I re-read your original post and noticed the last sentence. Are you saying you can't open queries or tables in design mode?

Do you have your "Trusted Locations" (I think that is what it is called) set up?

They changed Office 2003 to Office 2007 where I work a year or so ago. It was very frustrating to say the least. Hang in there, most of the changes ARE for the better.

[eckles]

I'll take your word for that Nicknameoscar. I even tried converting it back and putting it on my MS 2003 computer home. I finished the queries I wanted to but still didn't resolve the maximise problem. I've given it up for a bad lot. I've never had a form do that to me that wasn't set to maximise in the first place. I don't know about the "trusted locations" thing. I'll have to look that up and get back. I like the old 2003 where you minimise the form and ta da...there's everything you need...accessable!

[SteveH2508]

In A2007 (spit) you need to set the view to tabbed. Not sure where the setting is as I'm at home still with A2K (yum).