access module out of excel vba

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kyle775 - 16 May 2007 19:04 GMT

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?

Reply to this Message

Douglas J. Steele - 16 May 2007 19:14 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 3 lines]
>
> did i do this the right way? what is missing here?

Reply to this Message

Maurice - 16 May 2007 20:27 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> did i do this the right way? what is missing here?

Reply to this Message

dbahooker@hotmail.com - 17 May 2007 00:54 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> did i do this the right way? what is missing here?

Reply to this Message

kyle775 - 18 May 2007 14:43 GMT

> 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
[quoted text clipped - 3 lines]
>
> 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.

Reply to this Message