Thank you for your note. I will keep this information as well to see if changing resolutions would work. Just to let you know though, I have not saved this DB while on another monitor for at least 2 months now. Thanks again
Does anyone know how to fix what seems to me to be a bug in the query view? Using Access Office 365.
The tables and links are partially hidden and can't be adjusted. Scroll bar is all the way up yet I don't see the top of the view box to be able to adjust the tables in the view.
Thank you for your information and feedback. I do appreciate it.
Not sure if I am allowed to ask on this thread, but it is as a result of your comments and is the basis of my original post. If I'm not allowed toask, please feel free to ignore.
Do you have a suggestion on how to facilitate data...
In the attached sample DB I would like to figure out how to replicate the data of any record that has more than one item selected as part of the FirstName multivalue field.
So if the record has three names chosen, I would like to create three new records with each of those names but keeping the...
thank you again for trying to help me. I'm still lost and I guess I'm just not getting it today. I appreciate the time you have given me and don't want to waste any more of it just because I don't get it.
Thanks for the note.
I did actually watch your video several times earlier this morning in order to come up with an answer. You do show how to use Ubound to find the first instance of a chosen record. However, I was not able, even after watching it several times, to determine how to get all...
If I understand correctly, then if my multivalue field has the following:
I would have to check each ID # in the query in order to determine if I get a result?
Sorry, I am obviously not getting it.
Thank you for your reply.
Yes, it is of the checkbox type. I believe I also attempted what you suggested but I have always found that in the statement
If Me.nameOfControl.Selected(i) , Me.nameOfControl.Selected(i) always seems to return a value of 0.
Test DB attached.
At the risk of getting yelled at for asking a multivalue combobox question, I would still like to know, how does one cycle through a multivalue combobox to obtain only the records which were selected?
Combobox is called NamesList
I am using the following without success.
For Each oItem In...