Vba access passing the table name with variables (1 Viewer)

[The_Doc_Man]

a VBA function built into the query will not run. ACE does not know the VBA functions, because in such a case the expression services will not run (no Access instance is running).
@Experts: please correct if I am wrong here.

Josef, I don't think you are wrong in your assessment - UNLESS the user has another program that is capable of running VBA. (For instance, the Reflection terminal emulator from Micro-Focus used to be able to run event-based VBA.) Since VBA is emulated via some kind of subroutine call from a compiled main program, you have to have something that can take advantages of the "hooks" that are exposed. You can't run it stand-alone.

VBA is now separate from Access (no longer an intrinsic part) because every major and some minor Office components can run it ... and it is the same VBA library instance if two elements of Office are running. We determined that by accident some time ago when another question revealed that if you have font settings (say, for better accessibility/visibility) and adjust VBA font characteristics from Access, the code pages visible from Excel also exhibit the same font changes.