I have VB code behind a form that uses the Execute method to run a query:
db.Execute "qryAppendMovement"
Within that query I reference a user-defined function named GTIN2UPC that I wrote.
In one database the code executes perfectly. I put the form, the query and the function into a second database and now, every time I run the code I get an error:
Undefined function 'GTIN2UPC' in expression.
What am I missing?
Cruising the Information Superhighway at the speed of light
[sub] (your mileage may vary)[/sub]
db.Execute "qryAppendMovement"
Within that query I reference a user-defined function named GTIN2UPC that I wrote.
In one database the code executes perfectly. I put the form, the query and the function into a second database and now, every time I run the code I get an error:
Undefined function 'GTIN2UPC' in expression.
What am I missing?
Cruising the Information Superhighway at the speed of light
[sub] (your mileage may vary)[/sub]