Search results

I used the following code which removes the problem of an empty box. WHERE (((Hardware.Type)=[Forms]![QueryForm]![Type] Or IsNull([Forms]![QueryForm]![Type])) AND ((Hardware.Site)=[Forms]![QueryForm]![Site] Or (IsNull([Forms]![QueryForm]![Site])))); You can then add on additional AND...

Doesnt matter, I managed to sort it out using some sql code. Thanks Sam

I now have another problem.. Im trying to add other comboboxs to the form using the same method and I want to be able to select a combination of options and I want to be able to leave some of the boxes blank. It works when I only choose 1 using the 'or' function in query design but if i change...

Yep that fixed it, thanks so much :) Sam

Obviously this is not my real db but this query is identical to the one in my real db and only uses the one table and one form that I have included Thanks

It doesn't display any results, just returns a blank table Im only using 1 column Sam

Hi, I have a form (called 'QueryForm') with a combobox (called 'SerialNo') which displays the serial nos of different pieces hardware coming from a table called 'hardware'. I am trying to create a query which will use the data from the combobox to run and display all the information on a...

Ive managed to get it working using your code, Thanks very much! Sam

Sorry to be a newbie but how do i create a table of my reports? Thanks ;)

Hi, I have a list of reports and i have a drop down list on a form. I need to connect each of the options in my dropdown list to a different report. Can anyone help? Thanks, Sam

Yes but it still wouldnt work i think it may have somthing to do with my permission settings It dosnt matter now ive figured out how to do it, it was just a setting in the properties window Thanks for your help anyways Sam

I wont accept the last line of code, it gives an invalid character warning on the commas I am using 07 if that makes any difference

No it is from a control form Im gonna try that code Thanks

Hi all, I need some help with a database that im working on. I have a table that I am opening using a form but when i open the form I want it to display a blank form so that I can input new data and not just show the current data. Any advice would be very welcome Thanks Sam