|
| |
|
|
huntress
Posts: 6
From: IL
Status: offline
 |
Undefined function 'NumberOfDays' in expression - 1/13/2002 15:08:23
Hi guys!
I've create a series of queries in my Access Database, with a final query which I want to use in the Results Wizard to create an output page.
One of the queries uses a user-defined function (NumberOfDays) I wrote. All of the queries work perfectly when executed within the Access 2000 db.
But when I run the wizard in Frontpage 2000, I get the following error:
Server error: Unable to retrieve schema information from the record source 'scores' in a database using the connection string:
'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/snitz_forums_2000.mdb'.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'NumberOfDays' in expression.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
Any help would be appreciated.
Thanks
Diana
|
|
|
|
huntress
Posts: 6
From: IL
Status: offline
|
RE: Undefined function 'NumberOfDays' in expression - 1/13/2002 20:23:18
Okay... found my own answer, not what I wanted, but I guess that figures.
You can't call Access functions from outside of Access, as Jet doesn't recongnise VBA.
Diana
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
