By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

All Built-in Functions died after I built a macro

P: 3
(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,
Sep 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 3
... 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.
Sep 10 '07 #2

Scott Price
Expert 100+
P: 1,384
Glad you got it working! One word on macros: they don't allow error handling. Use them with caution :-)

Regards,
Scott
Sep 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.