SQL and VBA

[Barguast]

Can someone show me how I can use a SELECT statement from within VBA (in Access). All I want to do is retrieve all of the names from a table and add a specific field from each returned rows into a ComboBox.

e.g.

Perform the query...

SELECT empid, name
FROM employees;

... and then add all 'name' fields from the returned rows to a ComboBox.

Thanks.

[DKenny]

Here's a sample piece of code that populates Combo1 when the form is opened.

Private Sub Form_Open(Cancel As Integer)
    With Me.Combo1
        .ColumnCount = 2
        .Width = 2440
        .ColumnWidths = "0;2440"
        .BoundColumn = 1
        .RowSource = "SELECT BRAND_ID,BRAND_DESC FROM PH_BRAND"
    End With
End Sub

I've used a select from my table, just change the SQL statement to point to your table

[Barguast]

Ah, that seems simple enough. Thanks.

Could you also tell me how to do the same, but receive the data as an array of strings? I can't see how I would adapt your example to make it do this...

[Ecniv]

Use ADO and a recordset object.

Search the forums or tutorials online there are loads of examples.


Using the array to fill the combobox might be a problem though in access requires special coding.