C
code help
Private Sub co26_click()
'co26 is button
Me.salary_edit.Form.Visible = True
If salary_edit.Form.RecordSource = "" Then
DoCmd.RunMacro "add"
MsgBox "Êã ÇÚÊãÇà ÔåÑ ÃŒÃÃà ÈäÌÇÃ"
Else
MsgBox "ÇáÈÃÇäÇÊ ãæÌæÃÃ¥ ÈÇáÃÚá"
'DoCmd.Echo False, "add"
DoCmd.CancelEvent
Me.salary_edit.SetFocus
End If
If Me.Frame16 = 1 Then
Me.salary_edit.Form.RecordSource = "ida salary edit q"
ElseIf Me.Frame16 = 2 Then
Me.salary_edit.Form.RecordSource = "sina salary edit q"
End If
Me.salary_edit.Form.Visible = True
End Sub
i need to stop macro only or run it one time every month
'co26 is button
Me.salary_edit.Form.Visible = True
If salary_edit.Form.RecordSource = "" Then
DoCmd.RunMacro "add"
MsgBox "Êã ÇÚÊãÇà ÔåÑ ÃŒÃÃà ÈäÌÇÃ"
Else
MsgBox "ÇáÈÃÇäÇÊ ãæÌæÃÃ¥ ÈÇáÃÚá"
'DoCmd.Echo False, "add"
DoCmd.CancelEvent
Me.salary_edit.SetFocus
End If
If Me.Frame16 = 1 Then
Me.salary_edit.Form.RecordSource = "ida salary edit q"
ElseIf Me.Frame16 = 2 Then
Me.salary_edit.Form.RecordSource = "sina salary edit q"
End If
Me.salary_edit.Form.Visible = True
End Sub
i need to stop macro only or run it one time every month