User Functions in queries

[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!

 

[Douglas J. Steele]

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?

Not as far as I'm aware.

 

[M.L. Sco Scofield]

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