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
|
|||
|
|||
2003 upgrade and globals w/user defined functions
I recently converted my Access 97 application to Access
2003. I have code in my application that uses user defined functions for query criteria. For example, I have a global gblCustomerID and I have a user defined function named GetCustomerID. The function looks like this: Function GetCustomerID() getcustomerid = gblCustomerID End Function Then, in my queries, I have getCustomerID()for the criteria on which customer record to pull up. Now that I have converted to 2003, these user defined functions can take up to 5 MINUTES to execute - Access simply stops responding for awhile and then comes back. Does anyone know why this would happen? |
Thread Tools | |
Display Modes | |
|
|