Turn off Access Validation Msgbox /Error in insert

[LetterFrack]

Hi ,

Anyone know how to get rid of the access generated validation rule message

" Cant append all records in the append query".

I have turned off the confirm messages (tool/options/edit-find).

I understand what the message means and why its there , but its not needed in the app.

Also I am getting the Runtime error 3075 when I insert a new row into a table from an access form. Its due to a comma in a surname ie O'Neill. I am adding variables so the commas in ' " & SurName & "' are getting mixed up. How do I get around this problem ?

Any ideas are much appreciatd

 

[Mile-O]

I have turned off the confirm messages (tool/options/edit-find).

Turn them back on. It's not advised to turn them off as they are important. When performing a task on tables you can use the DoCmd.SetWarnings False method to turn them off and substitutin True for False when you have finished the task in code to turn them back on again.

I am getting the Runtime error 3075 when I insert a new row into a table from an access form. Its due to a comma in a surname ie O'Neill. I am adding variables so the commas in ' " & SurName & "' are getting mixed up. How do I get around this problem ?

Substitute the ' for ""

i.e.

""" & SurName & """

 

[LetterFrack]

Thanks

Cheers SJ

Both your suggestions work fully.

Many thanks