Need little help with coding
In Office 2010 I want from Excel make query in Access. The accd is already open.
In Excel I code:
Public Function GetCollOntvInBoho(Dosnr) As Collection
Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection
Set AccessApp = GetObject("X:\[login to view URL]").Application
If Not AccessApp Is Nothing Then
SqlBoho = "SELECT * FROM tblBoho WHERE Dosnr = " & Dosnr & " AND Grootboekrekening = 1013 AND Activa > 0"
Set rsBoho = [login to view URL](SqlBoho)
I get an error at line: Set rsBoho = [login to view URL](SqlBoho), saying kind of: This property is not supported with this object.
I give you € 20 for the answer. Thanks in advance.
17 freelancers are bidding on average €26 for this job
share the screen via teamviewer I will fix it.. I can do this one on directly accessing your system.. Please ping me if you are interested iwth my proposal.. thank you..
Hello, I have read your problem related to access query in excel macro. I am able to help you in given problem and will solve this quickly. I have 5 years experience of software development.. Thanks Mahesh