Dynamically search multiple fields (1 Viewer)

D

david.paton

Registered User.

Local time

Yesterday, 19:37

Joined

Jun 26, 2013

Messages

338

• Apr 18, 2018

• #1

I can't get the modification search tool working posted by John Big Booty here https://access-programmers.co.uk/forums/showthread.php?t=188663.

It doesn't make sense as I have used it before, have looked at my previous dbs and my db looks exactly the same as the previous ones that work.

What have I left out or done wrong? I have attached my db.

Thanks

 

Attachments

• Carers.v14.accdb.zip

  213.9 KB · Views: 52

MarkK

bit cruncher

Local time

Yesterday, 19:37

Joined

Mar 17, 2004

Messages

8,180

• Apr 18, 2018

• #2

Your QRY_SearchAll doesn't return any records even if you delete its WHERE clause, so even wide open with no constraints, it doesn't return any rows. There is not way, therefore, as you add constraints, that it will start to return rows.
hth
Mark

 

D

david.paton

Registered User.

Local time

Yesterday, 19:37

Joined

Jun 26, 2013

Messages

338

• Apr 18, 2018

• #3

That is what I was finding too, but I followed the instructions exactly and it still wouldn't work. Just thought someone else might see something that I am looking straight over.

 

J

JHB

Have been here a while

Local time

Today, 04:37

Joined

Jun 17, 2012

Messages

7,732

• Apr 18, 2018

• #4

david.paton said:

..Just thought someone else might see something that I am looking straight over.

Click to expand...

It's your data there has no context.
It table tblCarers, you've in CarersTownID = 4, but in table tblKSCarers you don't have a number 4 in KSCarersTownID.