Breaking News: Grepper is joining You.com. Read the official announcement!

Using VBA to link PPT to an ACCESS database

ShowGo Shane answered on July 12, 2022 Popularity 1/10 Helpfulness 1/10

answer Using VBA to link PPT to an ACCESS database

Using VBA to link PPT to an ACCESS database

Comment

Option Explicit

Sub GetInfoFromDB()
Dim Cn As New ADODB.Connection
Dim rec As New ADODB.Recordset
Dim strOut As String

With Cn
    .ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " _
        & " Source=W:\YourAccessDataBAse.mdb;" _
        & "Persist Security Info=False;"
    .CursorLocation = adUseClient
    .Open
End With

With rec
    .Open "SELECT DISTINCT COUNTY " & vbNewLine _
        & " FROM COP " & vbNewLine _
        & " WHERE (COUNTY < 'BOONE') " & vbNewLine _
        & " ORDER BY COUNTY", Cn

    Do While Not .EOF
        If Len(strOut) = 0 Then
            strOut = !COUNTY.Value
        Else
            strOut = strOut & vbNewLine & !COUNTY.Value
        End If
        .MoveNext
    Loop

    .Close
End With
Set rec = Nothing

Cn.Close
Set Cn = Nothing

MsgBox strOut

End Sub

Popularity 1/10 Helpfulness 1/10 Language vb

Source: www.tek-tips.com

Tags: database get module using vba

Link to this answer
Share Copy Link

Contributed on Jul 12 2022

ShowGo Shane

0 Answers Avg Quality 2/10

Using VBA to link PPT to an ACCESS database

Contents

More Related Answers

Using VBA to link PPT to an ACCESS database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.