By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,037 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,037 IT Pros & Developers. It's quick & easy.

Scope of a function (in a module)

P: 2

I'm having a problem related (I believe) with the scope of a function.

I wrote in Access 2003 the module A. It contains
Public Function B(ByVal s As String) As String
This function returns strings based on strings.

I got also a query Q1 that is basically
Select s, B(s) from Table

The query works well inside Access, but called from my VB.NET (express edition, 2005) program I receive the answer:
Undefined function B in expression.

Do you know what do I need to change?

Thanks in advance

Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply

Scott Price
Expert 100+
P: 1,384
You'll have to declare the function inside your VB.NET program to reference it from within your VB.NET program...

Can't help on that part, sorry! I'm not a .NET guy (at least not yet :-)

Sep 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.