User Functions in queries

  • Thread starter Thread starter Roel
  • Start date Start date
R

Roel

I am using Access in Office XP.

I created a user function in a module. I then referenced that function
in a query. This query is used in a data access page.

The data access page when used independent from the database, will not
recognize the function. Only when you are in the database does it work.

Is there any way for data access pages to recognize user functions
without opening the database?

Thanks!
 
Roel said:
I am using Access in Office XP.

I created a user function in a module. I then referenced that function
in a query. This query is used in a data access page.

The data access page when used independent from the database, will not
recognize the function. Only when you are in the database does it work.

Is there any way for data access pages to recognize user functions
without opening the database?
Click to expand...

Not as far as I'm aware.
 
My guess is that you'll have to re-code your function in VBScript on the DAP.

You'll have better luck with DAP questions in the microsoft.public.access.dataaccess.pages group.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top