Find Jobs
Hire Freelancers

Fix my and program and improve it.

$20-50 AUD / hour

Cancelled
Posted about 4 years ago

$20-50 AUD / hour

Hi my name is Brendan and I work in a very small not for profit medical research lab in Ballarat Australia. We have a visual basic program which we use to manage patient sample vials stored in liquid nitrogen. The program is coming up with an "run time error 91 " message. None of us here know visual basic or how to fix the problem. Also we are concerned we may be hitting the storage limits for the program. What I would like to do is to post a copy of the program with sensitive data redacted for some one to to fix the problem (runtime 91) and check to see if we still have room to continue to add data and modify the program if needed to improve it. The program is designed to inventory vials stored in liquid nitrogen tanks. Each tank has 6 Racks , each rack has 8 boxes , each box contains 100 vial positions. so vials are stored for example as T2R3B4P36 ( Tank 2 rack3 box 4 position 36) . each vial has data associated with it e.g date stored , disease type. The program was developed from a legacy excel spreed sheets so some of headings may appear odd . for example a column headed "comment" should be called "Codes". which may be a good example of something which could / should be changed. Also because we have multiple users the way some of the data is entered is not consistent. we currently have six tanks but that will increase by at least one tank per year so we need to be able to continue to add data with out hitting any design limits. the vials are also di- identifed to so patients names are not used. A code is assigned to a patient and any additional samples received from a patient are assigned the same code. The program consists of six linked excel sheets : A home page for entering and deleting patient data, a master list which has the patients name and assigned code, a page listing all the vials for each patient, a list of all the vials in all the tanks and a list box for adding tanks and codes for patient samples ( the list box was originally set up for three tanks but we now have 6+ so it would be good if we could modify it) and finally a sheet listing all the vials used and deleted from the system. it would be great if somebody could take this on and: 1) Fix any bugs. 2) Check the design limits (if any) for adding data 3) suggest and implement any design changes and improvements in consultation with me. I look forward to your replies and getting this problem fixed .
Project ID: 24131335

About the project

10 proposals
Remote project
Active 4 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
10 freelancers are bidding on average $44 AUD/hour for this job
User Avatar
Hi Brendan, We have reviewed your requirement and the error you are facing. We have expertise with visual basic, .NET, Nodejs, LAMP and man other langues/platforms and been delivering solutions from past 15 years. We understand the nature of project and data security so we signed and follow NDA well. We have highly experienced team with us on each of the technology and my self i have visual basic experience from 14 years. So lets get started with this project and will help you to fix as well as enhance it as per your need. Lets get started. Thank You, Shyam
$35 AUD in 40 days
5.0 (210 reviews)
8.6
8.6
User Avatar
As per my 20 years of vast experience in VB and VB.NET and C#. I would recommend new build up of your program because VB has been obsoleted since last 10 years and no improvements should be done in your program. Error is related to some internal object does not exist and program is trying to access it at run time. Looking forward to discuss your requirements to deliver you a nice piece of software with SQL database back end instead of excel sheets as a data source for your program.
$50 AUD in 5 days
5.0 (31 reviews)
7.8
7.8
User Avatar
Hi there I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your project. I will provide an efficient, robust and well documented solution with dedicated support. I will anticipate to discuss the details to get started. Thanks Farah Khan
$50 AUD in 40 days
5.0 (549 reviews)
7.5
7.5
User Avatar
Hey, I reviewed the error screenshot you shared and it does not appear to be an error related to hitting the limits. I am going through the program and will let you know what I find. Please accept my bid and I should be able to resolve the issue for you for sure. I am an expert in Excel and have delivered more than 500 projects successfully here. Look forward to hear from you. Best Regards, Rishi
$35 AUD in 4 days
5.0 (185 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
$35 AUD in 5 days
5.0 (139 reviews)
6.7
6.7
User Avatar
Hi!, what are the steps that I need to follow to reproduce the error? It would be better if you can record them with the phone or screen capture app, and send the video through the chat Thanks! Felice
$50 AUD in 40 days
5.0 (25 reviews)
6.8
6.8
User Avatar
Hi there, My name is Mauricio I'm the MS Excel expert from Trascender Global Team, with 4 years of experience in developing VBA, including user interfaces to manage data. I've read the details of your project and checked the error image and the excel database and I'm highly interested in working with you to fix this and any other possible bugs that the program may have, check the design data limits and provide insights of possible improvements to optimize the program. According to the image is not something related to the limit itself but off course the code needs to have an error handler whenever it gets to the Excel limit, I can help you with that as well. Let's chat so we can talk about the details of this project. Looking forward to hearing from you.
$40 AUD in 40 days
5.0 (21 reviews)
6.4
6.4
User Avatar
Hi, Good Day! Let me help you fixing your macro for your excel tool. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$50 AUD in 1 day
4.8 (46 reviews)
5.0
5.0

About the client

Flag of AUSTRALIA
Ballarat, Australia
5.0
3
Payment method verified
Member since Aug 1, 2016

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.