Solved

edit userform window ms access

Posted on 2013-11-22
5
334 Views
Last Modified: 2013-11-22
Hi Expert's

how would you do the following on a userform.

1. Hide the record display at the bottom
2. Change caption in form window
3. Remove hide minimise and x buttons
4. Add a close button to close the form
0
Comment
Question by:route217
  • 3
  • 2
5 Comments
 
LVL 14

Accepted Solution

by:
Bill Ross earned 500 total points
ID: 39668521
Hi,

The first 3 items are available on the form property window.  Design the form, click Properties and look for the property
1. Navigation Buttons
2. Caption
3. Min Max Buttons and/or Close Buttons

For your last question you will need to drag the Button on the form.  Select the On Click property and click [Event Property].

Click on the ... to the right in the property line which opens the VBA window.

Enter one line of code as shown below:

Private Sub...
  docmd.Close acForm,me.Name
End Sub

Regards,

Bill
0
 

Author Comment

by:route217
ID: 39668531
Thanks bill...excellent


one last point....left hand plane on form not in design view underneath caption
you have a right arrow which u can click how do you remove this
0
 

Author Comment

by:route217
ID: 39668547
Found it records selectors....
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39668560
Good.  You're learning fast!
0
 

Author Comment

by:route217
ID: 39668586
Hi bill

I have another question open....care to shed some light
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question