PDA

View Full Version : Solved: Run Access Macro without Reference



akn112
04-22-2008, 11:45 AM
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
04-22-2008, 12:19 PM
Late bind to Access?

akn112
04-22-2008, 01:05 PM
but even with late binding don't i need the docmd.runmacro statement?

Bob Phillips
04-22-2008, 01:46 PM
Yes, but that is not setting a reference.

akn112
04-23-2008, 08:23 AM
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
04-23-2008, 08:25 AM
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
04-24-2008, 10:56 AM
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
04-24-2008, 11:00 AM
Then no chance, you cannot use part of Access if you don't have Access.