What control would work for this...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I have an applicaiton where the user selects a "client" name from a drop
down "combo box" and then once the client has been sleected, they entere
hours against that client.

I have been asked if I can modify the app so that the user can select
multiple clients from the drop down combo-box and then the hours woul dbe
recorded against each of the clients they selected...

Is this something you can do with a combo box, or would I have to use some
other control to facilitiate this?

I have also thought of the possibility of "right-clicking" on the item
withing the combo box displaying a menu that says "Add to Group", which when
clicked would add the client the user right-clicked on to a separate
window...

What would be the best way to approach this?

Thanks,

Brad
 
You're describing a "ListBox" control, where you can select multiple items
in the list (the list box must be set to Multiselect). You will need to use
VBA code to then loop through the Selected collection for the listbox and
work with each selected item one at a time.
 
Thanks for that Ken...

Do you know if you can "right-click" on a combo-box item to display a menu??

Brad
 
You can attach a user-defined shortcut menu to a combo box, yes.... except
in a runtime installation of ACCESS.
 
So when you say a "runtime" installation of access you are referring to any
installation where you are simply running the app using the .mdb file as
opposed to making a .mde file?
 
Brad said:
So when you say a "runtime" installation of access you are referring
to any installation where you are simply running the app using the
.mdb file as opposed to making a .mde file?
Click to expand...

The Runtime is a crippled royalty free version of Access that you can
distribute with your file for users who do not have Access installed. You
would have to purchase the developer's tools software for your version of
Access to be able to do that however.

Custom shortcut menus work in the Runtime. I use them all the time.
 
Rick Brandt said:
Custom shortcut menus work in the Runtime. I use them all the time.
Click to expand...

Thanks for that info, Rick... I must be thinking about the default shortcut
menus.
 
Back
Top