I have the same question Report abuse. Details required :. Cancel Submit. Tom van Stiphout MVP. Be sure to fully qualify all function calls, like VBA. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Tom van Stiphout's post on October 14, Anything else you can suggest? In reply to mwwbutler's post on October 14, In reply to Tom van Stiphout's post on October 15, Tom thanks for your help.
Thanks in advance! This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
I have the same question Report abuse. Details required :. Cancel Submit. Previous Next. Hi There, Sounds like you probably need to add your database to a trusted location. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Steve Schapel.
OldeDawg, The yellow triangles indicate actions that will not work unless the database is in a Trusted Location. In reply to Steve Schapel's post on May 14, The last 2 macros are tied to the OK and Cancel button controls on the form. Msny thanks, OldeDawg. In reply to OldeDawg's post on May 14, I can only assume I'm doing something wrong, but Wanted to update you on this.
OldeDawg, I feel sure the problem is related to: "Not[IsLoaded] formname " Do you mean this is literally what you have entered in the Condition for this macro action? Steve, several answers: The code module I think returns a True or False depending on whether the form is loaded with the database. Shashvat Gupta. That should find the line of code causing the error. The error message is clear. You may have a mispelled function name or used a function that was removed.
Details required : characters remaining Cancel Submit. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Thanks for your reply Scottgem.
We havent tried compiling the app. What is strange is that, the application works fine and fails only during specific times of the day ie. I cannot seem to get it. I have tried many different variables in trying to write the expression but to no avail. Please, Please tell me where I'm going wrong. I have read up and looked at examples of concatenating multiple rows into one, but I receive the error message " Undefined function in 'Conc' expression when I try to run the query.
InvoiceNo; Please can someone put me out of my misery? I'm trying to help someone with some text functions in Access, and I have used the Replace function to strip out spaces in a postcode. I created a dummy database in Access but in format since she is still on Access However, she is getting the above message. Incidentally, I don't get the message when I run it in Access She has checked her references and has no missing ones. Does anyone have any ideas? Many thanks. Hello first time poster : My boss recently moved a DB from one server location to another and now it is no longer working properly.
Please bare with me, I am not very knowledgable of Access and am primarily an oopl coder. I am using Access 97 in an XP. A prompt appears where i can enter a user name and login but when I click ok it crashes about 1 minute later with the 'Undefined function 'BuildCustomerName' in expression' error. However, even if they were incorrect I cant figure out how to change them with my current resources.
Any help in this matter would be greatly appreciated as would tips on how to step code cause I havent been able to figure that out either. Thank you. I have got a problem on one of our computers. We use Microsoft Access databases to enter test data and eventually generate reports.
On 1 computers i get the following error when opening the report: "Function is not available in expressions in query expression 'Left It turns out it is the Microsoft DAO 3.
0コメント