I'm looking to create and load a sql query upon page load using VBA on Access 2007. The query is a very simple query:
Where TB1.CIF = '5000000'
Is this doable and if so, can someone please help me by giving me a pseudo code?
Your help is greatly appreciated.