 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2005Form - Macro - Function
Hi I have a database that I created and have used for some time. There have been no changes to it in months except the addition of data. The form on opening invokes a macro, that calls a function. Everything has been fine until now. It says the Macro failed, and all I can press is the HALT button; after this a window appears - "Runtime Error 2425 The expression you entered has a function name that Microsoft Office Access can't find." In fact the function is there, the syntax is correct and nothing has changed. I have compacted and repaired, but that has not made it work. Any ideas would be appreciated please. Thank you in Anticipation Centaur The problem may be inside the function. Set a breakpoint at the function's definition, and see if execution gets there. If it does, step through the code until you find the problem line. > Hi > [quoted text clipped - 15 lines] > > Centaur Hi It does not get as far as that - it does not see that the function exists. I have set a break out before the first statement. The Macro says true. (set under RunCode) then a window appears - "Runtime Error 2425 The expression you entered has a function name that Microsoft Office Access can't find." There are no syntax errors, as far as I can see. As I said it was working fine, and now it doesn't, and no changes have been made to the code, and that is what I am finding confusing. Thanks for your help Centaur > The problem may be inside the function. > Set a breakpoint at the function's definition, and see if execution gets [quoted text clipped - 21 lines] > > > > Centaur Just got it sorted Apparently security settings have to be set to low to allow the macros to work. Not sur how to get the macros to work on a higher security setting. Centaur > Hi > [quoted text clipped - 40 lines] > > > > > > Centaur |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.