SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[ms-access] How to execute a query in ms-access in VBA code?

How can I execute a query to return records in an ms-access database using VBA code?

This question is related to ms-access vba

The answer is

How about something like this...

Dim rs As RecordSet
Set rs = Currentdb.OpenRecordSet("SELECT PictureLocation, ID FROM MyAccessTable;")

Do While Not rs.EOF
   Debug.Print rs("PictureLocation") & " - " & rs("ID")
   rs.MoveNext
Loop

Source: Stackoverflow.com

Examples related to ms-access

• How to get parameter value for date/time column from empty MaskedTextBox • Access And/Or exclusions • Get length of array? • How to pass an array to a function in VBA? • How to insert values into the database table using VBA in MS access • Access 2013 - Cannot open a database created with a previous version of your application • Does VBA contain a comment block syntax? • java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why? • Manipulating an Access database from Java without ODBC • How to find longest string in the table column data

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?