Can I create a VBA module that accepts a form? What resource can I use to understand how I can use an SQL database file as the VBA module form, execute changing the initial values recieved, then have the module update the file and return it to the database. Specifically how to assign specific parts of SQL tables to specific variables within the
VB module. Also Id like to know how the module can run automatically on its own, probably meaning it might be on a sever of its own running on a fixed schedule. Any any answern, in any direction would be helpful especialy considering Im stuck. Thanks
VB and Access
