Find Jobs
Hire Freelancers

Access 2003 VBA Function to consume a webservice.

£20-250 GBP

In Progress
Posted over 11 years ago

£20-250 GBP

Paid on delivery
We need four VB functions in Access 2003 VBA that will accept parameters from the application, consume a webservice and return a string SUCCESS or ERROR-ID-CODE-DESCRIPTION These functions mirror the webservice, documentation for the webservice is attached. Functions should be named and should syntax as follows. ------------------------ Public Function HLClear(key As String, ownerID As String, homeID As String, groupSize As String) As String 'Send Request to Web Service using passed variables If WebServiceResponse(Success) = True Then HLClear = "SUCCESS" Else HLClear = "ERROR-ID:" & homeID & "-Code:" & WebServiceResponse(ErrorCode) & "Message:" & WebServiceResponse(Message) End If End Function Public Function HLCurrency(key As String, ownerID As String, homeID As String, Currency As String) As String 'Send Request to Web Service using passed variables If WebServiceResponse(Success) = True Then HLCurrency = "SUCCESS" Else HLCurrency = "ERROR-ID:" & homeID & "-Code:" & WebServiceResponse(ErrorCode) & "Message:" & WebServiceResponse(Message) End If End Function Public Function HLSetOne(key As String, ownerID As String, homeID As String, groupSize As String, startDate As String, endDate As String, Optional tariffName As String, Optional weeklyRate As String, Optional minNights As String, Optional weekdayRate As String, Optional weekendRate As String) As String 'Send Request to Web Service using passed variables If WebServiceResponse(Success) = True Then HLCurrency = "SUCCESS" Else HLCurrency = "ERROR-ID:" & homeID & "-Code:" & WebServiceResponse(ErrorCode) & "Message:" & WebServiceResponse(Message) End If End Function Public Function HLSetAll(key As String, ownerID As String, homeID As String, groupSize As String, startDates() As String, endDates() As String, Optional tariffNames() As String, Optional weeklyRates() As String, Optional minNightss() As String, Optional weekdayRates() As String, Optional weekendRates() As String) As String 'Send Request to Web Service using passed variables If WebServiceResponse(Success) = True Then HLCurrency = "SUCCESS" Else HLCurrency = "ERROR-ID:" & homeID & "-Code:" & WebServiceResponse(ErrorCode) & "Message:" & WebServiceResponse(Message) End If End Function ------------------------ The winning bidder should be able to provide these functions, written properly, with code REMARKS/Annotation explaining at each major step what the code is doing. Variable naming should be descriptive and relevant to the purpose. We envisage a very quick turnaround and have set a 4 day deadline. If you do not think you can manage this, please do not bid as this has to be completed quickly.
Project ID: 4022578

About the project

12 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Lots of experience in VBA and Access.
£75 GBP in 4 days
5.0 (4 reviews)
3.0
3.0
12 freelancers are bidding on average £25,219 GBP for this job
User Avatar
hi i am very good in access vba.i have read the description and quite sure i am willing to do the work with desired accuracy thanks
£200 GBP in 5 days
4.9 (341 reviews)
6.9
6.9
User Avatar
MS Access expert here. Please see my profile.
£250 GBP in 1 day
4.9 (40 reviews)
6.5
6.5
User Avatar
Hi! I can write these for you. Kind Regards
£100 GBP in 1 day
4.9 (47 reviews)
5.2
5.2
User Avatar
Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly application development capability I have. Looking forward to your prompt reply. Kindest regards. Farrukh Rehman.
£100 GBP in 0 day
4.8 (15 reviews)
4.5
4.5
User Avatar
I am interested,
£1,000 GBP in 60 days
4.5 (17 reviews)
3.8
3.8
User Avatar
Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and managed database and automated reports for different projects. Regards Mukul
£180 GBP in 5 days
5.0 (1 review)
2.0
2.0
User Avatar
I will do your work.
£300,000 GBP in 90 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I have Good Knowledge in VB & VBA Thanks Regard By Chitra Sena Bhuyan
£150 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Visual basic expert is here. I can manage your requirement with quality.
£250 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
we are ready to work on this project.
£100 GBP in 1 day
0.0 (1 review)
1.4
1.4

About the client

Flag of UNITED KINGDOM
Birkenhead, United Kingdom
5.0
34
Payment method verified
Member since Feb 14, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.