Search results
-
A
Delete record when null
Sorry Zaeed, wont this delete all records this user has in this table? i only want to delete the one with the null values which shows on the form..... Sorry! -
A
Delete record when null
Hi Zaeed, i have got an if statement on the isnull, my code looks like this: Private Sub Days_Leave_BeforeUpdate(Cancel As Integer) If IsNull(Me.Days_Leave) = True And IsNull(Me.LeaveFrom) = True And IsNull(Me.LeaveTo) = True Then End If End Sub This is how far i have got with this, is... -
A
Delete record when null
Hi all, I have a form which uses a subform. The main form finds a doctors record eg name, assignmentno (prim key), and the hospital they work at. The subform shows their sick record, when i enter a value into the "daysleave" field on the subform and then delete it and go to go off the the... -
A
Open Form and Increment table value
you see the problem is each doctor could have 32 or 27 days depending on how long they have been with us.... -
A
Open Form and Increment table value
so could i make a table called say tblAnnualleave and in this table store "assignmentno" and "daysalloc" or would this create the same problem? -
A
Open Form and Increment table value
x = x + 1 i am using a query to find the assignmentno currently being used by the open form which works fine but when it tries to update i get that error, i am doing daysalloc = daysalloc + 1. -
A
Open Form and Increment table value
I have a database to record annual leave of all the doctors in the hospital i work in, when a doctor works a bank holiday they get an extra days worth of annual leave, at the beginning of the annual leave year we allocate each person a certain amount of days leave which is kept in the staff...