Search results

I made the change and it works perfectly! Thank you very much indeed, this has been bugging me all week :)

Apologies, I had meant to upload a 2002-2003 version. I have tried to enter your code, but to be honest I may have made some errors, as I am fairly new to access. Here is what I entered: WHERE ([Car Model]="*" & forms!F_cars!cbo_model & "*" or Forms!F_cars!cbo_model is null) And ([Car...

I just want the following: If the combobox is null, return all records including null values If the combobox contains any value, return records matching the selection Here is a simple database demonstrating the issue, if anybody gets a chance to have a look at this I would very much appreciate it.

Thanks Brian, this works like you say it will and is almost what I need, but I should only see null values when a combobox is left blank. If somebody has specified 'Ford Focus' and 'Red' I want them to see a list of, say, 20 red ford focus cars. If somebody has specified 'Ford Focus' and left...

Hi Brian, I am not refering to a universal law of comboboxes, just stating what is occuring in my particular case. I understand your point, but my understanding is that the statement "*" means "all records except null values", which is a problem for me as I want to include null values. For...

Hi Bob, yes I think you are right, I will look for alternative options. By the way I have found some of your other posts on here very useful, so thanks for your contributions. Uncle Gizmo - I will let you know if I find some sort of work around. To me it seems strange that you can't simply say...

Thanks for your help, but no luck on this yet. When I make this change, if the comboboxes which serve to filter the query are left without any value, the query results do not list all records including nulls; they list no records at all. I may be wrong but I think the problem is the function...

Hi Bob, I should have explained: I have a series of comboboxes on the form which serve to filter their respective fields of the query. The user can choose how many, fields they wish to filter in the query at any single time. The method you have suggested was my first thought, but using that...

Its certainly not my work, so it could well be one of your examples that I came across on the internet. It works great apart from this null value issue. I would prefer not to replace all of the null values if possible, because the fact that they are null is relevant, but I will keep this as a...

Hello all, I have a combobox on a form which filters a query. When nothing is entered into the combobox, the query lists all results excluding null values. This is what I want, but I also want the null values included. I am using the code below: Public Function fCboSearch(vCboSearch As...

Hi, I would like to have a combobox on a form, which allows one to select a year, and upon doing so this will filter the records displayed in the subform so that it only displays those records from the selected year. To do this, do I need to enter a VBA code into the 'after update' property of...

Tough crowd...have I confused everyone with my messy description?

I have a main form and a subform. The subform displays fields also visible in the main form such as 'Name'. When I click a button on the main form it opens this subform. The problem is this: Everything works fine with existing records, but when I click a button on the main form, to open up the...

Great - this worked exactly as I wanted. Thanks very much!

Hello all, I would appreciate some help with the following: I have two images per record on a form (img1 and img2). I want their visibility to be determined by a single clickable button (btn1). Once clicked on I would like this button to change its text caption to either 'On' or 'Off' and the...

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) Many thanks for your help Steve, I have learned a few new things. In the end I did as you suggested and eliminated the need for the Dlookup.

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) Thanks for your help. I tried the updated code and the text box is now showing the correct colour for each record, however it still comes up with the syntax (missing operator) error when I scroll to a record in which there is no...

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) Thanks Bob, ok I have now tried this and it came up with a Compile error: Wrong number of arguments or invalid property assignment. Here is what I entered: Private Sub Form_Current() lonResult = DLookup("[Colour]", "Colours"...

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) No I left it blank/unbound. I wanted TB1 to simply display the colour of the underlying Colour_ID. Should I have set the control source to something?

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) Hi Bob, Colour_ID is a number field (autonumber), and is the primary key of the table 'Colours'. Any more ideas on this one?