Recent content by Advertiser

onexit code... (assume field name is tmpField1) if TmpField1<> 9 then cancel = true Only if the data entered is 9 will it move to the next field!! (You will also need to supply a way of gettin out e.g. if TmpField1 = "Exit" then TmpField2.setfocus : Exit Sub

Someone posted something here and it was not me. I got an email saying a login attempt had failed. I do not understand.

If you link your currency types to a number ( of decimal places), when you display your form, use the oncurrent event to reset the number of decial places to diplay on that record. OK?

Based on the fact that the ID is unique... Do a totals query with ID2 as the 'group by', date as the MIN and ID as the MAX !! sql = "SELECT ID2, Min(DateField) AS MinOfDate, Max(ID) AS MaxOfID FROM tablename GROUP BY ID2" George

Have a look at the variable DIRTY You can use the Dirty property to determine whether the current record has been modified since it was last saved. For example, you may want to ask the user whether changes to a record were intended and, if not, allow the user to move to the next record without...

Use the DateAdd function and set the period to 'w' (weekday) George

Are you happy to use a SQL statement CREATE TABLE ?

I assume you mean when you place the cursor in a field on a form. If that is so, put your code behind the on click or on exit event George

Multiple If's You could consider select case Select Case a1 Case "Invoiced" do action 1 Case "Paid", "part paid" do action 2 Case Else do action 3 if 1 and 2 fail End Select Note case 2 - it is multiple selections - easier to see George

Thank you So easy when you know how !! Cheers George

It appears that I have somehow caused modules to ignore error traps. Routines with 'on error resume next' and 'on error goto...' are totally ignored. Any ideas how I have managed to do this on my PC. If I transfer the code to an other PC then the error traps all work correctly. Suggestions...