Lukket

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

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 .

Evner: Visual Basic, Excel, Microsoft Access

Se mere: visual basic 6.0 excel database, visual basic read excel file, vb.net read excel file into array, visual basic import excel data, how to connect excel to visual studio 2017, how to connect vb to excel database, visual basic write to excel, vb.net write to excel file, visual basic data mining net forum show, visual basic java dot net sql, project visual basic arabic speaking source code, visual basic cell phone bill code, visual basic 2005 black jack code, visual basic window always top code, visual basic employee information form code, visual basic 2008 myspace bot code, net code comparing excel files, convert visual basic project vb net, convert visual basic project vb net project, creation xlsm excel file vb net code

Om arbejdsgiveren:
( 3 bedømmelser ) Baghdad, Iraq

Projekt ID: #20114117

34 freelancere byder i gennemsnit $154 på dette job

fabest

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 Flere

$90 USD in 7 dage
(90 bedømmelser)
7.3
royalcalif

Let me review the existing spread sheet for the appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your Flere

$30 USD på 1 dag
(105 bedømmelser)
6.2
mtdevil369

I'm very much interested to help you working on this task you having right now. I'm capable to start work it today and complete in any time your required it. Kindly assign me this order. I strongly believe with the ski Flere

$80 USD på 1 dag
(116 bedømmelser)
5.8
srikartiram

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 Flere

$150 USD in 2 dage
(110 bedømmelser)
5.8
vsprybhanu

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 Flere

$200 USD in 2 dage
(72 bedømmelser)
5.5
leemilun

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 dage
(18 bedømmelser)
5.5
sonarkaushik

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 dage
(46 bedømmelser)
5.6
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Need-HELP-thi Flere

$100 USD på 1 dag
(32 bedømmelser)
5.3
whitehorsetechn

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. Pl Flere

$220 USD in 4 dage
(13 bedømmelser)
5.2
xinglong717

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 dage
(12 bedømmelser)
4.3
writingapp

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 visitin Flere

$140 USD in 7 dage
(6 bedømmelser)
3.1
ming87

Hello, Nice to see you. While I read your description carefully, I was excited with feeling that I would be able to satisfy for your requirements in this job. I have rich experience and expertise to develop VB6 project Flere

$30 USD in 7 dage
(6 bedømmelser)
3.0
viswanath28

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 re Flere

$250 USD in 7 dage
(1 bedømmelse)
2.8
godming728

Hi. I always work to get trust from clients. Trust is more important than money for the future. So I work very hard and honestly. As super web expert, my skill is.... VisualBasic6.0/Excel VBA/CSV I have worked for 10+ Flere

$50 USD in 7 dage
(2 bedømmelser)
2.4
pnjadhav

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 dat Flere

$500 USD in 7 dage
(3 bedømmelser)
2.4
sakhawat2

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 dage
(3 bedømmelser)
2.5
nvbishr

I am expert in "VB6", I can do the project, please contact...............................................................................

$220 USD in 2 dage
(2 bedømmelser)
2.5
kipdev13

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 dage
(3 bedømmelser)
2.3
vw1514518vw

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 Flere

$250 USD in 3 dage
(2 bedømmelser)
1.8
johanabradi86

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 tal Flere

$120 USD in 2 dage
(3 bedømmelser)
2.2