If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
function error in query (unknown function name)
I use a function in a query to get a date as a parameter. The query works
fine in all the access 2003 clients at a location except one user. That users machine returns error 3072, unknown function name when the query in run. That users access references are the same as the other users (VB for apps, access 11.0 object library, dao 3.6 object library, ole automation, and VB for apps extensibility 5.3). As a test I replaced the function in the query with a hardcoded date and then it works fine. Is there something else I should be checking or should Access 2003 be reinstalled on that machine? Thank you for any thoughts on this error. -- Bruce L |
#2
|
|||
|
|||
You forgot to mention what the function was that gave the problem.
"Bruce L" wrote: I use a function in a query to get a date as a parameter. The query works fine in all the access 2003 clients at a location except one user. That users machine returns error 3072, unknown function name when the query in run. That users access references are the same as the other users (VB for apps, access 11.0 object library, dao 3.6 object library, ole automation, and VB for apps extensibility 5.3). As a test I replaced the function in the query with a hardcoded date and then it works fine. Is there something else I should be checking or should Access 2003 be reinstalled on that machine? Thank you for any thoughts on this error. -- Bruce L |
#3
|
|||
|
|||
Sorry about leaving out the function info.
Function GetgdtmFromDate() ' gdtmFromDate is a global date GetgdtmFromDate = gdtmFromDate End Function The criteria in the query is: Between GetgdtmFromDate() And GetgdtmToDate() -- Bruce L "KARL DEWEY" wrote: You forgot to mention what the function was that gave the problem. "Bruce L" wrote: I use a function in a query to get a date as a parameter. The query works fine in all the access 2003 clients at a location except one user. That users machine returns error 3072, unknown function name when the query in run. That users access references are the same as the other users (VB for apps, access 11.0 object library, dao 3.6 object library, ole automation, and VB for apps extensibility 5.3). As a test I replaced the function in the query with a hardcoded date and then it works fine. Is there something else I should be checking or should Access 2003 be reinstalled on that machine? Thank you for any thoughts on this error. -- Bruce L |
#4
|
|||
|
|||
I am not the one to help you with this but it looks odd that you have () at
the end in two places but not in the third. "Bruce L" wrote: Sorry about leaving out the function info. Function GetgdtmFromDate() ============== HERE ' gdtmFromDate is a global date GetgdtmFromDate = gdtmFromDate ====== NOT HERE End Function The criteria in the query is: Between GetgdtmFromDate() And GetgdtmToDate() ====== HERE -- Bruce L "KARL DEWEY" wrote: You forgot to mention what the function was that gave the problem. "Bruce L" wrote: I use a function in a query to get a date as a parameter. The query works fine in all the access 2003 clients at a location except one user. That users machine returns error 3072, unknown function name when the query in run. That users access references are the same as the other users (VB for apps, access 11.0 object library, dao 3.6 object library, ole automation, and VB for apps extensibility 5.3). As a test I replaced the function in the query with a hardcoded date and then it works fine. Is there something else I should be checking or should Access 2003 be reinstalled on that machine? Thank you for any thoughts on this error. -- Bruce L |
#5
|
|||
|
|||
The function itself is correct and the query that uses it as criteria returns
the correct info for all of the access 2003 users except one. -- Bruce L "KARL DEWEY" wrote: I am not the one to help you with this but it looks odd that you have () at the end in two places but not in the third. "Bruce L" wrote: Sorry about leaving out the function info. Function GetgdtmFromDate() ============== HERE ' gdtmFromDate is a global date GetgdtmFromDate = gdtmFromDate ====== NOT HERE End Function The criteria in the query is: Between GetgdtmFromDate() And GetgdtmToDate() ====== HERE -- Bruce L "KARL DEWEY" wrote: You forgot to mention what the function was that gave the problem. "Bruce L" wrote: I use a function in a query to get a date as a parameter. The query works fine in all the access 2003 clients at a location except one user. That users machine returns error 3072, unknown function name when the query in run. That users access references are the same as the other users (VB for apps, access 11.0 object library, dao 3.6 object library, ole automation, and VB for apps extensibility 5.3). As a test I replaced the function in the query with a hardcoded date and then it works fine. Is there something else I should be checking or should Access 2003 be reinstalled on that machine? Thank you for any thoughts on this error. -- Bruce L |
#6
|
|||
|
|||
I would still suspect that you have a (library) reference problem.
On the computer with the problem, have you tried deselecting a reference and then adding it back in. When this happens, you need to take steps to let Access repair the broken reference(s) ON THE COMPUTER WHERE THE FAILURE IS OCCURING. Here are MVP Doug Steele's instructions for how to do it: *** Quote *** Any time functions that previously worked suddenly don't, the first thing to suspect is a references problem. This can be caused by differences in either the location or file version of certain files between the machine where the application was developed, and where it's being run (or the file missing completely from the target machine). Such differences are common when new software is installed. On the machine(s) where it's not working, open any code module (or open the Debug Window, using Ctrl-G, provided you haven't selected the "keep debug window on top" option). Select Tools | References from the menu bar. Examine all of the selected references. If any of the selected references have "MISSING:" in front of them, unselect them, and back out of the dialog. If you really need the reference(s) you just unselected (you can tell by doing a Compile All Modules), go back in and reselect them. If none have "MISSING:", select an additional reference at random, back out of the dialog, then go back in and unselect the reference you just added. If that doesn't solve the problem, try to unselect as many of the selected references as you can (Access may not let you unselect them all), back out of the dialog, then go back in and reselect the references you just unselected. (NOTE: write down what the references are before you delete them, because they'll be in a different order when you go back in) For far more than you could ever want to know about this problem, check out http://www.accessmvp.com/djsteele/Ac...nceErrors.html Just so you know: the problem will occur even if the library that contains the specific function that's failing doesn't have a problem. **** End Quote **** So, follow those instructions and see if your problem goes away. Check out the following reference http://www.trigeminal.com/usenet/usenet026.asp?1036 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unknown function name in query expression | Larry | Running & Setting Up Queries | 9 | January 25th, 2005 10:39 PM |
AVG Function in a Query | JohnL | Running & Setting Up Queries | 5 | December 18th, 2004 05:52 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM |