Find Jobs
Hire Freelancers

visual basic 6 only not vb.net / code to manipulate excel files using access database

$30-250 USD

Closed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
Hello dear all , this should be done with visual basic 6 only not vb.net I need vb6 forms to manipulate employees informations the A file has 2 columns ( Name , govno - no duplicates - ) 1st form will import the excel (A) which has ( 2 ) columns into the access database , this database is online , after importing is done, a pop-up will ask for 3 informations ( number , date , branch ) each one is the same for all rows , but it will be entered into new 3 columns . after that , a new information ( old Branch ) for each row will be entered manually using datagrid view , , and exporting the file into new excel workbook (should be UTF-8 support) and the empty cell with this (old branch) column should be filled with text ( ok) ., now the file has 6 informations (columns ) , it gets exported into new excel workbook with name ( date + ityman ) the exported file (2nd form ) should be imported into the 2nd form , and should auto - add two new information called ( salary , IBAN ) using one of the columns that are available in another table in the database called (salaryrdba) which has the govno ( employee number ) related with salary ( employee salary ) related with (IBAN ) with the same row i mean . also adds information for each employee and export it into new excel workbook with name ( date + mastercard ) the3rd form should import the 2nd excel file of the form 2 . and filter the excel file using the column (old branch ) , if the text is (ok) then export it into excel file with name ( old branch + date + maneh ) , and if the text is else thing , then export it into excel file with name ( new maneh + date ) the 4th form imports the 3nd file ( new maneh + date ) and , has some conditions based on the salary of each employee , this is new information but it is limited called ( selfa ) ,for example ( if the salary from 300 $ - 500 $ , add 4000000 number for each one with this condition ) ,we will have only like 7 conditions , if no condition met with the row information should fill the cell with text ( Bad salary ) . and filter the excel file using the column ( selfa ) , if the text is (Bad Salary ) then export it into excel file with name ( Bad salary + date + maneh ) , and if the text is else thing , then export it into excel file with name ( final + date ) the 5th form ( check form ) it imports the final excel and checks the IBAN col. relating to a table called (old_maneh) , if no duplicates found then export it with total sum at the end of the column ( selfa ) and add these information each time we use this form into the table ( old maneh ) . but if duplicated found should be exported to another file and deleted from the file . i will have more upgrades for it later , this should be done within 2 days .
Project ID: 20114117

About the project

27 proposals
Remote project
Active 5 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
27 freelancers are bidding on average $168 USD for this job
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$90 USD in 7 days
4.7 (92 reviews)
7.4
7.4
User Avatar
Hello, I'm able to get this done, i can import the excel from and validate the same into VB6 project. I've few questions to ask before i accept the project. Will start the work tomorrow morning (8 hours from now) and will try to give you in the same day. This will be my first priority task ! Awaiting for your most precious reply. Thank you, Karthik
$150 USD in 2 days
4.9 (115 reviews)
5.9
5.9
User Avatar
Hello there, I have gone through your project detail. Surely I can help you. I feel confidence all the skills you required. I will do my best to satisfy you. Let's have a quick chat to discuss it further. Thank you.
$250 USD in 3 days
4.9 (18 reviews)
5.5
5.5
User Avatar
Hi. You need to write many forms. I can write this project in 7 days. Great app writer for your projects. I have writen vb6, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$140 USD in 7 days
4.9 (65 reviews)
5.6
5.6
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$200 USD in 2 days
4.8 (98 reviews)
5.8
5.8
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry ,excel
$155 USD in 3 days
4.6 (46 reviews)
5.6
5.6
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/whitehorsetechn?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Ramesh
$220 USD in 4 days
4.8 (13 reviews)
5.3
5.3
User Avatar
Hello. How are you? I have been developed VBA program like your job. so I will finish your project perfectly. please contact with me.
$200 USD in 3 days
4.8 (13 reviews)
4.4
4.4
User Avatar
I am expert in "VB6", I can do the project, please contact...............................................................................
$220 USD in 2 days
5.0 (5 reviews)
4.4
4.4
User Avatar
Dear sir. Nice to meet you. I read your description carefully. I have good talents and skills of this part. I can give you satisfactory results. I want you to call me. From DragonWarrior...
$150 USD in 7 days
4.6 (5 reviews)
3.0
3.0
User Avatar
Interesting project to work.. having 20+ year of exp in coding visual basic 6 and developed many customised applications.. i can take up this project immediately and will be completed in max 2 days hope you will revert back to me with detailed requirements
$250 USD in 7 days
5.0 (1 review)
2.8
2.8
User Avatar
HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PROVIDED BY YOU. THE TASK WILL BE COMPLETED WITHIN A COUPLE OF DAYS. LOOKING FORWARD TO HEAR FROM YOU AT THE EARLIEST.
$100 USD in 5 days
3.6 (10 reviews)
3.9
3.9
User Avatar
Hi, I'm an expert in Visual Basic 6. I understand that you need this done in 2 days. Please send me the excel file and I can start working immediately. Thank you and kind regards :)
$80 USD in 2 days
4.8 (4 reviews)
2.7
2.7
User Avatar
Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your database design very proficient. I have done lots of split databases with MS Access as Front-end and MS Access/MS SQL/MySQL/Teradata database as back-end. I will show my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc. Please send me message here to discuss next.
$500 USD in 7 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hello, I am professional VB6, VBA, ready to develop what you want You described the process well enough But better design for data structure could be done “finally it will lead to the same result” send me a message to initiate communication and get things done Would be great if you attached sample from the excel and access data “quality and accuracy is directly proportional to price and time” Regards Rageh software development pro.
$250 USD in 3 days
5.0 (2 reviews)
1.8
1.8
User Avatar
Hi! My name is Johana. I make daily work in excel. I'd love to help you. I am trained in the use of Excel, statistical packages, data analysis VBA6. I have the time and dedication to do a good job for you. We can talk privately about every detail necessary. Thank you very much
$120 USD in 2 days
3.5 (3 reviews)
2.2
2.2
User Avatar
Hello Sir! Greetings! I have 8 years of experience as a .net developer. I have experience on your required skills Excel, Microsoft Access, Visual Basic. Kindly open message box for further discussion. Regards, ANIL
$110 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir! Greetings! I have 8 years of experience as a asp.net MVC, dotnet core and desktop application developer. I have worked on your required skills Excel, Microsoft Access, Visual Basic on my previous projects. Kindly open message box for further discussion.
$170 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client, how have you been? I've read your project description carefully. Presenting this proposal with 100% confident. I'm an expert on VB6.0 How about discuss in chat? Waiting for your reply. Best regards.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, High talented Visual Basic, Data Entry, VBA, Access, Microsoft Office, Java, Python and R, C#, C++, QT expert is here! I have read your proposal very carefully and I have come to learn to that job is very suitable for me. As I am a professional Delphi, Python and C# developer, I can do your job perfectly Fast and Perfectly on time. I have 10+ years of experience for Delphi, Python, R, C#, C++ application Development. I have developed several dozens of applications such as OCR, AI, e-commerce, banking, UNESCO census. I understood what you want and want to like to discuss in more detail for your project. I sincerely hope to work with you. If you hire me and give me a chance to prove my abilities, I will give you the best results with my professional skills and will do my best to finish the project successfully. I am sure I can help you. Please see my profile. I am looking forward to your soon reply. Best regards.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of IRAQ
Baghdad, Iraq
5.0
3
Payment method verified
Member since Nov 5, 2017

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.