Thank you for your time. It took me a moment to understand your code. Meanwhile I switched to SQL database and came up with this idea that works ;)
Dim cs As String, cn As Object, cmd As Object, rs As Object, rc As Object
Dim ListClients() as String
cs = "driver={SQL...
Here is my code fo far
Const DBNAME = "H:\Attachmate\CustDat.mdb"
Dim cs As String, cn As Object, cmd As Object, rs As Object, rec As Object
cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBNAME & ";Persist Security Info=False"
Set cn = CreateObject("ADODB.Connection")
Set cmd...
I have found several examples how to pass data to Access Database, but need small example how to get data from Access and use it as variable using Select query. Any help ;) ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.