Search results

i am trying to get out of overtype mode in access 2003 how do i do it

((IIf(IsNull([forms].[SEARCH]![SECTION]),[Located in].[SECTION]=’*’ ,[located in].[SECTION]=[forms].[SEARCH]![SECTION]))<>False) I need the true part of the statement to all return all records null and those with a value, what I have there is not workin

what is the sql for returning all records including those with a null value [located in].[JOB]= null values and all values null values and all values=

I have a form that has 6 fields (job, lsd, sec, twp, rge ,mer) the form gives data to a query. a record is made up of the 6 fields above, some are null and some have data (numbers) I want the query to constrain only by the fields that are filled in i.e. if the user only types in a value for...

I want to password protect particular forms. I can't use user group and permission as I would have to change the entire network setup. I just want a password required to open a particular form. I was thinking a "enter password" form that would either come up with an error message form or the...

I want the hyperlink field to take the value of a another field (job in this case) and use it in the hyperlink address i.e. two fields - job and hyperlink jobs are numbers that corresond to autocad files (O-1900.dwg) that are on a file server) i want the hyperlink field to have the link to...

I want to search the entire table to for a parameter i.e. there is a field with data PC 12-10Dr 46-48-5W5M if I type in pc 12-10 in the form it should return the record above but its not.?? Here is the criteria I used when I use the criteria like"pc 12-10*" it works but not when I use the...

I have 5 fields in a table that is either blank or contains a integer. call them fields A,B,C,D,E When I run my query i want the user to type in a number for A,B,C,D,E or leave it blank. If the user leaves the parameter blank I want the system to return all values for that field including...

My Query looks like PARAMETERS LSD Value, [SECTION] Value, TOWNSHIP Value, RANGE Value, MERIDIAN Value; SELECT [located in].Lsd, [located in].Section, [located in].Township, [located in].Range, [located in].Meridian, [located in].Job FROM [located in] WHERE ((([located in].Lsd)=[LSD]) AND...

I have a table (located in) that is the middle table in a many to many. Job=primary key each job has a legal description or part of a legal description legal description is 5 fields= lsd, section, township, range, meridian the user will want to search all jobs that are in lsd 1, section 1...