Compile error using the Replace in the Codescan DB

[Shimon]

Here is the code I'm using

Dim sOriginal As String
Dim sNew As String
Dim log As String

sOriginal = "tblMember"
sNew = "tblMemberUS"
String_In_Queries_Alter (sOriginal, sNew)

The module is from the codescan DB I got off Allen's site (I think).

Any help would be appreciated,
Shimon

 

[Chris O'C via AccessMonster.com]

Remove the parentheses in the function call. The line of code should now
look like this:

String_In_Queries_Alter sOriginal, sNew

Save and compile again. If you're still getting compile errors, I don't see
String_In_Queries_Alter defined here. Did you paste it into the same module
as your other code here or did you paste it into a standard module and make
sure it's public?

This looks like an easy problem to solve, but I think you didn't get any help
yesterday because you didn't post the compile error message (making us guess
what your problem is), and you're blindly copying code without knowing what
it does or how to use it. Many people are reluctant to give help when it's
decided that help will fall on deaf ears. If you want to get help faster
here in the future, I'd advise reading Access's built in help or a book on
Access. Your future posts will show any vba assistance will be put to good
use, instead of showing somebody who's never coded before and won't read an
instruction manual to learn how. I know this sounds like I'm criticizing you,
but I think you'd rather know the unwritten rules on how to get help fast
when you're starting out.

Chris
Microsoft MVP