Search results

Putting spaces at the end of my lines fixed everything!! thank you, can't believe i caused such a blunder... part of the learning process i guess.

Thank you for pointing out the lack of spaces so quickly.... i added in the line breaks (" & _) at the end of each line... So from my original code I could do something like? Private Sub butMoveNDStoBO_Click() On Error GoTo Err_butMoveNDStoBO_Click Dim RecNo As Long Dim SQL As String...

I tried copying the code from the stored procedure into the code for the button and I am getting an error message now. I am running this as an ADP, so I do not know if I will be able to use the suggestion you gave for DAO. Code is: Private Sub butMoveNDStoBO_Click() On Error GoTo...

I am trying to call a stored procedure using DoCmd.RunSQL, but I need to pass a parameter as well. I cannot figure out how to do this. I have coded a variable that will take the input for the parameter, but I do not know how to associate it with my call. Here is the code that I made before I...