Search results
-
V
Increment Field Values
Fields on different tables Hi Thanks for your interest the problem with using DMax() in this example is that the field criteria upon which the FileNo field value should change is not in the same domain i.e. table. The FileNo field is in tblFile and the FileTypeID field is in tblFileType so... -
V
Increment Field Values
Hi I have a numeric field called FileNo and an autonumber field called FileID in a table called tblFile. I also have a lookup numeric field called FileTypeID (with values 1 or 2 or 3) on another table called tblFileType. I need the value of FileNo which I am showing on a Form frmFile to change... -
V
Query Criteria
I have a query based on a table that contains a field called Client On the criteria line on the query I've got [Enter Client] so that the query can run based on the client the user enters on the dialog window input box. Is it possible to show a list of clients currently on the databse on this... -
V
Blank Page Printed
I have an access report that adds up values, I've used a text box on the report footer to do this the problem is I always get a second blank page printed. ViRi