I am currently using a form to track employee time to customer and warehouse. I want to be able to take information from one record and post this to tne next record(finish time on the first record to the start time on the next record)as well as employee name etc: any ideas??
Here is the copy of the code from my form.
Option Compare Database
Private Sub Command37_Click()
On Error GoTo Err_Command37_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Employee Production Overtime"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command37_Click:
Exit Sub
Err_Command37_Click:
MsgBox Err.Description
Resume Exit_Command37_Click
End Sub
Private Sub Command44_Click()
On Error GoTo Err_Command44_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Employee Production Overtime"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command44_Click:
Exit Sub
Err_Command44_Click:
MsgBox Err.Description
Resume Exit_Command44_Click
End Sub
Private Sub Command54_Click()
On Error GoTo Err_Command54_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
Exit_Command54_Click:
Exit Sub
Err_Command54_Click:
MsgBox Err.Description
Resume Exit_Command54_Click
End Sub
Private Sub Command56_Click()
On Error GoTo Err_Command56_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Command56_Click:
Exit Sub
Err_Command56_Click:
MsgBox Err.Description
Resume Exit_Command56_Click
End Sub
--
Message posted via http://www.accessmonster.com