Solved

edit userform window ms access

Posted on 2013-11-22
5
342 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Query - calculate End of the Month in Query 2 54
ACESS 2010 Query Criteria 23 57
Access Query function 4 52
2 Global Vars, 1 List Box 4 34
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

751 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