Recent content by baustin

I figured out how to do ":"s! I just wrote a routine to check for colons and wrap them in single quotes. Now I just need to figure out how to trap for all other escape characters. AND.... I currently when I use: CurrentDb.Execute strSql. It does not raise errors. I want to raise and error...

THANK YOU FOR YOUR RESPONSE! wow THAT WAS QUICK! My Array is working fine. The problem is what 'escape characters' in my data. What I think I am going to need is 1. a list of all possible access 'escape characters' so I can create a function that checks for these before each parameter is...

Hello, I am new to this community but would like to get direction on how to insert colons (:) into the database through a vba insert statement. Here is my code sample. I am using an array with a user defined type so I can Redim Perserve the 2 dimensional array. Again the problem is that when...