Solved VBA Functions, Command and Properties (1 Viewer)

[Kha]

Hi,
I am trying to know VBA Functions, Commands and Properties that deal with SQL

DoCmd.RunSQL: is for statement for an action query or a data-definition query.
DoCmd.ApplyFilter
Me.RecordSource: property: to specify the source of the data for a form.
Me.Filter: to specify a subset of records to be displayed when a filter is applied to a form, report, query, or table.

Do we have other Functions, Commands and Properties?

 

[June7]

CurrentDb.Execute

WHERE CONDITION argument of OpenForm and OpenReport follow SQL syntax, as does WHERE argument of domain aggregate functions.

Building recordset objects uses SQL.

 

[theDBguy]

Do we have other functions?

Take a look here.

Functions (alphabetical list)

Office VBA reference topic

learn.microsoft.com

 

[The_Doc_Man]

Since you included .RecordSource which is SQL, there is also .RowSource (used for ListBox and ComboBox)

Then, ALL of the Domain Aggregate functions implicitly use SQL though you only see parts of the SQL syntax, similar to .Filter syntax.

 

[MajP]

FYI Me.filter and Me.Recordsource are not functions. These are properties of a form and they are strings.
There are a few true functions such as the Domain aggregate functions as @The_Doc_Man mentioned

If you are going to go farther in vba using SQL need to learn DAO programming. ADODB if connecting to other non-access data sources.

Microsoft Access tips: DAO Programming Code Examples

VBA code using the DAO library in Microsoft Access.

allenbrowne.com

 

[Pat Hartman]

I find the functions by category to be much more useful. If you don't know the name of a function, the alpha list is useless. The category list gives you an easier way to target into what you need.

Access Functions (by category) (microsoft.com)

Here's an overview of the DAO object model

Access/VBA Tutorials - The DAO Object Model

Tutorial: The DAO Object Model. Details and information on DAO Model - what it is and how to make use of it!

www.everythingaccess.com

Here's a link to a useful book but Amazon has a newer version. I included the first link for the picture but the second link is for the book if you want to buy it.

Access Database Design and Programming, Second Edition

The DAO Object Model As the name Data Access Objects suggests, the DAO is, at least in part, an object-oriented environment. In particular, the DAO is implemented as a hierarchy … - Selection from Access Database Design and Programming, Second Edition [Book]

www.oreilly.com

Access Database Design & Programming (3rd Edition): Roman, Steven: 9780596002732: Amazon.com: Books

Access Database Design & Programming (3rd Edition) [Roman, Steven] on Amazon.com. *FREE* shipping on qualifying offers. Access Database Design & Programming (3rd Edition)

www.amazon.com

Here is another which is just the DAO Object Model

DAO Object Model: The Definitive Reference: Feddema, Helen: 9781565924352: Amazon.com: Books

DAO Object Model: The Definitive Reference [Feddema, Helen] on Amazon.com. *FREE* shipping on qualifying offers. DAO Object Model: The Definitive Reference

www.amazon.com