removing prompt msgs

[donnie051280]

when i save information from a form to a table.. 2 prompt msgs occurs..
Is the anyway i can just save the data from the form without the prompts

thanks

 

[solo7]

not too sure what you are saying her but I'll assume you are getting a warning that you 'Are about to append 2 records'. If so then try this:-

docmd.setwarnings false
docmd.runsql << your SQL string here >>
docmd.setwarnings true

solo7

 

[donnie051280]

i actually have a button on the form which runs a macro
the code is

Private Sub Command29_Click()
On Error GoTo Err_Command29_Click

Dim stDocName As String

stDocName = "save transfer"
DoCmd.OpenQuery stDocName, acNormal, acEdit


Exit_Command29_Click:
Exit Sub

Err_Command29_Click:
MsgBox Err.DESCRIPTION
Resume Exit_Command29_Click

End Sub

 

[RezaNana]

So you want the code to run without propmting the msg huh? Paste this code:
Private Sub Command29_Click()


Dim stDocName As String

stDocName = "save transfer"
DoCmd.OpenQuery stDocName, acNormal, acEdit


Exit_Command29_Click:
Exit Sub




End Sub

 

[TheAceMan1]

How are ya donnie051280 . . . . .

To permanently remove: Click MenuBar-Tools-Options-Edit/Find Tab. In the [blue]Confirm[/blue] section remove check from [blue]Record changes[/blue].

See Ya! . . . . . .