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
|
|||
|
|||
Error at Runtime (Function not available in querie expressions)
I have an access program that is packaged and distributed on a network in my
office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#2
|
|||
|
|||
Error at Runtime (Function not available in querie expressions)
It is more likely some of the computers do not have some necessary references
set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#3
|
|||
|
|||
Error at Runtime (Function not available in querie expressions
Thanks Klatuu,
This happens on computers that only have the Access Runtime installed. How do I determine what is missing in this case? as I can't open the full access? Gerry "Klatuu" wrote: It is more likely some of the computers do not have some necessary references set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#4
|
|||
|
|||
Error at Runtime (Function not available in querie expressions
What commands are failing? It may be you are doing something that is not
allowed in RunTime. I don't have a list of those, but there are some. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: Thanks Klatuu, This happens on computers that only have the Access Runtime installed. How do I determine what is missing in this case? as I can't open the full access? Gerry "Klatuu" wrote: It is more likely some of the computers do not have some necessary references set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#5
|
|||
|
|||
Error at Runtime (Function not available in querie expressions
It looks like it is mostly the Mid function that is failing.
Gerry "Klatuu" wrote: What commands are failing? It may be you are doing something that is not allowed in RunTime. I don't have a list of those, but there are some. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: Thanks Klatuu, This happens on computers that only have the Access Runtime installed. How do I determine what is missing in this case? as I can't open the full access? Gerry "Klatuu" wrote: It is more likely some of the computers do not have some necessary references set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#6
|
|||
|
|||
Error at Runtime (Function not available in querie expressions
Very strange. I have no idea what would cause one function that lives with
other functions to fail in runtime. Did you get a clean compile before you deployed the application? You should always be sure of that. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: It looks like it is mostly the Mid function that is failing. Gerry "Klatuu" wrote: What commands are failing? It may be you are doing something that is not allowed in RunTime. I don't have a list of those, but there are some. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: Thanks Klatuu, This happens on computers that only have the Access Runtime installed. How do I determine what is missing in this case? as I can't open the full access? Gerry "Klatuu" wrote: It is more likely some of the computers do not have some necessary references set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
#7
|
|||
|
|||
Error at Runtime (Function not available in querie expressions
As far as I know, the compile was clean. There was nothing that would
indicate otherwise. What would be the ways to know if the compile was not clean? Thanks much! "Klatuu" wrote: Very strange. I have no idea what would cause one function that lives with other functions to fail in runtime. Did you get a clean compile before you deployed the application? You should always be sure of that. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: It looks like it is mostly the Mid function that is failing. Gerry "Klatuu" wrote: What commands are failing? It may be you are doing something that is not allowed in RunTime. I don't have a list of those, but there are some. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: Thanks Klatuu, This happens on computers that only have the Access Runtime installed. How do I determine what is missing in this case? as I can't open the full access? Gerry "Klatuu" wrote: It is more likely some of the computers do not have some necessary references set. Open the VBA editor on a machine where it all works and look at Tools - References. Record all the references that are checked. The do the same on a machine where it does not work. You will likely find there are some not checked or could be marked as "missing". If one is not checked, check it. If it says Missing, try to locate the file it references. If it can't be found, it needs to be installed. I have seen instances in a corporate environment where a consistent install was not done and some files were missing. In this case, it is best to reinstall Access. -- Dave Hargis, Microsoft Access MVP "Gerry" wrote: I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a message "Function is not available in expressions in Queries". I am guessing that maybe this is something to do with security but I can not figure it out. The packaged product includes the Access Runtime. Can somebody make any suggestions? |
Thread Tools | |
Display Modes | |
|
|