Create Excel apps with MySQL & Virtual Forms & Excel VBA

File Name

Size

4. Creating a menu Userform in Excel VBA/3. Quiz Creating a menu Userform in Excel VBA.html

163 B

3. Starting with Virtual Forms & Microsoft Excel VBA/4. Quiz Starting with Virtual Forms & Microsoft Excel VBA.html

163 B

2. Setup your database/4. Quiz Setup your database.html

163 B

9. Search for MySQL Database hosting/1. Section Introduction.vtt

577 B

14. Creating Customers table and Virtual Form/1.1 tblcustomers.zip.zip

592 B

11. Setting up MySQL server and database on a shared hosting/1. Section Introduction.vtt

676 B

16. Virtual Foms Edit control design change/5. Edit control responsive design after repositioning of Textboxes.vtt

885 B

4. Creating a menu Userform in Excel VBA/1. Excel Developer Tab.vtt

1.0 kB

19. This is not the END/1. See us in the next lesson.vtt

1.1 kB

16. Virtual Foms Edit control design change/4. Edit control change the Tab order of Textboxes 1.vtt

1.1 kB

2. Setup your database/1. Why MySQL as a database.vtt

1.1 kB

15. Virtual Foms Grid control design change/2. Grid control change the width of columns.vtt

1.2 kB

15. Virtual Foms Grid control design change/4. Grid control hide column.vtt

1.2 kB

15. Virtual Foms Grid control design change/5. Grid control change the Alignment of the grid column.vtt

1.2 kB

10. Passive income through a web hosting affiliate program/1. Section Introduction.vtt

1.3 kB

15. Virtual Foms Grid control design change/3. Grid control initial sort field.vtt

1.3 kB

17. MySQL Data Export & Import/2.1 MySharedDatabaseDataandSchemaNoSchema.zip.zip

1.4 kB

16. Virtual Foms Edit control design change/6. Edit control reset the positions of Textboxes.vtt

1.4 kB

17. MySQL Data Export & Import/1.1 MySharedDatabaseDataandSchema.zip.zip

1.5 kB

5. Adding first few lines of Excel VBA code/4. A quick answer to our connection string challenge.vtt

1.6 kB

5. Adding first few lines of Excel VBA code/1. Adding a reference to the Virtual Form control in Excel VBA.vtt

1.7 kB

16. Virtual Foms Edit control design change/1. Virtual Forms partially responsive design.vtt

1.7 kB

15. Virtual Foms Grid control design change/1. Grid control change the order of columns.vtt

1.9 kB

2. Setup your database/7. Create a Model from MySQL Database (Reverse Engineer).vtt

2.1 kB

16. Virtual Foms Edit control design change/2. Edit control change the Tab order of Textboxes.vtt

2.3 kB

3. Starting with Virtual Forms & Microsoft Excel VBA/2. Downloading & Installing Virtual Forms Framework for Excel VBA.vtt

2.4 kB

9. Search for MySQL Database hosting/2. What do we need for our database.vtt

2.5 kB

14. Creating Customers table and Virtual Form/2. Create a Customers Virtual Form in Virtual Forms Designer.vtt

2.5 kB

20. Bonus Content/1. Bonus Lecture & Resources.html

2.5 kB

5. Adding first few lines of Excel VBA code/6. Tip Error Class does not support Automation or does not support expected inter.vtt

2.9 kB

4. Creating a menu Userform in Excel VBA/2. Creating a MainMenu Userform in Excel VBA.vtt

2.9 kB

11. Setting up MySQL server and database on a shared hosting/3. Creating a MySQL database on a shared hosting server.vtt

3.2 kB

3. Starting with Virtual Forms & Microsoft Excel VBA/3. Setup your Project Files & Folders.vtt

3.3 kB

2. Setup your database/6. Create MySQL Database from Model (Forward Engineer).vtt

3.4 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/2. Change the decimal places.vtt

3.7 kB

5. Adding first few lines of Excel VBA code/2. Creating a public instance of the Virtual Form control object in Excel VBA.vtt

3.7 kB

9. Search for MySQL Database hosting/3. Choosing the right hosting provider.vtt

3.7 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/3. Maximum Length & Width of the Edit & Grid Field.vtt

3.8 kB

8. Intro to Lookup Virtual Forms/1. Create a simple Lookup Virtual Form.vtt

3.9 kB

11. Setting up MySQL server and database on a shared hosting/2. Creating an account with your web hosting provider.vtt

3.9 kB

2. Setup your database/5. Creating first relationships or foreign keys.vtt

4.0 kB

17. MySQL Data Export & Import/2. MySQL Data Export and Import Experiment.vtt

4.1 kB

2. Setup your database/8. Update (Synchronize) MySQL database schema & Model.vtt

4.3 kB

3. Starting with Virtual Forms & Microsoft Excel VBA/1. About Virtual Forms for Excel VBA.vtt

4.3 kB

16. Virtual Foms Edit control design change/3. Edit control change position of Textboxes.vtt

4.3 kB

18. Access database & Excel Workbook as Data source (Using Blank Templates)/1. Access database as the Data source (Using Blank Templates).vtt

4.5 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/2. Explaining the Virtual Form parts (structure).vtt

4.6 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/1. Change the Virtual Form caption and label captions.vtt

4.8 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/4. Tip Why use Primary Key with Auto Increment.vtt

4.8 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/6. Tip I call the ShowVirtualForm function and nothing happens.vtt

5.3 kB

1. Introduction/1. Course Introduction.vtt

5.3 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/5. Creating more Virtual Forms and opening them from Excel VBA.vtt

5.5 kB

14. Creating Customers table and Virtual Form/3. Add Customers Virtual Form to Main Menu Userform in Excel VBA.vtt

5.8 kB

2. Setup your database/2. MySQL server & MySQL Workbench installation.vtt

5.8 kB

10. Passive income through a web hosting affiliate program/2. What is affiliate marketing in few simple words.vtt

6.3 kB

14. Creating Customers table and Virtual Form/1. Creating a Customers table using a SQL script.vtt

6.4 kB

2. Setup your database/3.1 ModelOMS.zip.zip

6.4 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/1. Excel VBA code for opening the Virtual Form Designer.vtt

6.8 kB

11. Setting up MySQL server and database on a shared hosting/4. Export your database to MySQL server on Shared Hosting using Forward Engineering.vtt

6.9 kB

18. Access database & Excel Workbook as Data source (Using Blank Templates)/2. Excel workbook as the Data source (Using Blank Templates).vtt

7.1 kB

11. Setting up MySQL server and database on a shared hosting/5.1 modeloms_2.zip.zip

7.1 kB

2. Setup your database/5.1 ModelOMS_1.zip.zip

7.1 kB

12. Using hosted database within Excel VBA & Virtual Forms/1.2 modeloms_3.zip.zip

7.4 kB

12. Using hosted database within Excel VBA & Virtual Forms/1. Changing connection string from local to hosted MySQL database in Excel VBA.vtt

7.7 kB

2. Setup your database/3. Creating a MySQL database and first tables using a model.vtt

8.0 kB

17. MySQL Data Export & Import/1. MySQL Data Export and Import.vtt

10 kB

13. From Excel VBA to VB.NET or C# Intro/1. From Excel VBA to VB.NET.vtt

13 kB

11. Setting up MySQL server and database on a shared hosting/5. Differences between Windows & Linux related to the MySQL server.vtt

13 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/3. Create your first Virtual Form with VF Designer for Excel.vtt

15 kB

5. Adding first few lines of Excel VBA code/3. Writing Initialization and termination code in Excel VBA.vtt

16 kB

5. Adding first few lines of Excel VBA code/5. Troubleshooting connecting to MySQL in VBA explained in detail.vtt

22 kB

13. From Excel VBA to VB.NET or C# Intro/1.1 VBAToVBNet_v001.zip.zip

24 kB

3. Starting with Virtual Forms & Microsoft Excel VBA/3.1 Project OMS_v001.zip.zip

99 kB

4. Creating a menu Userform in Excel VBA/2.1 Project OMS_v002.zip.zip

104 kB

5. Adding first few lines of Excel VBA code/1.1 Project OMS_v003.zip.zip

104 kB

5. Adding first few lines of Excel VBA code/2.1 Project OMS_v004.zip.zip

104 kB

5. Adding first few lines of Excel VBA code/3.1 Project OMS_v005.zip.zip

107 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/1.1 Project OMS_v006.zip.zip

108 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/3.1 Project OMS_v007.zip.zip

111 kB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/5.1 Project OMS_v008.zip.zip

112 kB

12. Using hosted database within Excel VBA & Virtual Forms/1.1 Project OMS_v013.zip.zip

113 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/1.1 Project OMS_v009.zip.zip

113 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/3.1 Project OMS_v011.zip.zip

113 kB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/2.1 Project OMS_v010.zip.zip

113 kB

8. Intro to Lookup Virtual Forms/1.1 Project OMS_v012.zip.zip

113 kB

14. Creating Customers table and Virtual Form/2.1 Project OMS_v014.zip.zip

118 kB

14. Creating Customers table and Virtual Form/3.1 Project OMS_v015.zip.zip

118 kB

16. Virtual Foms Edit control design change/6.1 Project OMS_v023.zip.zip

118 kB

15. Virtual Foms Grid control design change/1.1 Project OMS_v016.zip.zip

118 kB

15. Virtual Foms Grid control design change/2.1 Project OMS_v017.zip.zip

119 kB

16. Virtual Foms Edit control design change/2.1 Project OMS_v021.zip.zip

119 kB

15. Virtual Foms Grid control design change/4.1 Project OMS_v019.zip.zip

119 kB

15. Virtual Foms Grid control design change/3.1 Project OMS_v018.zip.zip

119 kB

15. Virtual Foms Grid control design change/5.1 Project OMS_v020.zip.zip

119 kB

16. Virtual Foms Edit control design change/3.1 Project OMS_v022.zip.zip

119 kB

11. Setting up MySQL server and database on a shared hosting/1. Section Introduction.mp4

4.3 MB

9. Search for MySQL Database hosting/1. Section Introduction.mp4

5.5 MB

16. Virtual Foms Edit control design change/5. Edit control responsive design after repositioning of Textboxes.mp4

9.0 MB

15. Virtual Foms Grid control design change/4. Grid control hide column.mp4

12 MB

15. Virtual Foms Grid control design change/5. Grid control change the Alignment of the grid column.mp4

13 MB

15. Virtual Foms Grid control design change/3. Grid control initial sort field.mp4

13 MB

16. Virtual Foms Edit control design change/4. Edit control change the Tab order of Textboxes 1.mp4

13 MB

10. Passive income through a web hosting affiliate program/1. Section Introduction.mp4

14 MB

15. Virtual Foms Grid control design change/2. Grid control change the width of columns.mp4

15 MB

19. This is not the END/1. See us in the next lesson.mp4

16 MB

2. Setup your database/1. Why MySQL as a database.mp4

17 MB

16. Virtual Foms Edit control design change/6. Edit control reset the positions of Textboxes.mp4

17 MB

5. Adding first few lines of Excel VBA code/4. A quick answer to our connection string challenge.mp4

17 MB

4. Creating a menu Userform in Excel VBA/1. Excel Developer Tab.mp4

17 MB

15. Virtual Foms Grid control design change/1. Grid control change the order of columns.mp4

20 MB

9. Search for MySQL Database hosting/2. What do we need for our database.mp4

21 MB

5. Adding first few lines of Excel VBA code/1. Adding a reference to the Virtual Form control in Excel VBA.mp4

22 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/4. Tip Why use Primary Key with Auto Increment.mp4

23 MB

16. Virtual Foms Edit control design change/1. Virtual Forms partially responsive design.mp4

24 MB

16. Virtual Foms Edit control design change/2. Edit control change the Tab order of Textboxes.mp4

30 MB

2. Setup your database/7. Create a Model from MySQL Database (Reverse Engineer).mp4

33 MB

8. Intro to Lookup Virtual Forms/1. Create a simple Lookup Virtual Form.mp4

37 MB

3. Starting with Virtual Forms & Microsoft Excel VBA/2. Downloading & Installing Virtual Forms Framework for Excel VBA.mp4

38 MB

11. Setting up MySQL server and database on a shared hosting/3. Creating a MySQL database on a shared hosting server.mp4

39 MB

5. Adding first few lines of Excel VBA code/2. Creating a public instance of the Virtual Form control object in Excel VBA.mp4

39 MB

14. Creating Customers table and Virtual Form/2. Create a Customers Virtual Form in Virtual Forms Designer.mp4

40 MB

4. Creating a menu Userform in Excel VBA/2. Creating a MainMenu Userform in Excel VBA.mp4

41 MB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/3. Maximum Length & Width of the Edit & Grid Field.mp4

41 MB

9. Search for MySQL Database hosting/3. Choosing the right hosting provider.mp4

42 MB

5. Adding first few lines of Excel VBA code/6. Tip Error Class does not support Automation or does not support expected inter.mp4

42 MB

3. Starting with Virtual Forms & Microsoft Excel VBA/2.1 Virtual Forms Framework2.0.0.31.zip.zip

42 MB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/2. Change the decimal places.mp4

42 MB

10. Passive income through a web hosting affiliate program/2. What is affiliate marketing in few simple words.mp4

46 MB

7. Customizing Virtual Forms with Virtual Forms Designer for Excel/1. Change the Virtual Form caption and label captions.mp4

47 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/5. Creating more Virtual Forms and opening them from Excel VBA.mp4

49 MB

11. Setting up MySQL server and database on a shared hosting/2. Creating an account with your web hosting provider.mp4

51 MB

2. Setup your database/6. Create MySQL Database from Model (Forward Engineer).mp4

52 MB

3. Starting with Virtual Forms & Microsoft Excel VBA/1. About Virtual Forms for Excel VBA.mp4

58 MB

3. Starting with Virtual Forms & Microsoft Excel VBA/3. Setup your Project Files & Folders.mp4

60 MB

17. MySQL Data Export & Import/2. MySQL Data Export and Import Experiment.mp4

62 MB

2. Setup your database/5. Creating first relationships or foreign keys.mp4

68 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/6. Tip I call the ShowVirtualForm function and nothing happens.mp4

72 MB

14. Creating Customers table and Virtual Form/3. Add Customers Virtual Form to Main Menu Userform in Excel VBA.mp4

74 MB

18. Access database & Excel Workbook as Data source (Using Blank Templates)/1. Access database as the Data source (Using Blank Templates).mp4

74 MB

2. Setup your database/2. MySQL server & MySQL Workbench installation.mp4

75 MB

1. Introduction/1. Course Introduction.mp4

83 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/2. Explaining the Virtual Form parts (structure).mp4

86 MB

2. Setup your database/8. Update (Synchronize) MySQL database schema & Model.mp4

87 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/1. Excel VBA code for opening the Virtual Form Designer.mp4

88 MB

12. Using hosted database within Excel VBA & Virtual Forms/1. Changing connection string from local to hosted MySQL database in Excel VBA.mp4

95 MB

11. Setting up MySQL server and database on a shared hosting/4. Export your database to MySQL server on Shared Hosting using Forward Engineering.mp4

96 MB

18. Access database & Excel Workbook as Data source (Using Blank Templates)/2. Excel workbook as the Data source (Using Blank Templates).mp4

102 MB

14. Creating Customers table and Virtual Form/1. Creating a Customers table using a SQL script.mp4

104 MB

2. Setup your database/3. Creating a MySQL database and first tables using a model.mp4

112 MB

16. Virtual Foms Edit control design change/3. Edit control change position of Textboxes.mp4

120 MB

6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/3. Create your first Virtual Form with VF Designer for Excel.mp4

124 MB

17. MySQL Data Export & Import/1. MySQL Data Export and Import.mp4

138 MB

11. Setting up MySQL server and database on a shared hosting/5. Differences between Windows & Linux related to the MySQL server.mp4

204 MB

13. From Excel VBA to VB.NET or C# Intro/1. From Excel VBA to VB.NET.mp4

212 MB

5. Adding first few lines of Excel VBA code/3. Writing Initialization and termination code in Excel VBA.mp4

235 MB

5. Adding first few lines of Excel VBA code/5. Troubleshooting connecting to MySQL in VBA explained in detail.mp4

351 MB