Terminé

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.

Compétences : Excel, Microsoft Access

en voir plus : 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

Concernant l'employeur :
( 18 commentaires ) Utrecht, Netherlands

Nº du projet : #17384924

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(55 Commentaires)
5.4

17 freelance font une offre moyenne de €26 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(254 Commentaires)
7.5
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(340 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(201 Commentaires)
6.9
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(86 Commentaires)
7.3
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(114 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(93 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(88 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(21 Commentaires)
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..

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(17 Commentaires)
4.6
garci56

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(3 Commentaires)
3.4
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(13 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(7 Commentaires)
2.9
saurabhjaswal

Having good knowledge in excel and having excellent typing speed

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0