Search results

Update : Pls refer Brian's post (POST 12) in : http://www.access-programmers.co.uk/forums/showthread.php?t=245511 Thanks

Just check if below gives some guidelines : http://www.access-programmers.co.uk/forums/showthread.php?t=221558 perhaps, something like : SELECT myTable.TheID, myTable.myField FROM myTable WHERE IIf ( Len(Trim(Forms!Form1!txtmyField))>0, ((myTable.myField) Like "*" &...

I tend to agree with them :D :D :D, but then, you are equally an hero. :)

Do all your fields (Edit : Field_A,Field_B,...., Price_A,Price_B,.....) have values in them ? Thanks

Glad you found it helpful. Thanks :)

Check keyword "LEFT JOIN". Edit : along with Nz(). Thanks

of information about

Tables loaded with

I really don't know, why those two pages are not working at your end. They are working perfectly fine at my end. Sorry, hope some one comes across this thread & shows us some light. Have you tried posting on any php forums? Thanks

The "Thanks" button is taking me to the Reply screen???? Thanks Gemma & Pat.

Hi, Does above indicate using pseudo autonumber id as primary key, preferably ? Thanks

Hi, Can I request you to elaborate on this ? Thanks

Decided to check out & wrote a couple of Test Pages. It is working at my end. Note : I was not able to replicate the exact situation at your end due to my limitations of coding in php. All the same take a look. A simple table employees with fields EmpID, EmpName, EmpType_ID The 1st Page...

Ok. Thanks

Basically, AFAIK, anything after the return statement in the Function should not execute. Just as a trial, try the below & see what happens : 1) Move $query_string->free(); $result1->free(); above return $res_array; inside the function, and see what happens. or 2) Move...

Does an echo after the Return statement in the function print. Thanks

Usually the moderators or more senior members welcome you immediately. Occasionally, it so happens that they are not around. Don't feel dis-heartened. Start posting your questions & I am sure you will be more than happy with the replies & the guidance that you get. By the way, Till Some one...

AFAIK, loading 2 data sets should not be a problem. Don't have the solution, all the same, just check out if u have not done the below. 1) have you checked the page source for the final page which throws up the error, to see if you can get any hint. 2) Have you tried putting in a few echo or...

Glad you found it helpful. Thanks :)

Till someone comes along, just check out if below gives some guidelines : SELECT Table2.CLIENT, Table2.PRODUCT, Table2.MIN_NUMBER, Table2.MAX_NUMBER, Table1.Client, Table1.Product, Table1.Number, IIf([Number] Between [MIN_NUMBER] And [MAX_NUMBER],[Number],0) AS ValidNumber FROM...