You have to be careful with Access as it has Macros and VBA and they are not the same thing.
Unfortunately I do not know how to add Access VBA to a QAT, it is normal for it to be applied to an Access object on a form or report or called from a Module.