Most Recommended Resources
These are some of our favorite tools or downloads that will be helpful. Some of them are FREE and some are paid.
Disclosure: Some of the links are affiliate links, and at no additional cost to you we will earn a small commission if you decide to make a purchase. We recommend you only purchase these products if you believe they will help you achieve your specific goals.
RECOMMENDED WEB HOSTING PROVIDERS:
MySQL:
- MySQL Workbench Download
- MySQL Server Download
- MySQL Connector/ODBC 8.0 Download (note: Virtual Form control is a 32-bit application, so you need to install the 32-bit version of the MySQL driver. If you have 64-bit Office version you need to install both 32-bit & 64-bit versions of the MySQL driver so that Virtual Form control (32-bit) & VBA (64-bit) can connect to MySQL)
1 2 3 4 |
' Connection string sample for MySQL Connector/ODBC 8.0: ConnectionString = "DRIVER={MySQL ODBC 8.0 Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;" |
- MySQL Connector/ODBC 5.3 Download
- (note: Virtual Form control is a 32-bit application, so you need to install the 32-bit version of the MySQL driver. If you have 64-bit Office version you need to install both 32-bit & 64-bit versions of the MySQL driver so that Virtual Form control (32-bit) & VBA (64-bit) can connect to MySQL)
1 2 3 4 |
' Connection string sample for MySQL Connector/ODBC 5.3 (should work also with MySQL Server 8.0): ConnectionString = "DRIVER={MySQL ODBC 5.3 Unicode Driver};Port=3306;SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=mypass;OPTION=3;" |
Some Featured Excel Links:
Vertex42.com – Vertex 42 is mostly focused upon different Excel-templates, Excel calendars, Gantt Charts, personal budgets and debt reduction calculators. Jon Wittwer is the men behind this gigantic source of Excel templates. On Vertex 42 you can also find a lot of good tutorials, guides and articles about Excel.