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.

Kĩ năng: Excel, Microsoft Access

Xem nhiều hơn: 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

Về Bên Thuê:
( 18 nhận xét ) Utrecht, Netherlands

ID dự án: #17384924

Được trao cho:

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 Thêm

€20 EUR trong 1 ngày
(55 Đánh Giá)
5.4

17 freelancer đang chào giá trung bình €26 cho công việc này

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 Thêm

€31 EUR trong 1 ngày
(254 Nhận xét)
7.5
€23 EUR trong 1 ngày
(340 Nhận xét)
7.2
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 Thêm

€20 EUR trong 1 ngày
(201 Nhận xét)
6.9
€34 EUR trong 1 ngày
(86 Nhận xét)
7.3
€20 EUR trong 1 ngày
(114 Nhận xét)
6.2
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 Thêm

€20 EUR trong 0 ngày
(93 Nhận xét)
6.0
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 Thêm

€30 EUR trong 1 ngày
(88 Nhận xét)
5.8
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 Thêm

€20 EUR trong 1 ngày
(21 Nhận xét)
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 trong 1 ngày
(17 Nhận xét)
4.6
garci56

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

€20 EUR trong 0 ngày
(3 Nhận xét)
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 Thêm

€74 EUR trong 1 ngày
(3 Nhận xét)
3.4
€16 EUR trong 1 ngày
(13 Nhận xét)
3.3
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 trong 1 ngày
(7 Nhận xét)
2.9
saurabhjaswal

Having good knowledge in excel and having excellent typing speed

€16 EUR trong 1 ngày
(0 Nhận xét)
0.0
€21 EUR trong 1 ngày
(0 Nhận xét)
0.0
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 trong 2 ngày
(0 Nhận xét)
0.0