Recent content by stretch

Well it beats the thoughts I had so far - was looking at these two : "No plan survives first contact with the enemy" or "There is no problem that cannot be solved by the application of High explosives"

Fantastic - works perfectly ..... Now - all I've got to do is think of a natty quote to put under my signature !!

I have a form which contains a checkbox along with some other Yes/No Controls. The form updates a table. When I run queries on the table, the value shown for the checkbox is always either -1 or 0 - now I understand that is correct, but is there any way to display that as yes or no in in the...

Many thanks - that worked perfectly !! Job Done !!

Hi all I have a DB which uses a union query. The DB is based on 3 tables. Everything works fine except - The 3 tables have the format property set to > (to force upper case output) This works fine on all my other queries, but on the Union Query, all the data comes out exactly as it was...

Thanks I'll give that a go !

Wayne Thanks for your insights - much appreciated - I don't really get this whole recordset thing - I've not used it before, I thought when I set rs = db.openrecordset("SuppList") it populated the recordset from the supplist query. How do I populate it then?? Also, I set the value of...

Thanks for the quick response, but that's not it - this is a nested loop - the second Next you can see refers to the intcnt, The first one is correct . Thanks again

I'm really struggling with this - and have been for about 4 days !! I have a query called SuppList that contains two fields - supplier and Suppname and has 101 records I need to loop through this query and use the supplier in each record as the criteria in another query and then output this...