UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Extend Form Navigation Buttons, Access 2013    
 
   
phisaw
post Feb 18 2020, 10:54 AM
Post#1



Posts: 310
Joined: 3-April 08



Hello,

I'm looking to reduce navigation clutter on a form. I have a column of navigation buttons on a form and would like to combine those that are common.

Example: A button 'Edit Contact' and a button 'Add Contact'.

Is there a way in Access to have one button or label 'Contact', when user mouses over or maybe clicks, that the extended options of Edit and Add are available?

If anyone has a suggestion, I would greatly appreciate it.

Thanks in advance,
Pam
Go to the top of the page
 
GroverParkGeorge
post Feb 18 2020, 10:58 AM
Post#2


UA Admin
Posts: 37,006
Joined: 20-June 02
From: Newcastle, WA


This sounds like it could be implemented with either a Treeview control or the use of a custom Ribbon.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
nuclear_nick
post Feb 18 2020, 10:59 AM
Post#3



Posts: 1,843
Joined: 5-February 06
From: Ohio, USA


One suggestion...

Change from a button to a combo box, 3 choices; Contacts, Add Contact, Edit Contact. Alter coloring to make it look like a button, default to 'Contacts'.

Then handle the event that happens when the combo box changes.

--------------------
"Nuclear" Nick
____________
The top three reasons to hide code; 1) It's not your own. 2) It's your own, but it's so crappy you don't want anyone to see it. 3) The comments in your code would get you in a lot of trouble if ever made public.
Go to the top of the page
 
GroverParkGeorge
post Feb 18 2020, 11:17 AM
Post#4


UA Admin
Posts: 37,006
Joined: 20-June 02
From: Newcastle, WA


Or you could put those option buttons into a a tab on a custom ribbon.... thumbup.gif

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
nuclear_nick
post Feb 18 2020, 11:22 AM
Post#5



Posts: 1,843
Joined: 5-February 06
From: Ohio, USA


There are lots of ways, for sure. Depends on needs/wants of users.

My boss likes it best when there is less 'travel' for the mouse, so if a button could be placed 'right there', then it is.

(And you could do both... I like the idea of the ribbon thing, because it would be easier to make keyboard shortcuts that way... so NO 'mouse travel time'... smile.gif )

--------------------
"Nuclear" Nick
____________
The top three reasons to hide code; 1) It's not your own. 2) It's your own, but it's so crappy you don't want anyone to see it. 3) The comments in your code would get you in a lot of trouble if ever made public.
Go to the top of the page
 
phisaw
post Feb 20 2020, 05:15 PM
Post#6



Posts: 310
Joined: 3-April 08



Thank you Nick and George for replying with suggestions.

George, I did some research on customizing the ribbon and it looked to looked like it would take quite a bit of studying to accomplish.

Nick, I liked the idea of a combo box, but have decided to go with shortcut menu's for each category label.

Again, thank you for your replies.
Pam
Go to the top of the page
 
GroverParkGeorge
post Feb 20 2020, 05:24 PM
Post#7


UA Admin
Posts: 37,006
Joined: 20-June 02
From: Newcastle, WA


Continued Success with your project.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
nuclear_nick
post Feb 21 2020, 06:41 AM
Post#8



Posts: 1,843
Joined: 5-February 06
From: Ohio, USA


Probably for the best, having everything laid out, else you'd have to ensure that everyone knows how and where to find what they are looking for.

Good luck with your project!

--------------------
"Nuclear" Nick
____________
The top three reasons to hide code; 1) It's not your own. 2) It's your own, but it's so crappy you don't want anyone to see it. 3) The comments in your code would get you in a lot of trouble if ever made public.
Go to the top of the page
 
ADezii
post Feb 21 2020, 08:45 AM
Post#9



Posts: 2,844
Joined: 4-February 07
From: USA, Florida, Delray Beach


This option would definitely be somewhat 'clunky' but you can provide Users with multiple Options in a Command Button by prompting them in the Click() Event of the Button. Again, it is 'clunky', but I guess it depends on how desperate you are for space on the Form.
CODE
Private Sub cmdTest_Click()
Dim strMsg As String
Dim strResponse As String

strMsg = "Enter A to Add, E to Edit, or D to Delete a Contact"

strResponse = InputBox$(strMsg, "Contact Actions")

Select Case strResponse
  Case "A"
    'Code to Add a Contact
  Case "E"
    'Code to Edit a Contact
  Case "D"
    'Code to Delete a Contact with Confirmation
    If MsgBox("DELETE this Contact?", vbYesNo, "DELETE Contact Confirmation") = vbYes Then
      'Delete the Contact
    End If
  Case Else
    'Fall thru and do nothing
End Select
End Sub

This post has been edited by ADezii: Feb 21 2020, 08:47 AM
Attached File(s)
Attached File  Capture.JPG ( 9.19K )Number of downloads: 0
 
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th April 2020 - 05:12 PM