VB6 migrate VB2010 Code Snippet
Project ID:
691736Project Type:
FixedBudget:
$30-$250 USD
Project Description:
I need the following two functions originally written in VB6 using DAO 3.5 updated to VB2010 code.Public Function getValue(theTag As String)
Dim mydbM As Database
Dim mydsM As Recordset
Set mydbM = OpenDatabase(app.path & "\myDatabase.mdb")
Set mydsM = mydbM.OpenRecordset("SELECT * FROM IncidentRecords WHERE IncidentObject = '" & theTag & "'", dbOpenDynaset)
If mydsM.EOF = False Then
getValue = mydsM!IncidentText
Else
getValue = ""
End If
mydsM.Close
mydbM.Close
End Function
Public Sub setValue(mySETTag As String, mySETValue As String)
Dim mydsXL As Recordset
Dim mydbXL As Database
Set mydbXL = OpenDatabase(app.path & "\myDatabase.mdb")
Set mydsXL = mydbXL.OpenRecordset("SELECT * FROM IncidentRecords WHERE IncidentObject = '" & mySETTag & " ' ", dbOpenDynaset)
If mydsXL.EOF = False Then
mydsXL.Edit
mydsXL!IncidentObject = mySETTag
mydsXL!IncidentText = mySETValue
mydsXL.Update
Else
mydsXL.AddNew
mydsXL!IncidentObject = mySETTag
mydsXL!IncidentText = mySETValue
mydsXL!IAPOpsPeriod = currentOps
mydsXL!EntryTime = Now
mydsXL.Update
End If
mydsXL.Close
mydbXL.Close
End Sub
Skills required:
.NET, Microsoft Access, Visual BasicPublic Clarification Board
2 messages
-
junworried
Hi, just wanted to let you know that i already have your two functions done. I just need you to clarify where the "currentOps" variable in the setValue function is from. If you are not so sure,please just send me the whole class/code from which the functiona are from. I'll be able to determine where it's from.
Like I said,i have already converted the code.Please choose me and i will deliver the functions within a few minutes.
Thanks!over 1 year ago
-
avisUK
Hi,
Thanks for posting the code. Once I saw them, I started to port to vb2010.
If you are interested, I can send you the vb2010 code and after your review you can pay me. I trust you.
Regardsover 1 year ago
Awarded Bids
All Bids ()
rajtuhin1
|
|
rajtuhin1
From India
Offline
|
US English Level 1 (95%, 71st percentile)
Freelancer Orientation (90%, 100th percentile)
General Freelancer Orientation (90%, 98th percentile)
$30
in 0 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
Easy task for me, I can start ASAP after discussing it in Inbox.
Nirmal2006
|
Nirmal2006
From India
Gold Member
Offline
|
Freelancer Orientation (90%, 100th percentile)
ASP Level 1 (78%, 96th percentile)
SQL Level 1 (90%, 85th percentile)
General Freelancer Orientation (80%, 90th percentile)
$30
in 0 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
Hi I can do it now. Let's start...
HussienSharaf
|
HussienSharaf
From Egypt
Gold Member
Online
|
Freelancer Orientation (85%, 99th percentile)
Foundation EUFreelance.com Member
$40
in 1 day
over 1 year ago
HI,
I m expert in Ado.net and DB Connectivity.
With the new VB2010 , NO SQL Injection
Regards,
Hussien Sharaf
Hi,
I think I can do it:-)!
Best regards,
netcoder:-)
wsh2
|
|
wsh2
From United States
Gold Member
Online
|
$35
in 1 day
$35 Milestone Requested
$35 Milestone Requested
over 1 year ago
Greetings California from Pennsylvania..
I am an acknowledged VB.Classc/VB.Net expert with 25+ years of programming experience.. DAO to ADO.Net conversion.. understood.
Please see PMB.
Respectfully,
B.
servicebenq
|
servicebenq
From Turkey
Offline
|
General Freelancer Orientation (90%, 98th percentile)
Foundation EUFreelance.com Member
$40
in 0 days
$20 Milestone Requested
$20 Milestone Requested
over 1 year ago
Hi
See your pm please
aptecpymefree
|
aptecpymefree
From Colombia
Gold Member
Offline
|
$30
in 100 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
13 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT.
saivisiontech
|
|
saivisiontech
From India
Gold Member
Offline
|
Foundation LimeExchange Member
$30
in 0 days
over 1 year ago
you already know the quality and speed of my work.
accept me to start.
thanks
I have already done the conversion.Please see PMB message. Thanks!
vlopes777
|
|
vlopes777
From Portugal
Offline
|
Foundation EUFreelance.com Member
$30
in 1 day
over 1 year ago
HI there
I'm a programmer with more than 10 years experience using VB6 with MS SQL/ Access and more than 2 years using VB.NET
I'm ready to help you with this
Best regards
hemantgautam
|
|
hemantgautam
From India
Offline
|
$200
in 10 days
$100 Milestone Requested
$100 Milestone Requested
over 1 year ago
I m from India, working with windows, sql server, access, vb6, vb.net,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, ERP solutions runni... more
I m from India, working with windows, sql server, access, vb6, vb.net,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, ERP solutions running successfully at many locations. Also providing hardware and networking support. I can handle this project easily. I am also migrating my present ERP developed under .net 2005 to .net 2010. Upgradations are my regular practice. Please provide me your complete project details so that we can negotiate on final deal. less
mohmrt
|
|
mohmrt
From Indonesia
Offline
|
Foundation EUFreelance.com Member
$30
in 4 days
over 1 year ago
hi,, im experienced for this job.. ready to work for you thanks
Hi,
I am ready to do it. Please let me know if you need more information.
Thanks.
We are a company.
we are a group of resources consists of 6 developers and a graphic designer.
The resources are very technical and experienced in the mentioned field. We have got the experience of successfully compl... more
We are a company.
we are a group of resources consists of 6 developers and a graphic designer.
The resources are very technical and experienced in the mentioned field. We have got the experience of successfully completing number of such desktop and web based projects.
We have got the expertise in Visual Studio 6, .net (both web and desktop) and also graphics designing. So it would suite you to have some designs from use before we get this project so that you can have good idea of our skills.
This is a very small assignment. We will do it in no time for sure.
We will save your money and time and there will be no compromise on quality work because this is our specialty.
I would be grateful to you if you provide us a chance to start our relation with Freelancer with this project.
I can provide you list of projects which we worked on so that you can very well understand the experience we have got from the number of technically sound experience resources.
let me give you some example of the projects we completed to give you brief idea of our work :
1) Time Management System
2) Production Scheduling System
3) Online Shopping
4) Claim Processing System
5) Quote Tracking System
I know this is going to be our first project with Freelancer (Hopefully) but there is always first time and i assure you after this project you will be proudly saying that i am the one who gave this group a chance to work with me and they did never let me down.
Please consider us for this Project , We are new to Freelancer but not new in this field as we have got the experience and experienced resources who can work as team to achieve the required goal and this is what we assure you that deadline, quality and commitment are the things we never compromise.
HAK less
avisUK
|
|
avisUK
From India
Offline
|
Foundation Freelancer.co.uk Member
$250
in 1 day
$125 Milestone Requested
$125 Milestone Requested
over 1 year ago
Already ported your methods to vb.net. Please check you PM for more details
I am ready to start this work.. reply
for fast conversion . please accept me.. and get this done quickly
erwinyudha
|
erwinyudha
From Indonesia
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
please check your pm