Recent content by sailorguy

Oh, thanks I didn't realize that. Worked easily! Thanks

Hello there, Still learning so please be nice:-) I want to create a simple report based on 4 queries I have. The queries all work fine, and show me unused DN, TN, DID, Phantom numbers from their respective tables (2 columns each the "number" and the "numberID"). I can create a report simply...

Duh, I knew that:-) Stupid me forgot to do it for the hidden field as well. Working perfectly...thanks again!

Hi Booty, You are right...I didn't quite understand at first, but this does EXACTLY what I want. It works great! One additional thing I would like is a little button beside the search box to clear the "filter". What would be involved in this?

Hi Booty, I had read that when I was searching, but again this looks like it uses a query to search for the string. What I have is a listbox already populated on a form, which I want to search. Maybe I don't understand quite what that solution is doing. Thanks!

Hi, I'm not sure that's what I want. I apologize for a poor description, as I'm still a newbie. My form is using the listbox to display "completed" records. Currently I have code that allows me to double-click any of the lines to open a different form to edit that record. The trouble is...

Hi, It seems searching is a common question, but I haven't seen what I'm looking for exactly. I have an unbound listbox which displays over 200 records with various strings. I want to search the entire list box and find the matching value as entered in a textbox on the form. I basically want...

I'm not sure about two equal posts.... I first wanted to know how to expand the list box as rows were added, which I learned thanks to that post. What I discovered today, was that code had an unexpected problem which I know understand and can overcome. But thanks for your comment anyway...

Hi, Thank you, I wasn't clear. The listbox is being populated by various combo boxes on the form. I am using the following code to increase the height of the listbox as more rows are entered. I take it that is the problem then? Will I have to remove this code to continue? getListboxCount...

Hello, I have a form which has an unbound listbox with a number of columns and currently about 100 rows, but I'm entering data and came across this error "the control or subform control is too large for this location". Is this a limitation of the listbox? How could I get around this? I'm...

OK, I got this figured out... If Me.cmbDN & "" = "" Then Me.cmbDN = 0 End If For each of the fields

O.k. sorry I'm a newbie... So my combobox source is a query. The query itself doesn't have any NULL values, but if I choose a value then backspace it the table is updated with a NULL value for that field. I can't add a 0 in the combobox because there are no 0 values in the table that the...

I'm not familiar with this function. How is this used on this combobox?

Hi, I have a 2 column combobox which updates a table. The combobox field is not a required field in the table, but if nothing is entered, the table field needs to be zero. The table field property "default value" is set to "0". If I select a record in the combobox, but then backspace because...

Amazing! Thank you so much for helping. This works great...another one to keep in my book of tricks. Again, thank you for explain it...I understand what's happening:)