Sql

[chris11590]

I have been reading a book on SQL language. Its a great book and very easy to comprehend. I would like to practice the syntax of the language but I dont know where I would write the language. Its in an event tab. VBA code. I doesnt tell me that part. LOL.

any help and all help appreciated

Thank you

 

[Rabbie]

Initially if you go to the query tab and select create New you can open the window in SQL mode and type in your SQL and then see the result by changing the view to see the data.

In VBA generate a text string with your SQL in it and then you can use

Docmd.Runsql to run it. Check out Access help for full details.

Warning there are different dialects of SQL so check that you are using one compatible with Access

 

[chris11590]

is the SQL only in the query or can you use them in forms reports and tables????

 

[Rabbie]

is the SQL only in the query or can you use them in forms reports and tables????

SQL is a language designed to get/add/change data from tables. Every query is in fact an SQL statement. You often base forms/reports on a query which uses SQL.

 

[tranchemontaigne]

As you get deeper into recordsets, you will be able to use your knowledge of SQL to define the data that will populate your recordset.

You can also use APPEND and UPDATE queries within VBA to write/edit recordset data back into a table.
________
Honda Gy6 Engine History