parameter query, form-based

[Lifeseeker]

Hi,

Ｉ　ａｍ　ｔｅｓｔｉｎｇ　ｏｕｔ　ｔｈｉｓ　ｍｅｔｈｏｄ，　ｗｈｉｃｈ　ｉｓ　ｆｏｒｍ－ｂａｓｅｄ　ｐａｒａｍｅｔｅｒ　ｑｕｅｒｙ．　Ｉ have attached a copy.

Ｔｈｅｒｅ　ａｒｅ　ｏｎｌｙ　ｔｗｏ　ｆｉｅｌｄｓ　ｏｆ　ｉｎｔｅｒｅｓｔ．　Ｉ＇ｍ　ｓｔｉｌｌ　ｓｔｒｕｇｇｌｉｎｇ　ｗｉｔｈ　ｔｈｅ　＂ｉｓ　Ｎｕｌｌ＂　ｉｎ　ｔｈｅ　ＯＲ field. I think that's where the problem is, but I'm not sure how to go about fixing it...

Right now, if I　ｌｅａｖｅ　ｂｏｔｈ　ｆｉｅｌｄｓ　ｅｍｐｔｙ，　ｎｏｔｈｉｎｇ　ｉｓ　ｒｅｔｕｒｎｅｄ．　Ｉｆ　Ｉ　ｏｎｌｙ　ｏｎｅ　ｏｆ　ｔｈｅ　ｆｉｅｌｄｓ　ｅｍｐｔｙ，　ｎｏ　ｒｅｓｕｌｔｓ　ｒｅｔｕｒｎ．　

Ｉ＇ｍ　ｐｕｌｌｉｎｇ　ｍｙ　ｈａｉｒ　ｏｕｔ　ｏｎ　ｔｈｉｓ　ｏｎｅ．　Ｃａｎ　ａｎｙｂｏｄｙ　ｈｅｌｐ　ｍｅ？

thank you

 

[speakers_86]

First off, why is your text like that?

Secondly, I don't think we are supposed to upload .mdb files. You need zip it first.

 

[Brianwarnock]

Hmm post text very odd.

It is permissable to post MDB but most prefer a zip file as you can look at it without saving to your harddisc in order to unblock.

I couldn't figure out what was wrong but on redoing the query it worked

SELECT TEST.authority, TEST.Local_region
FROM TEST
WHERE (((TEST.authority)=[forms]![search]![text0]) AND ((TEST.Local_region)=[forms]![search]![text3])) OR ((([forms]![search]![text0]) Is Null) AND (([forms]![search]![text3]) Is Null));

You should consider
1 Using a decent naming convention eg frmSearch,, qryRecords cboAuthority etc

2 Also using cascading Combo boxes as the choice of 1 limits the choice of the other, search the forum

Brian

 

[boblarson]

Just to confirm - it is okay to post an mdb or accdb file without zipping. Although it would need to be small enough in file size to do so.

 

[Brianwarnock]

A light bulb came on as I looked at my code and then yours, the Parameter clause is causing your problems, you don't need it when the parameters are coming from a form, and it appears to dislike the Is Null.

I should have looked at the SQL to start with.

Brian

 

[speakers_86]

If his text didnt look like that i wouldnt have said anything. I figured he was a spammer.

 

[spikepl]

Spammer? No, just multiposts http://www.access-programmers.co.uk/forums/showthread.php?t=209800

 

[Brianwarnock]

They appear similar but are different problems.

Brian