Find Jobs
Hire Freelancers

VBA in Excel and Access

$30-250 USD

Selesai
Dibuat lebih dari 10 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
I am short a developer and I need someone with experience in VBA (Visual Basic for Applications) and some desktop VB.NET I have a number of SQL (2005 and 2008) databases with Microsoft Access (2007 and 2010) front end. These use Microsoft Access and VBA as the user interface and I need someone to help out on an ongoing bases. It is not a huge volume of work but it does come in small projects. The specific project I have now is related to one of my databases. I need to develop a data collection form in Excel and VBA. The form will be e-mailed out and will be completed by field technicians and e-mailed back. I have started the form and have some working code but workload and priorities mean I need someone else to help out. The Excel file contains 8 forms (Excel Worksheets) and 2 worksheets of data. The basis is the user fills in the form and there are some fields that have upper and lower limits and some fields that require a look-up and auto complete. The data for the upper and lower limits is in the workbook (on one of the two data sheets). I need the developer to write some VBA code so that when the "cell update" event is triggered the code will compare the value entered to the value in the other sheet. If it is outside the limit the user gets a message and the cell focus is set back to the cell with the out of limit value. This is not hard to do but there are 8 forms and each form has 25 to 30 fields that need validated (it is a lot but if the code is written correctly it can be cut and pasted) I am part way through the first form but I need someone to finish it and complete the other 7 forms using the same code template. I also need the developer to help lock the sheet so when it is sent to the user that they only enter data in certain fields. When this project is done I will be posting a second project to write a desktop application to take the results entered and post them to a table in Access so there will be a bit of ongoing work. For this Excel project I am estimating that there is about 2 or 3 hours work in each form. I am also assuming USD10 per hour so USD10 x 3 hours per form x 8 forms = USD 240 max My two main criteria will be cost and quality. I am not going over 240 USD and I will be looking for someone who can come in under that and I am also looking someone who has some history of doing a good job (feedback) with VB development (either VBA or VB.NET)
ID Proyek: 4941916

Tentang proyek

30 proposal
Proyek remot
Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
HI, I can do the job, just send me the excel file to do the changes Regards Diego
$200 USD dalam 5 hari
4,9 (41 ulasan)
5,8
5,8
30 freelancer menawar dengan rata-rata $205 USD untuk pekerjaan ini
Avatar Pengguna
Hi mitsystems, plenty of experience in Excel VBA,formulas + VB.NET... Should be able to help you out with ease. please reply. thanks !
$233 USD dalam 5 hari
4,8 (209 ulasan)
6,1
6,1
Avatar Pengguna
Hi, I have been developing bespoke Excel applications incorporating a good deal of VBA for 20 years plus. Quite a few projects on freelance, please see feedback. Manchester based. Off on hols to Wales tomorrow but I will be keeping an eye on bids and I will be doing some work. This doesn't look to be a problem. I would like to work on this and on future projects. Give me a shout David
$200 USD dalam 8 hari
4,9 (40 ulasan)
5,6
5,6
Avatar Pengguna
We are interested in this work and good knowledge of vb .net and initial understanding of VBA
$240 USD dalam 5 hari
4,6 (17 ulasan)
6,1
6,1
Avatar Pengguna
Hello, I have read complete project description and I am ready to start work on it. I will code in vb.net Regards Sujal
$240 USD dalam 7 hari
5,0 (29 ulasan)
5,3
5,3
Avatar Pengguna
Hello I can help you to get it done quickly. Thanks Guru Venkat
$155 USD dalam 2 hari
4,9 (26 ulasan)
5,4
5,4
Avatar Pengguna
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
$184 USD dalam 5 hari
4,7 (49 ulasan)
5,7
5,7
Avatar Pengguna
Hello: Please have a look at the PMB for more details
$206 USD dalam 7 hari
4,9 (6 ulasan)
5,0
5,0
Avatar Pengguna
UK-based developer, specialising in Access and Excel systems - have been developing systems since 1998.
$222 USD dalam 3 hari
4,8 (12 ulasan)
4,8
4,8
Avatar Pengguna
Hi, Ready to start.... Regards
$222 USD dalam 15 hari
5,0 (8 ulasan)
4,4
4,4
Avatar Pengguna
PLease read my pm message
$145 USD dalam 3 hari
4,9 (18 ulasan)
4,1
4,1
Avatar Pengguna
hello......................
$100 USD dalam 3 hari
5,0 (3 ulasan)
4,0
4,0
Avatar Pengguna
Hello, Can support you with this task. Have strong background in VB, VB.NET, SQL. Several projects were created here on freelancer as well, so you can see reviews. Will be available to start from Friday, and deliver project on Weekend. Regards, Giorgi
$222 USD dalam 3 hari
4,8 (12 ulasan)
4,1
4,1
Avatar Pengguna
I could do this for you. Please check my Excel reviews. As far as the .Net stuff in future I am an expert with Windows Forms projects using VB.Net (I prefer 2010 if possible). I have SQL 2008 R2 and 2012 on line at all times. Can set up 2005 if required. We will have some slight time zone 'jitter' but I am in UTC-4:00 so it is not too bad. I am available this weekend if you can answer questions and test. That way you could have this for early week.
$160 USD dalam 3 hari
5,0 (20 ulasan)
4,0
4,0
Avatar Pengguna
Hello. See PM please.
$238 USD dalam 7 hari
4,0 (11 ulasan)
5,0
5,0
Avatar Pengguna
Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Murtaza
$240 USD dalam 7 hari
5,0 (8 ulasan)
4,1
4,1
Avatar Pengguna
Hi, Expert here. Ready to Start
$155 USD dalam 6 hari
5,0 (9 ulasan)
3,5
3,5
Avatar Pengguna
Hi, I am having good Experience in VBA, MSAccess and have worked like this kind of migration for almost 4 Projects. I can do this for you...
$233 USD dalam 10 hari
5,0 (4 ulasan)
3,1
3,1
Avatar Pengguna
trust is key
$222 USD dalam 5 hari
4,8 (8 ulasan)
2,8
2,8
Avatar Pengguna
Hello, I'm good VBA coder. Your project is clear and interesting for me and I'm ready to start right now. Please let me know if any questions Thank you
$160 USD dalam 5 hari
4,8 (1 ulasan)
3,0
3,0
Avatar Pengguna
Hi I have a lot of hands-on experience with VBA for excel as well as SQL Databases and i can send you the latest complete project for you to reference Regards HAI
$200 USD dalam 3 hari
5,0 (2 ulasan)
2,3
2,3

Tentang klien

Bendera UNITED KINGDOM
Armagh, United Kingdom
5,0
12
Memverifikasi Metode pembayaran
Anggota sejak Jan 24, 2005

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.