Excel, SQL, Visual Basic Job by LightForce

You've helped me in the past, and I was wondering if you could help on this one. I am somewhat experienced with vba and programming in general, but am pressed for time and thus would like your help / input on this one. The access database will eventually be stored onto a shared network folder. Weekly a new active report will be imported into the db. I plan to use a query or something to move the old data into an archived table. The main focus is being able to update the db from the excel spreadsheet. The user will select a location code, hit the run Parameter Query, see the results and make entries off to the right, once user enters the data ideally one would hit the update button and the info would go back into the db. I'm stuck on the update part of it. Here's a link that may be helpful: [url removed, login to view]

and here's another: [url removed, login to view]


I believe the technique I'm trying isn't supported and thus the 3219 error. Your feedback and input would be appreciated. Let me know your thoughts. Thanks Jason

Skills: Excel, SQL, Visual Basic

See more: vba programming in excel, vba excel programming, programming technique, programming in vba, programming in excel vba, microsoft excel vba programming, microsoft access programming, html spreadsheet code, excel vba db, excel programming vba, excel and access programming, excel access programming, custom excel programming, vba right, vba error, right vba, microsoft excel VBA, excel vba help, part time input data, microsoft excel programming, vba access excel, shared folder, project on vba, nov, microsoft access vba

About the Employer:
( 2 reviews ) Auburndale, United States

Project ID: #1273916

1 freelancer is bidding on average $30 for this job


Hired by the Employer

$30 USD in 2 days
(43 Reviews)