Search results

thanks that works!

Hi, the reports I created cant be run because I do not have a printer installed. I don't know if its possible, but Ive recently uninstalled my printer, and I do have another printer OR my microsoft windows 98 disc, but can I run these reports without a printer installed? Thanks in advance

Thanks, but I'm afraid that doesn't work. The listbox is a multiselect box. The record I want it to find depends on the contents of 3 boxes: combo1 (name), combo2 (filetype), list1 (box) The findfirst needs to look at all three boxes to select a record. The listbox can contain more than one...

I have a question regarding the findfirst command. Is there a way of setting a condition: eg. WHERE boxno = list14 AND name = combo1 Could somebody please help?!

Hi, I gave the original problem, and tried what you said. As code is an autonumber - numeric I tried the code below: (the other line didnt work) rs.FindFirst "[code] =" & Me![List1].Column(0) At first there was an error messgae, but when I changed the Column number to 0 that seemed to rectify...

I am having trouble finding the record I want on a form. My form contains 2 combo boxes, a listbox, and 4 other text boxes. When the user selects a value from each of the combo boxes, a query is run to determine the listboxes contents. The listbox has 2 columns - one is hidden as it is the key...

I've fixed it, it was due to the column widths. There were 2 values and I've altered the column width accordingly.

I have a confusing problem, my form contains 2 combo boxes, a listbox, and 4 other text boxes. When the user selects a value from each of the combo boxes, a query is run to determine the listboxes contents. The listbox is has 2 columns - one is hidden as it is the key field, the other is the...

Hi Mile-o-phile, have you had a chance to look at the database I sent yet?

Database I've managed to shrink it!

Changing the name didnt affect it, I tried to attach a copy of the database zipped, but it is too big. The code you sent me last is the one I am using.

I'll change the name from true to tr if that helps

Thanks for your help on that, I've sorted that part but when I choose a value from my combo the following error appears: Run-time error '-2147352567 (80020009)': The value you entered isn't valid for this field. Me.true = DLookup("[missing]", "[query1]") - line highlighted Is it because this...

Problem Hi, thanks for the code but slight problem, error message: User-defined type not defined rs As DAO.Recordset Do you know what this means?

Reply I'm afraid that doesn't work. Here is my code: Dim rs As Object Set rs = Me.Recordset.Clone rs.findfirst "[name]='" & Me![Combo1] & "'" Me.Bookmark = rs.Bookmark Me.lst.RowSource = "SELECT dead.[box] FROM dead WHERE (((dead.[name])=[Forms]![Dead]![Combo1]));"...

No, just the first value will do

I am having a problem with a listbox. After updating a combo box I want it to immediately select a value from a listbox. This is all on the same form and it is necessary so I can run a query. Can anybody help please?

Thanks for your help, but I don't think that will work as I am not using any queries currently. Also the boxno can be true AND false as the box usually holds more than 1 file of a client. Thats why I need to check the client name AND the boxno to see if it is missing. If you are...

Hi, I am currently having a problem getting a true/false value from a table based on the values in the two other fields. My three fields are in the table are client names, boxno, missing (which is true/false). I have a combo box with clients names which after update affects a listbox contents...