• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

How to run a self-write function in an access query?

Dear all experts,

I write a function in access and place it in module, let say:

fx_ReturnNumber (strTemp as string) as string
  Dim strTemp2 as string

  strTemp2 = strTemp & " -  Hello World"
 
  fx_ReturnNumber = strTemp2
End Function

If I can bind about function to my query, the result of the query will look like that

ABC - Hello World
CDE - Hello World
EEF - Hello World
...
..
..
..
XZX - Hello World

I've some query and want to use this function but I cannot include it, does anyone tell me how to accomplish this?  Thanks in advance.
0
towo2002
Asked:
towo2002
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
I'm not sure what you mean when you say "I've some query and want to use this function but I cannot include it". Do you mean that you get an error? To use a custom function in a query you do it this way:

CustomFunctionName([fieldname])
0
 
towo2002Author Commented:
Sorry, I go it.  Thanks.
0
 
Martin LissRetired ProgrammerCommented:
Glad I could help.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now