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 is not available in...
Dear all
I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
#2
|
|||
|
|||
You probably have a missing reference on the other PC. Open any code module
and look at Tools|References while on that PC....note any references that are listed as MISSING. Determine whether or not the reference is actually needed...i.e., remove it and try to compile your app. If it is indeed needed, you may need to include it as part of your installer or consider another option like late binding. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
#3
|
|||
|
|||
Thanks for getting back to me Paul
I wondered if that might have been the case and had checked for Missing references but they seem to be ok. "Paul Overway" wrote: You probably have a missing reference on the other PC. Open any code module and look at Tools|References while on that PC....note any references that are listed as MISSING. Determine whether or not the reference is actually needed...i.e., remove it and try to compile your app. If it is indeed needed, you may need to include it as part of your installer or consider another option like late binding. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
#4
|
|||
|
|||
Hmmm...in that case, I'd try importing everything to a new mdb and see if
you still get the same message. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Thanks for getting back to me Paul I wondered if that might have been the case and had checked for Missing references but they seem to be ok. "Paul Overway" wrote: You probably have a missing reference on the other PC. Open any code module and look at Tools|References while on that PC....note any references that are listed as MISSING. Determine whether or not the reference is actually needed...i.e., remove it and try to compile your app. If it is indeed needed, you may need to include it as part of your installer or consider another option like late binding. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
#5
|
|||
|
|||
That seems to have done the trick - thanks very much Paul - any ideas on what
would cause this or is it just that the original file became corrupt? Andy "Paul Overway" wrote: Hmmm...in that case, I'd try importing everything to a new mdb and see if you still get the same message. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Thanks for getting back to me Paul I wondered if that might have been the case and had checked for Missing references but they seem to be ok. "Paul Overway" wrote: You probably have a missing reference on the other PC. Open any code module and look at Tools|References while on that PC....note any references that are listed as MISSING. Determine whether or not the reference is actually needed...i.e., remove it and try to compile your app. If it is indeed needed, you may need to include it as part of your installer or consider another option like late binding. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
#6
|
|||
|
|||
Yes, it would appear there was some corruption...although it apparently
wasn't discovered by Jet. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... That seems to have done the trick - thanks very much Paul - any ideas on what would cause this or is it just that the original file became corrupt? Andy "Paul Overway" wrote: Hmmm...in that case, I'd try importing everything to a new mdb and see if you still get the same message. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Thanks for getting back to me Paul I wondered if that might have been the case and had checked for Missing references but they seem to be ok. "Paul Overway" wrote: You probably have a missing reference on the other PC. Open any code module and look at Tools|References while on that PC....note any references that are listed as MISSING. Determine whether or not the reference is actually needed...i.e., remove it and try to compile your app. If it is indeed needed, you may need to include it as part of your installer or consider another option like late binding. -- Paul Overway Logico Solutions http://www.logico-solutions.com "Andy" wrote in message ... Dear all I am getting the following bizarre error message on one of our databases: 'Function is not available in expressions in table-level validation epression' The database has not been split and works absoloutely fine on my machine but when it is run from another users machine this message occurs when they try and do stuff. All of our machines should be the same as they are installed from the same image. They run Win XP Pro and Access 2002. I traced it back to one of the tables where I have made the default value 'Date()'. If I change this to a constant value eg '08/04/2005' then it is fine. However if I then change it back to 'Date()' when I try and save the table I get the error message again. Thanks in advance for any help... Andy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Embedded Application Icon | Irshad Alam | General Discussion | 5 | April 5th, 2005 02:16 PM |
Need a ISWorkday Function -- Any Ideas | Mark | Worksheet Functions | 5 | March 29th, 2005 01:58 AM |
loop for replace function | luzippu | Running & Setting Up Queries | 2 | March 24th, 2005 10:13 AM |
What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |
Nesting Address function within Index function | mserber | General Discussion | 3 | November 5th, 2004 02:01 AM |