Completed

In Office 2010 I want from Excel make query in Access

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)

etc

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.

Skills: Excel, Microsoft Access

See more: what should i put in freelancer if i want to design an access database, office 2010 word and excel programming services in az, i want to make grphic design in tokyo, microsoft access, i want to make a animated movie, i want to make, i want to make own design of cloth online, i want to make logo for my company, i want to make freelance project, i want to make business, i want to make a website online for part time job, i want to make a website for my business, i want to make a vector, i want to make a logo design for free, i want to make a design for a children program, i want to make a catalog i need designers

About the Employer:
( 16 reviews ) Utrecht, Netherlands

Project ID: #17384924

Awarded to:

archanaoswal

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 More

€20 EUR in 1 day
(39 Reviews)
5.2

18 freelancers are bidding on average €26 for this job

schoudhary1553

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 More

€31 EUR in 1 day
(244 Reviews)
7.4
€23 EUR in 1 day
(315 Reviews)
7.2
€34 EUR in 1 day
(86 Reviews)
7.3
branislavm

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 More

€20 EUR in 1 day
(201 Reviews)
6.9
€20 EUR in 1 day
(110 Reviews)
6.2
royalcalif

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 More

€30 EUR in 1 day
(86 Reviews)
5.8
VladimirLilenko

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 More

€20 EUR in 0 days
(92 Reviews)
5.9
sergey12345

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 More

€20 EUR in 1 day
(21 Reviews)
5.0
vmadhavan15

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..

€30 EUR in 1 day
(17 Reviews)
4.6
garci56

In your code Replace: [login to view URL](SqlBoho) [login to view URL](SqlBoho) Regards!

€20 EUR in 0 days
(3 Reviews)
4.0
graphicdoll

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 More

€74 EUR in 1 day
(2 Reviews)
2.8
Maheshpatel107

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

€20 EUR in 1 day
(7 Reviews)
2.9
€16 EUR in 1 day
(5 Reviews)
2.9
€19 EUR in 1 day
(7 Reviews)
2.6
qbek

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]

€29 EUR in 2 days
(0 Reviews)
0.0
saurabhjaswal

Having good knowledge in excel and having excellent typing speed

€16 EUR in 1 day
(0 Reviews)
0.0
€21 EUR in 1 day
(0 Reviews)
0.0