All Built-in Functions died after I built a macro

[HughHemington]

(Access 2003)
I wanted to chain a slew of queries together and tried it in VBA, then thought of using a Macro since it isn't going to be run in code anyway.

The queries first purge temp files, then assemble status data from an outside data source... been running them for months.

I assembled the macro and ran it. Bam, Splat, Thud! Every call to any built-in function, like RIGHT(), DATE() etc. took a dump!

I de-constructed... trying the functions manually -- same thing. Then wrote new test query that just had a simple function call -- same thing.

Apparently assembling a macro destroys all the built-in functions in Access? Seems a steep price to pay for a little convenience, no?

I tried compacting/repairing, shutting down Access and re-starting, etc.

Anyone know what's up with this?

Thanks,

[HughHemington]

... I figured out that it was the module stub hosing the database. once I deleted my aborted attempt at coding, the functions returned to normal.

[Scott Price]

Glad you got it working! One word on macros: they don't allow error handling. Use them with caution :-)

Regards,
Scott