Search results

Hi, I have generated my qry and have placed a criteria in one of the fields, when i run the qry it prompts as requested for the criteria but it then continues to prompt for additional criteria from other fields event hough i have not asked it to do this? can someone please advise of how to...

I have tried using auto numbers but then had trouble resetting it? i shall attempt the other method given Cheers

I would like to create something that is going to increace a value by one automatically. I have a field on my form and in that field i will enter a unique record specific number, i woul like that field to know that we have allready used lets say up to 009 so the next time someone clicks in this...

you can set which field your table starts in by default by selecting the TAB ORDER on the properties page. If you set the field you wish to start n to 0 then when you open the table the cursor will automatically go there.

I am trying to get a sub table to work and stay in, On my main table i have a record field that uniqely identifies that entry but i need more than one record that relates to that number. I am trying to create a sub table but when i insert the sub table and close after saving it is not there...

solved the problem myself Ok, after many more attempts i have solved the problem and as it happens there was no Macro in sight. I am actually embarased as to how siple it was: I created a lookup query with a criteria int he relevant field to coose the specific record, this then gave me the...

Hi, What i have is a DB with one main table, I have a main data input form and from here i wish to print reports. Once someone has entered data in the form and added it to the table i would then like to be able to click a button that will copy the record from the table to a report (Pre...