I have a combobox on a form that contains titles of categories, one
of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the
selection decision, but I can't find a way to determine which row
is highlighted.
I tried using the mouseover event to return the .listindex value
and update the notes textbox, but that returns null unless the row
is selected by clicking or typing in the start of the value.
..Seltop appears not supported in the combobox, because I tried
using that and Access complained.
Google turns up nothing on the web, or from the newsgroups.
Does anybody have any suggestions?
--
Bob Quintal
PA is y I've altered my email address. 10 2279
Bob Quintal wrote: I have a combobox on a form that contains titles of categories, one of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the selection decision, but I can't find a way to determine which row is highlighted.
I tried using the mouseover event to return the .listindex value and update the notes textbox, but that returns null unless the row is selected by clicking or typing in the start of the value.
.Seltop appears not supported in the combobox, because I tried using that and Access complained.
Google turns up nothing on the web, or from the newsgroups.
Does anybody have any suggestions?
I think a listbox would be better to present a list like that to the
users...but...both work pretty much the same. I would create a textbox
to hold the comments/notes. In the OnClick event write something that
finds the notes...something similar to
Sub Combo_OnClick
Dim rst As Recordset
set rst = Currentdb.Openrecordset("TableWithNotes",dbopensna pshot)
rst.findfirst "TableID = " & Me.Combo
Me.Text0 = rst!NotesField
rst.close
set rst = Nothing
End Sub
Salad <oi*@vinegar.com> wrote in
news:XU****************@newsread2.news.pas.earthli nk.net: Bob Quintal wrote:
I have a combobox on a form that contains titles of categories, one of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the selection decision, but I can't find a way to determine which row is highlighted.
I tried using the mouseover event to return the .listindex value and update the notes textbox, but that returns null unless the row is selected by clicking or typing in the start of the value.
.Seltop appears not supported in the combobox, because I tried using that and Access complained.
Google turns up nothing on the web, or from the newsgroups.
Does anybody have any suggestions? I think a listbox would be better to present a list like that to the users...but...both work pretty much the same. I would create a textbox to hold the comments/notes. In the OnClick event write something that finds the notes...something similar
Cannot use a listbox, for several reasons. Even there,
the on click event doesn't work for what I need to do.
And I do have a textbox for the notes, and that part works
perfectly from the comboboxes After Update events.
I actually put the notes in a hidden column of the combobox.
It's just that I want the user to see the notes before making a
selection, to prompt him/her to make the right selection.
In order to do that, I need to determine which row of the
combobox dropdown is highlighted (reverse video).
--
Bob Quintal
PA is y I've altered my email address.
Look at how I did in the Tooltips class on my site. Unfortunately my ISP is
in Florida and my site is down for now.
:-(
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135... Salad <oi*@vinegar.com> wrote in news:XU****************@newsread2.news.pas.earthli nk.net:
Bob Quintal wrote:
I have a combobox on a form that contains titles of categories, one of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the selection decision, but I can't find a way to determine which row is highlighted.
I tried using the mouseover event to return the .listindex value and update the notes textbox, but that returns null unless the row is selected by clicking or typing in the start of the value.
.Seltop appears not supported in the combobox, because I tried using that and Access complained.
Google turns up nothing on the web, or from the newsgroups.
Does anybody have any suggestions? I think a listbox would be better to present a list like that to the users...but...both work pretty much the same. I would create a textbox to hold the comments/notes. In the OnClick event write something that finds the notes...something similar
Cannot use a listbox, for several reasons. Even there, the on click event doesn't work for what I need to do. And I do have a textbox for the notes, and that part works perfectly from the comboboxes After Update events. I actually put the notes in a hidden column of the combobox.
It's just that I want the user to see the notes before making a selection, to prompt him/her to make the right selection. In order to do that, I need to determine which row of the combobox dropdown is highlighted (reverse video). -- Bob Quintal
PA is y I've altered my email address.
"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote
in news:cu**********************@ursa-nb00s0.nbnet.nb.ca: Look at how I did in the Tooltips class on my site. Unfortunately my ISP is in Florida and my site is down for now. :-(
Thanks, Stephen, I'll check it out when I get a chance.
I actually developed a solution, in reading the Y coordinate that's
passed to the mouseover event, and scaling that to get a row number
and showing the help data in the textbox. Good way to kill a lunch
hour.
The Access documentation on the event is sorely lacking.
--
Bob Quintal
PA is y I've altered my email address.
The solution on my site(back up now) adds the ability to work when the
ScrollBar must be used.
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135... "Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote in news:cu**********************@ursa-nb00s0.nbnet.nb.ca:
Look at how I did in the Tooltips class on my site. Unfortunately my ISP is in Florida and my site is down for now. :-( Thanks, Stephen, I'll check it out when I get a chance.
I actually developed a solution, in reading the Y coordinate that's passed to the mouseover event, and scaling that to get a row number and showing the help data in the textbox. Good way to kill a lunch hour.
The Access documentation on the event is sorely lacking.
-- Bob Quintal
PA is y I've altered my email address.
>>> I have a combobox on a form that contains titles of categories, one of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the selection decision, but I can't find a way to determine which row is highlighted.
Um, why not just use a second "notes" column?
--
Darryl Kerkeslager
"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote
in news:4V**********************@ursa-nb00s0.nbnet.nb.ca: The solution on my site(back up now) adds the ability to work when the ScrollBar must be used.
Downloaded and will begin exploring. Thanks.
--
Bob Quintal
PA is y I've altered my email address.
"Darryl Kerkeslager" <ke*********@comcast.net> wrote in
news:cI********************@comcast.com: I have a combobox on a form that contains titles of categories, one of which is to be assigned to a record.
I'd like to show users some notes on each category to aid in the selection decision, but I can't find a way to determine which row is highlighted.
Um, why not just use a second "notes" column?
sometimes, the notes run to 2kB of text, in 20 lines. That is not
practical in a combobox.
--
Bob Quintal
PA is y I've altered my email address.
>>>>> I have a combobox on a form that contains titles of > categories, one of which is to be assigned to a record. > > I'd like to show users some notes on each category to aid in > the selection decision, but I can't find a way to determine > which row is highlighted.
Um, why not just use a second "notes" column?
sometimes, the notes run to 2kB of text, in 20 lines. That is not practical in a combobox.
Well, maybe it's just me, but I can't picture scrolling down a dropdwon
list, and reading up to 20 lines of text to make a decision on which choice
to make. It just doesn't sound like a user-friendly way to make a
selection, and it is not one I've seen before, even if you do find a
technical way to accomplish it.
--
Darryl Kerkeslager
"Darryl Kerkeslager" <ke*********@comcast.net> wrote in
news:Nr********************@comcast.com: >> I have a combobox on a form that contains titles of >> categories, one of which is to be assigned to a record. >> >> I'd like to show users some notes on each category to aid >> in the selection decision, but I can't find a way to >> determine which row is highlighted.
Um, why not just use a second "notes" column? sometimes, the notes run to 2kB of text, in 20 lines. That is not practical in a combobox.
Well, maybe it's just me, but I can't picture scrolling down a dropdwon list, and reading up to 20 lines of text to make a decision on which choice to make. It just doesn't sound like a user-friendly way to make a selection, and it is not one I've seen before, even if you do find a technical way to accomplish it.
Stephen Lebans' tooltips database example uses a very similar
concept on a listbox. Very elegant.
I did get it working well the way I designed it, however, and
used a method similar to Stephen's way of getting the row from a
listbox, I'm trying to adapt his code to work on the combobox,
because his tooltips look a lot nicer, and waste much less real
estate.
Essentially I have a set of cascading comboboxes, a sort of
treeview, to set item classifications in an ERP system. The top
level contains 7 categories. Each of those six have from 3 to 8
subcategories, and some of those have a third level.
The notes are to offer suggestions about what goes where, in
cases of ambiguity. Right now I have the 3 combos set up, and
the notes column is set to 0 width. There is a big textbox above
and thanks to mr Lebans' code, I was able to figure out how to
use the mousemove coordinates to determine which row is
highlighted, and make the corresponding notes appear in the
textbox as the mouse hovers over the dropdown. His tooltips idea
is similar, in that you can put a lot more text into his
tooltips than in the control's controltip property 255 character
limit.
--
Bob Quintal
PA is y I've altered my email address. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: john woo |
last post by:
Hi
I'm not good at JS, but want to get more about it.
I want to use a JSP (the java code just used to get date, the rest are
html and javascript),
to display a table. the requirement is the...
|
by: Derrick |
last post by:
I have a windows form, many combo boxes, i create items and add to the items
collection in code. When viewing form, many combos have their text
selected, highlighted. Is there a preferred way to...
|
by: BBFrost |
last post by:
Win2000
..Net 1.1 SP1
c# using Visual Studio
Ok, I'm currently in a "knock down - drag out" tussle with the .Net 1.1
datagrid.
I've come to realize that a 'block' of rows highlighted within...
|
by: Gary Shell |
last post by:
I have five comboboxes each has a item listed populated by hand in the IDE.
Each has the text property bound to a text field in the database. When I
initially fill the dataset and display the page...
|
by: CSharpguy |
last post by:
I have a drop down and based on the selection picked items in a list box are
selected. When the items are selected how can I show them at the top of the
list box instead of having to scroll through...
|
by: njuneardave |
last post by:
Hey,
Here is a quick question: I have two forms that I am using, and I need
to highlight the text in Form1 by clicking and dragging (obviously).
So, when I switch to Form2 (making it the focused...
|
by: Rich Raffenetti |
last post by:
I have a form with a listview control and a textbox. When I change focus
from the listview to the textbox, the highlighted item on the listview loses
the highlight. That is not the behavior I...
|
by: Doug |
last post by:
Hi
I am trying to find a way to make the mouse cursor move to the keyboard
cursor position in an application. For example, I use an application called
Enterprise Guide, and I control this...
|
by: NvrBst |
last post by:
ListView is in Detailed Mode, and an Item is in EditMode
(ListViewItem.BeginEdit()), how, if any, would I get the currently
highlighted portion of the text?
Basically I have a ctrl-c shortcut...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |