i want to stop macro in vba at access program. how i can do it??

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I put this macro on a EXCEL sheet? 1
Want to avoid the possibilty to edit field in listbox 6
How to modify a Word macro written for Windows so that will work on MAC 0
Moved Program to Access 2007 PC and it will not work 1
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1
Macro VBA coding, Copying content from one workbook to a new one 0
how to stop search in the middle 2
Predecessor dependency in MS Project 2007 Emailing Macro 1

Top