Hello I am new to VBA programming. I get run-time error '13' type mismatch in my VBA macro. My code is below. now the funny thing is if I delete "StartInsTime" my code runs, but if I include it i get the runtime error. Any clues on how to resolve this? I am thinking it is a character length issue but I am not sure. Let me knwo. Thanks!
Please Login or Register to view this content.
the elements of the array can only have 255 characters. you don't need the array at all-just build the sql string up as one string and pass that.
Josie
if at first you don't succeed try doing it the way your wife told you to
thanks joseph.could u expand on your answer a little? when u say i dont need the array, what should i use instead? sorry for my ignorance!Originally Posted by JosephP
basically. note there's not much point to an IN clause with only one item-you can just use = '8135' insteadPlease Login or Register to view this content.
wow. that easy huh! I will give a try this weekend and let you know how it went. Thanks for your input!
Hey Joseph, finally got to try the code and it worked like a charm! thanks for your help buddy!
you're welcome :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks