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.
I know how to make a query to Access DB using Excel VBA I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a schedule for delivery trucks pick-up and d Plus
18 freelance font une offre moyenne de €26 pour ce travail
Hi there, Warm Greetings We came along with your request for from Excel make query in Access and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have pro Plus
Hi! This is easy to resolve. Botton line is that you are messing up ADO and DAO which cannot work. I will explain in details why and how you can retrieve data using ADO or DAO. (I reproduce it on my computer and mak Plus
Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Plus
Hello, At first you should add a reference to the: "microsoft office 14 access database engine object library". In VBA module editor go to menu tools->references, set check box near "microsoft office 14 access databa Plus
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..
Hi, I have Read Your Project Excel . I am very Interested in your Project and also I am ready to Start Immediately. I assure you will like my Work very much and I will deliver you project timely and there will be no Plus
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
You've to use DAO to finish this task. I looked quickly for this sample of code, for ex. Dim rsBoho have to be as [login to view URL]