problem with saving record that the name contain '

[basilyos]

hello Guys

when i save my record everything is okay

but if the name of the movie contain ' i can't save it

how to let the vba accept " in my movies name

this is my code

strsql101 = "insert into tbl_videos (video_name, video_genre, video_duration, video_size, video_date, video_language, video_type, video_series, video_status) Values ('" & Me.video_name & "','" & Me.video_genre & "','" & Me.video_duration & "','" & Me.video_size & "','" & Me.video_date & "','" & Me.video_language & "','" & Me.video_type & "','" & Me.video_series & "','" & Me.video_status & "')"

 

[Uncle Gizmo]

It's basically what is commonly referred to as an SQL injection attack there was a good thread on it recently here:-

http://www.access-programmers.co.uk/forums/showthread.php?t=268028