Removing the Restore button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've seen all the threads on this topic. I've copied the coding that will
remove the restore button. When I run the form, I get an error message. Do
I copy the code exactly how it is and which event procedure do I use?

Thanks
Linda
 
Hi,

I've seen all the threads on this topic. I've copied the coding that will
remove the restore button. When I run the form, I get an error message. Do
I copy the code exactly how it is and which event procedure do I use?

Thanks
Linda
Click to expand...

Care to post the code that you actually used, and the error message?
It might help if we knew what you were doing and what is going wrong.

You can see your computer. We cannot.

John W. Vinson[MVP]
 
Here is a previous post of mine with instructions.
Hopefully it will get you going.

Here is what you need to do:

1. Copy and paste all the code from the following link into a new
standard module:

http://www.mvps.org/access/api/api0022.htm

2. Compile the code and save the module as basMaximizeForm.

3. Now pick one form for testing. Open it Design View and go
to the code window. Presumably you have a DoCmd.Maximize
statement in the Form's Open, Activate, or Load event. Remove
that code from your code window.

4. Replace the DoCmd.Maximize statement with this:

MaximizeRestoredForm Me

5. Compile the code, save and close the form.

6. Now open the form in normal view. You will see that the form
will fill the available space below the menu and toolbars, but the
Restore button will not be shown.

7. Just repeat for each form.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
 
The expression On Open you entered as the event property setting produced
the following error: Only comments may appear after End Sub, End Function or
End Property.
Click to expand...

Take a careful look at your code (which you still haven't shown us -
you're obviously NOT using *EXACTLY* the code from the mvps site or it
would work).

You have SOMETHING - some code, some extraneous text, something, *you*
can see what but I cannot) after the End Sub line of your code. The
last line in your Procedure should be

End Sub

I'm guessing that you copied more than just the code from the website.

John W. Vinson[MVP]
 
Hi Jeff,

Thank you for the info. It did work but it's not filling the whole area.
The users will still be able to move the window around by dragging the title
bar. I don't want them to be able to do this. Is there something I'm doing
wrong?

Thanks
Linda
 
That's correct, the users can still move the Title Bar around.

Ok, try this.
1. Keep everything you have right now.
2. Go into the Design View of the form and go to the Properties area
of the form itself.
3. On the Format or All tabs look for an option called "Border Style."
Change that to None.
4. Save and close the form.

Now open the form.
Will that work for you?

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
 
Back
Top