Z
Zaradi Zakaria via AccessMonster.com
Hi,
I just created one command button to assign a few task;
On Error GoTo Err_Command23_Click
Me!DateUpdated = Now()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Command23_Click:
Exit Sub
Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click
End Sub
User choose some particular value(Name) at combobox (using SELECT DISTINCT
and Control Source to a query) and click that command button, DateUpdated
field should update latest date and then save. It works fine, but I just
curious when a few data came out there're missing with value (Name) or
DateUpdate. If user just choose value at combo box is there anyhow Access
still save it without click command button? And is there any difference to
save with:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
vs- only DoCmd.Save?
Which one is more secured?
I just created one command button to assign a few task;
On Error GoTo Err_Command23_Click
Me!DateUpdated = Now()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Command23_Click:
Exit Sub
Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click
End Sub
User choose some particular value(Name) at combobox (using SELECT DISTINCT
and Control Source to a query) and click that command button, DateUpdated
field should update latest date and then save. It works fine, but I just
curious when a few data came out there're missing with value (Name) or
DateUpdate. If user just choose value at combo box is there anyhow Access
still save it without click command button? And is there any difference to
save with:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
vs- only DoCmd.Save?
Which one is more secured?