gold007eye
Registered User.
- Local time
- Today, 09:26
- Joined
- May 11, 2005
- Messages
- 260
I am in the process of converting my DB into SQL. What I can't understand is why since doing so is my custom error message putting a bunch of unwanted spaces in the message? (See attached image)
Here is the code I am using. This was working fine until the tables were moved to a SQL backend
Is there something I need to do differently?
Here is the code I am using. This was working fine until the tables were moved to a SQL backend

Code:
Select Case MsgBox("Are you sure you want to remove the associate " & [Employee Name] & " from the list?", vbYesNo + vbQuestion, "Remove the Associate " & [Employee Name] & "?")
Case vbYes: 'Delete the record
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True
MsgBox "This associate has been removed from the list" & vbCrLf & vbCrLf & "Click OK to continue...", vbCritical, "Associate Removed!"
Case vbNo: 'Do NOT delte the record
DoCmd.CancelEvent
MsgBox "Associate Removal Cancelled!", vbInformation, "Associate Removal Cancelled!"
Case Else: 'Trap any other errors that could occur
'Do Nothing
End Select
'Code End