Recent content by SJLyall
-
S
Query to update table but no result
Excellent. Many thanks for your help. All OK now. -
S
Query to update table but no result
Hi I have a created a query which I want to update a table. The field is called DTP. I have the Workingdays2 module in place as well as the Holidays Table. The dates (date only) are called Time in and Transaction date. I want the table to upate records only if the entry in Completed is Yes. I... -
S
Auto-populate current date and time when other fields completed
OK. I have the completed and EXLEnd piece working using the coding below: Private Sub Command44_Click() On Error GoTo Err_Command44_Click DoCmd.GoToRecord , , acNewRec Exit_Command44_Click: Exit Sub Err_Command44_Click: MsgBox Err.Description Resume Exit_Command44_Click End... -
S
Auto-populate current date and time when other fields completed
Hi I have a table called Neutron2015. I want the current date and time to complete when entries are made in two other fields. So I am looking for this date and time to populate in EXLStart when an entry is made in Processed By, and also the current date and time to appear in EXLEnd when an...