Recent content by wware

Well, I guess I have something functional using KeyUp. See below. As is often the case, describing the problem to other(s) can result in my own mental breakthrough. If anyone can offer further advice/warning, I'd still appreciate it. Private Sub Textq1_KeyUp(KeyCode As Integer, Shift As...

Textbox is bound to underlying column in a table which is number datatype. This is appropriate. Now user want option of entering "NA" into this textbox which would set the value of this bound textbox and also another bound textbox to 0. In other words, entering "NA" in this textbox sets two...

thanks for answering your own Q I just searched for and found your post (a month later) and it answered my Q perfectly in seconds. Thanks for being a good neighbor.

Glad it is working for you. Add an "order by" clause to the row source property of the combo box. Wendy

Oops, I think I gave you the wrong Wizard option to choose. You want "Find a record on my form based on the value I selected in my combo box" not "I want the combo box to look up the values in a table or query." My bad. My bad. Try this option. It should give you everything you want...

Not sure I understand you. It should work that way automatically. That's exactly what it does - loads the record onto the form (assuming you have a regular form with the table as its recordsource.) I've thrown it onto forms and it just works beautifully. Have you tried it yet? Perhaps you...

Glad you like it. I guess that means I officially wasn't talking to myself which appeared to be the case on this thread. It was a long day. Wendy

Better code for a long list. ------------------------- Private Sub ListLineOfBusiness_Click() Dim i As Integer 'if user selects "all" deselect all others If Me.Listlineofbusiness.ListIndex = 0 And Me!Listlineofbusiness.Selected(0) = True Then For i = 1 To Me.Listlineofbusiness.ListCount -...

Never mind. I got it. Listindex property. Rookie question, I know. -------------------------------------- Private Sub ListLineOfBusiness_Click() If Me.Listlineofbusiness.ListIndex = 0 And Me!Listlineofbusiness.Selected(0) = True Then Me!Listlineofbusiness.Selected(1) = False...

list box - 1st item alone OR mult items (not including the 1st) If user selects 1st item in list box, I want to deselect all others. But, if the user selects the 2nd, 3rd, or 4th item I want to deselect 1st item only. In other words, valid choices are: 1) 1st item only ("all") 2) one or...

It's possible I'm not fully understanding your issue but it appears to me that you are sorting by AcctNo, not by KarianceCurrent.

I have one really simple trick I like to use. One of the choices for the Combobox wizard is "I want the combo box to look up the values in a table or query." Super easy to throw one of these on the form and it gives a lot of bang for the buck. Make sure the query in the combobox's rowsource...

That was a fine suggestion! I took all the criteria out of the query. I used VB to build a filter for the report I was opening with DoCmd. Works perfectly. I'm still a little frustrated that I couldn't put my criteria in the query to simplify the testing but I'm not going to complain...

query criteria - building "In" clause in "hidden" textbox - mult values I have a report that has an Access query as its record source. I have a form for the user to enter criteria for the query. I have combo boxes that hold query criteria and they all work fine. I have a list box control with...

It's asking you for a parameter because you have brackets around the 7000. Instead of this: Like "*" & [7000] & "*" Use this: Like "*7000*"