Search results
-
M
Calculate "two years ago"
Dateadd("m",-23,[datefield]) Oops, got there before me. -
M
Update Main from after Data Entry in Subform
Form Think I'm going to change direction and just leave form as it is, but append the date back to a history table instead. Thanks for input. -
M
Update Main from after Data Entry in Subform
Data I do realise that, but here's my problem. The database was originally designed to track maintenance records and simply included last date completed and then it calculated the next due date. So the last date completed was simply overwritten each time and new due date generated... -
M
Update form or controls
AfterUpdate Ok, think I finally have you now. You need to put same after update event in the DT box as in the run box, ie Me.txtDTRegular = Round((txtAccTimeWorked) - (txtMinutes / 60), 2) Please tell me I understood you correctly this time! :-) M. -
M
Update form or controls
Refresh Then put the me.refresh in the afterupdate event of the control you are changing. Am I reading you properly this time? It IS Monday :-) M -
M
Update form or controls
Refresh Hi, In your afterupdate event code where you're doing the calculations, add a line me.refresh If I understand your problem correctly that should sort it. HTH Mary -
M
Update Main from after Data Entry in Subform
Hi all, I used to do a good bit of access but haven't touched it in a while and am stuck on something I feel I should be able to do. When I enter a date on a subform, I want the main form to refresh to reflect the new data. When I use requery, the data is updated ok, but the main form returns...