This video will show you how to create the SQL recordset in VBA.
SQL is used to perform updates quickly to a data source. The 4 main SQL statements cover the “action” queries in MS Access:
1. The syntax for the SELECT is:
SELECT [field] FROM [table]
2. The syntax for the UPDATE is:
UPDATE [table] SET [field] = [value]
3. The syntax for the DELETE is:
DELETE FROM [table] WHERE [field] = [value]
4. The syntax for the INSERT is:
INSERT INTO [table] ([field]) VALUES ([value])
This video shows how to use a SQL Recordset In VBA to SELECT records from a table, and UPDATE a record in the table.1
CONGRATULATIONS! YOU HAVE FINISHED THE VBA PROGRAMMING TUTORIAL TRAINING COURSE!
I recommend that you continue your education and solidify your learning by going to our online store and getting the learning guide and complete database for topics you have interest in.
Here are a few of our learning guides you may be interested in:
– Donors And Donations Tracking Database
– Customers And Orders Tracking Database (Coming Soon)
Several Others (Coming Soon)
Sign Up For A FREE MS Access VBA Video Tutorial Subscription. You will get over 27 tutorial videos that will help you do your job better! Start Yours Now At: