View Full Version : lost ability to "shell" out when database moved


John Jasper
01-16-2007, 11:56 AM
Hi,
I had to build a new intranet machine a while ago and just found out that at the end of my macros, I get the error: "The expression you entered has a function MS Office Access can't find" -- I believe it is related to the "run code" macro which simply does this: shell("c:\runtest.bat") --- It looks like I can't run anything with the "shell" command - as if the "shell" command doesn't exist in Access anymore ?? What has happened?

Thanks

John

boblarson
01-17-2007, 03:51 PM
Check your References. See if there are any missing. If not, it may still be the COMCTL32.ocx problem that I go into here:
http://www.access-programmers.co.uk/forums/showthread.php?t=20641&highlight=COMCTL32.ocx

John Jasper
01-19-2007, 09:09 AM
Thee were no missing references and the closes thing to COMCTL32.ocx was
mscomctl.ocx so I added that with no luck. seems like there must be one reference tht specifically allows "shell" command.