Search Form

Hello,

I have a form named [Search] it has several unbound textboxes with the name property set to this method[qfield] each textbox default value is "".

I have a button that will open a report once clicked. The report RecordSource is a query [qrySearch].

The query has several fields each with this Criteria:

Expand|Select|Wrap|Line Numbers

Like [Forms]![Search].[qfield] & "*"[

My problem is if a value in a record is null, it does not return in my search. I need it to return records with nulls as long as all the other requirements are met.

How do I have my query include records with null values if no other criteria is set?

Thanks for any help/advice you can provide!

Nov 30 '11 #1

Subscribe Post Reply

✓ answered by NeoPa

It doesn't help that you left out the field name from your example, but essentially you can use :

Expand|Select|Wrap|Line Numbers

Nz([FieldName], '') Like [Forms]![Search]![QField] & '*'

PS. Dot (.) references are not recognised in SQL, or by inference, filters etc (which are also SQL).

918

NeoPa

32,556

Expert Mod 16PB

It doesn't help that you left out the field name from your example, but essentially you can use :

Expand|Select|Wrap|Line Numbers

Nz([FieldName], '') Like [Forms]![Search]![QField] & '*'

PS. Dot (.) references are not recognised in SQL, or by inference, filters etc (which are also SQL).

Nov 30 '11 #2

wisni1rr

Solved!!!

Thanks bunches, NeoPa!

Dec 1 '11 #3

NeoPa

32,556

Expert Mod 16PB

Always pleased to help :-)

Dec 1 '11 #4

by: misschristalee | last post by:

I'm having a brain blockage day.... Scenario: Search Form with 6 text boxes Query has same six fields Each has this IIF: IIf(IsNull(!!),"",!!) with each dictating the correct text box of...

Microsoft Access / VBA

Example Search Form Required

by: Liddle Feesh | last post by:

Hi, I have a table named "Person" in a MSDE (2000) database, and am building a search form comprising of search fields on the top section (forename, surname, telephonenumber, etc) which all...

Visual Basic .NET

A very basic search form in access

by: jim Bob | last post by:

Hi, This is probably very simple to do so if anyone can point me to the right place for reading, it would be much appreciated. I just want to build a very basic search form where i can enter a...

Microsoft Access / VBA

Search Form

by: Eddie Holder | last post by:

Hi Guys, I hope that someone will be able to help I have a table containing data, lets say products. I have a form with a text box which serves as the criteria for a query to search the product...

Microsoft Access / VBA

Is Unbound Search Form the best solution?

by: DWolff | last post by:

I'm somewhat new to Access, and have no VB experience at all (except for modifying existing code where obvious). I built a data entry form that works fine. Typically, a client will call in and...

Microsoft Access / VBA

Search Form: multiple controls (Access 2003)

by: lightning | last post by:

Hi all, I'm not very conversant with the vocabulary of Access, so please ask for clarification if necessary... I am trying to build a search form that allows combinations of search terms. For...

Microsoft Access / VBA

Nested sql on search form - "in" works, "not in" doesn't

by: KiwiGenie | last post by:

Hi..I am trying to make a search form. I am fairly new to access and could well be looking at it completely wrong. I have an unbound form with textboxes in the header for entering different search...

Microsoft Access / VBA

Problem with reading utf-8 data from MS Access using asp search form

by: tamoochin | last post by:

I have a form that registers the user with my website, the form is in farsi language and must use utf-8 standard. I can store data in MS Access and also read it back with any problems. the...

ASP / Active Server Pages

Problem with search form

by: Mark | last post by:

Hi All, I am creating a music database for a friend and have run into a problem. Within the ALBUM table, I wanted to store the ARTIST_ID rather than the ARTIST_NAME. To do this, I intended to have...

Microsoft Access / VBA

Multiple list selection in search form

by: munkee | last post by:

Hi everyone, I am using the following code adapted from Allen Browne: 'Purpose: This module illustrates how to create a search form, _ where the user can enter as many or few...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

✓ answered by NeoPa

Similar topics