Macro Single Step Error

[cfspartan]

I'm attempting to use the cumbersome and obnoxious UPS Billing Analysis Tool v 2.07.2012 and every time I attempt to open it, I get an error:

Macro Name: AutoExec
Action Name: RunCode
Error Number: 7960
Arguments: IIf (CheckStartUpItems (), CheckRegistration (), CloseMe () )



I have to Stop All Macros in order to continue, which renders the tool inert.

Anyone have any idea what to do?

I've tried searching for the argument string in the project, but can't find it. I'm even having a hard time finding the "RunCode" action in seaching the Project inside Visual Basic editor. Sadly, I am forced to use this awfully designed mess, so any help would be immensely appreciated!

[rzw0wr]

7960 There was an error compiling this function.@The Visual Basic module contains a syntax error.@Check the code, and then recompile it.

Instructions also suggested to compact/repair db.

Dale

[cfspartan]

7960 There was an error compiling this function.@The Visual Basic module contains a syntax error.@Check the code, and then recompile it.

Instructions also suggested to compact/repair db.

Dale

I've tried searching the code for the function string to no avail. I can't even find the Module. Could they have shut editing off of these features?

[rzw0wr]

Is the database an accdb format. Or accde.

Sounds like a macro. This should appear under you nav screen at the bottom.
Name should be Autoexec.

Dale

[cfspartan]

Thanks Dale. It's an MDB file. The home screen is blank with most things grayed out. The ribbon has Create, External Data, and Database Tools. In tools under VB, there are forms, reports, modules, and one class module however nowhere can I find Macros. I can choose to Run macros, but can't seem to find a place for editing them.

[rzw0wr]

Did you write this database?
Try pressing button F11 to see the nav. screen.

Dale

[Mohanss82]

Hi. I am getting this error msg again. Please help.