Search results

do each of your five table share the same fields layout, and how many fields do you need to search in, in each seperate table?

so you have on a form a button to preview and to print the report. Why not in the code of the print command button write some code, that disables the form once its been printed. But the user could still print the report by previewing it, and then printing it that way. You could have a field...

what are you trying to do, if you could explain a little more, then i may be able to assist you...

expand the length of the labels and the text boxes slightly to stop this happening. If you use bold for the lables, then when it get transfered into a rft file they expand and cause the last word to sometimes disappear down to the bottom of the page. Hope this helps.

The way i would do it, not saying its the fastest, but i know it works. Is to use an update query. Do the following:- Create a new table (i've called it New_Grade), with two columns (Grade and Value), one the Grade i.e A+ etc, and in the other column put the Grade which you need to change it...

couldn't you do a simply update query. This is assuming that the table are linked by an ID number