Solved: Run Access Macro without Reference

[akn112]

Was just wondering if there's any way to run an Access macro without having the "Access Objects blah blah" reference installed? Thanks!

[Bob Phillips]

Late bind to Access?

[akn112]

but even with late binding don't i need the docmd.runmacro statement?

[Bob Phillips]

Yes, but that is not setting a reference.

[akn112]

i thought the docmd function call was within the Access Objects 11.0 and unusable unless set? I'll give it a try though. Thanks for the tips

[Bob Phillips]

Late binding will connect to the type library, so you still have access to the commands, you just don't set a reference.

Are you perhaps saying there is no Access on the machine, hence no library?

[akn112]

Late binding will connect to the type library, so you still have access to the commands, you just don't set a reference.

Are you perhaps saying there is no Access on the machine, hence no library?

bingo! haha Shoulda mentioned that

[Bob Phillips]

Then no chance, you cannot use part of Access if you don't have Access.