Search results

Hello. Sorry to regurgitate this thread. I'm having the exact same problem so I'm trying to use the code you've written here but I can't get it to work for all 3 fields. Could you help me with where the "IIF(IsNull" is supposed to go in the following? WHERE (((Chemicals.Chemical) Like "*" &...

Just to clarify, I want any person to be able to use the search form, type in a chemical and have the information come up regardless of whether some of that information is missing or not

Hi there. Unfortunately nulls will have to be a part of this database as a lot of the information is lacking, especially on older chemicals. I don't know 3VL sorry, I'm an absolute newbie when it comes to Access.. I will watch the video

Hi there. The instructional video that I watched on YouTube said to put the Like operator in as such so that the query reads it as including the search word.. e.g. if someone looks up a chemical and just types 'hydro', the query will read it as *hydro* so any chemical including the word 'hydro'...

Hi there, I have a database in which I am building up an inventory of all the chemicals in our laboratory. There is a table in which all the data is stored (Chemical), a query (ChemQuery) and a form for searching (ChemSearch). There is also one more form for data entry (ChemicalEntry) but...

Hi there My name is Hayley, I'm a science technician at a high school and I am interested in learning how to use Access correctly to create a more efficient database for our science department. Currently it consists of.... Microsoft Word. Lol. I like music, BMX, martial arts and drinking.