Đang Thực Hiện

Microsoft Access coding

Custom Access database that is calculating some numbers and storing them in the database before previewing a report. We are getting errors when doing an .Edit or even when creating an update SQL statement. It is only a few lines of code that need to be fixed. We have had two professionals already look at it and are unable to fix it so someone with very hight Access and Visual Basic skills are needed. Should only take a few minutes to fix. Right now it is producing an error of "Invalid Operation" which runs fine as a query. Do a good and fast job and there may be more work to come. We are out til Monday but would like to wake up Monday and pick a provider and have it fixed by the end of the day or Tuesday morning.

Code segment

SQL3 = "UPDATE Operations SET OptionDepositCredit = " & tmpOptionDepositCredit & ", OriginalOptionDeposit = " & tmpOriginalOptionDeposit & ", RemainingOptionDeposit = " & tmpRemainingOptionDeposit & _

" WHERE ((([Fund #])= '" & CurFund & "') AND (([url removed, login to view])= '" & CurPeriod & "'))"

Set db3 = CurrentDb

Set rs3 = [url removed, login to view](SQL3) '<- fails here

Set rs3 = Nothing

Set rs3 = Nothing

Kỹ năng: Visual Basic

Xem thêm: producing work, microsoft access job, coding we, code coding, basic coding skills, access database professionals, access query invalid operation, sql microsoft access, microsoft visual, microsoft work, microsoft access sql, job access, coding job, visual basic edit, sql microsoft, sql access, segment, pick basic, morning, job visual basic, it operations, calculating, c access, access sql, access microsoft

Về Bên Thuê:
( 4 nhận xét ) San Antonio, United States

Mã Dự Án: #55126

Đã trao cho:

netcoder

Hi, I think I can do it:-)! Best regards, rentacoder:-)

$30 USD trong 1 ngày
(52 Đánh Giá)
5.5

33 freelancer đang chào giá trung bình $38 cho công việc này

HussienSharaf

i m a profitional at Ms access ; i ve gone through most problems with it at queries.. there r some exceptions for MS acces that have to be handled unconventionally.. i can handle that one in no time...

$30 USD trong 0 ngày
(40 Đánh Giá)
6.3
schandraram

Hello Please see PMB for details of my bid. Thank you

$30 USD trong 1 ngày
(55 Đánh Giá)
5.9
wsh2

Hello.. I am a Hall of Fame VB / VBA expert with www.vbcity.com and a decorated USMC Viet Nam war veteran ( gawd.. that was sooo long ago.. lol).. so I've me t a Texan or two.. . I have already taken the liberty of Thêm

$30 USD trong 1 ngày
(19 Đánh Giá)
5.2
ddumitrascu

Hi, Please see PMB. Thank You, Dan

$30 USD trong 0 ngày
(53 Đánh Giá)
4.9
VerusSoft

Hello. Please view PM for details. Thank you.

$30 USD trong 0 ngày
(7 Đánh Giá)
4.0
smitech

Dear Sir, Please check PMB. Thanks & Regards.

$30 USD trong 0 ngày
(7 Đánh Giá)
3.8
baburam

Dear Sir, I am having more than 4 years of experience in VB and Access development. Send me the source code and I will fix it up and send you back with in 2 days. Regards

$30 USD trong 2 ngày
(18 Đánh Giá)
3.5
ajay192

Please see PMB for details.

$30 USD trong 1 ngày
(3 Đánh Giá)
3.6
amanullahs

I can fix this problem for you. My expertise is DAO and ADO. I can do a neat and clean work by debugging/re-engineering the issue and providing a solution in no time. Awaiting your response.

$65 USD trong 1 ngày
(1 Đánh Giá)
2.7
cheaperandbetter

I have 7 years of experience with Access. Microsoft Certified Professional. I would be glad to fix your problem.

$60 USD trong 1 ngày
(2 Đánh Giá)
1.8
krishdts

Hello Client,we have gone through your requirement DreamTech Solutions is a total software development organization. Our software solutions fit the business and budget of any organization and help the organization to s Thêm

$30 USD trong 2 ngày
(0 Đánh Giá)
4.7
infoims

hi, we have a good team of VB and VB.NET developers with experience in ERP, Hotel Management and Inventory Management Softwares. Pls contact with your yahoo id so we can get this started...best regards..manish

$30 USD trong 1 ngày
(0 Đánh Giá)
3.2
snawab2001

bid amount is negotiable... can you send me your access file and vb program With my expertise and experince in VB I assure you the quality work with in time. We are having more than 6 years of experience in proje Thêm

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
aslampa

Can do as fast as u like..

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
Rajalaxmi

I have done similar task. I can find the best solution for your task if give a chance for me.

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0
shekhartinku

Please check the PMB. Please let me know. Looking forward for the work

$50 USD trong 0 ngày
(0 Đánh Giá)
0.0
mihiramreli

i can give you it in only one hour.

$100 USD trong 0 ngày
(0 Đánh Giá)
0.0
viveksoftvision

we can do it easily.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
errorfree

Hi, i m ready to finsih this job. thanks adnan

$36 USD trong 1 ngày
(1 Đánh Giá)
3.7
grubaszek

it is very easy to fix :)

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0