access module out of excel vba

[kyle775]

I used to use some vba code i found on the internet to calculate check
digits for upc codes, i want to do this from an access query now, not
in an excel sheet. I just copied the vba from excel into an access
module and tried calling the function in a query. But i get something
about an ambiguous name or something..

did i do this the right way? what is missing here?

 

[Douglas J. Steele]

Sorry, you're not giving enough details.

What's the function you created? What did you name the module in which you
created it?

What's the exact error message you're getting?

(For that matter, it might help to see the actual code of your function)

 

[Guest]

ambiguous name is indicating that you might just have a function there yet
with the same name... But in addition to Douglas' post, hand a little more
info if you need us to take a look at it.

Maurice

 

[dbahooker]

it sounds to me like you pasted it twice or somethign
give us your code, we'll help you figure it out

 

[kyle775]

I used to use some vba code i found on the internet to calculate check
digits for upc codes, i want to do this from an access query now, not
in an excel sheet. I just copied the vba from excel into an access
module and tried calling the function in a query. But i get something
about an ambiguous name or something..

did i do this the right way? what is missing here?

Hello!, i actually figured this out, i had created two modules or
something, any way it works now. I have another problem though, for
another post.