login
Forgot?
Login with Facebook

Don't have an account? Register one now!

VB6 migrate VB2010 Code Snippet

Bids 
21
Avg Bid
$62 USD
CLOSED
  • Project ID:

    691736
  • Project Type:

    Fixed
  • Budget:

    $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 Basic

Project posted by:

e3swing United States
(12 Reviews)

Last seen:

Public 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.

    Regards

    over 1 year ago


If you are the project creator or one of the bidders, please Log In for more options.


Awarded Bids

kakoappa Sri Lanka
kakoappa
Sri Lanka From Sri Lanka     Gold Member     Online
 Accepted
$30 in 1 day 
0
over 1 year ago
5.0

4.5

10 Reviews
90% Completion Rate
please see PM

All Bids ()

rajtuhin1 India
rajtuhin1
India 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
over 1 year ago
5.0

7.2

159 Reviews
83% Completion Rate
Easy task for me, I can start ASAP after discussing it in Inbox.
Nirmal2006 India
logo.jpg
Nirmal2006
India 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
over 1 year ago
5.0

6.5

72 Reviews
93% Completion Rate
Hi I can do it now. Let's start...
HussienSharaf Egypt
Hussien.jpg
HussienSharaf
Egypt From Egypt     Gold Member     Online
  Freelancer Orientation (85%, 99th percentile)
  Foundation EUFreelance.com Member
$40 in 1 day 
0
over 1 year ago
5.0

6.4

54 Reviews
91% Completion Rate
HI, I m expert in Ado.net and DB Connectivity. With the new VB2010 , NO SQL Injection Regards, Hussien Sharaf
netcoder Serbia and Montenegro
netcoder
Serbia and Montenegro From Serbia and Montenegro     Offline
$30 in 1 day 
0
over 1 year ago
4.9

5.9

88 Reviews
80% Completion Rate
Hi, I think I can do it:-)! Best regards, netcoder:-)
wsh2 United States
wsh2
United States From United States     Gold Member     Online
$35 in 1 day 
$35 Milestone Requested
over 1 year ago
5.0

5.2

22 Reviews
86% Completion Rate
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 Turkey
service (Custom) (3).jpg
servicebenq
Turkey From Turkey     Offline
  General Freelancer Orientation (90%, 98th percentile)
  Foundation EUFreelance.com Member
$40 in 0 days 
$20 Milestone Requested
over 1 year ago
5.0

4.9

19 Reviews
65% Completion Rate
Hi See your pm please
aptecpymefree Colombia
Aptecpyme.png
aptecpymefree
Colombia From Colombia     Gold Member     Offline
$30 in 100 days 
$30 Milestone Requested
over 1 year ago
4.6

4.4

12 Reviews
56% Completion Rate
13 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT.
tenshihan United States
tenshihan
United States From United States     Offline
$40 in 0 days 
0
over 1 year ago
5.0

3.9

1 Review
78% Completion Rate
Please see pm.
saivisiontech India
saivisiontech
India From India     Gold Member     Offline
  Foundation LimeExchange Member
$30 in 0 days 
0
over 1 year ago
5.0

3.8

4 Reviews
40% Completion Rate
you already know the quality and speed of my work. accept me to start. thanks
junworried United States
junworried
United States From United States     Offline
$30 in 0 days 
0
over 1 year ago
5.0

3.4

7 Reviews
91% Completion Rate
I have already done the conversion.Please see PMB message. Thanks!
vlopes777 Portugal
vlopes777
Portugal From Portugal     Offline
  Foundation EUFreelance.com Member
$30 in 1 day 
0
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 India
hemantgautam
India From India     Offline
$200 in 10 days 
$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 Indonesia
mohmrt
Indonesia From Indonesia     Offline
  Foundation EUFreelance.com Member
$30 in 4 days 
0
over 1 year ago
hi,, im experienced for this job.. ready to work for you thanks
dhrsolution Canada
dhrsolution
Canada From Canada     Offline
$150 in 2 days 
$150 Milestone Requested
over 1 year ago
Hi, I am ready to do it. Please let me know if you need more information. Thanks.
VectorWares Pakistan
VectorWares
Pakistan From Pakistan     Offline
$30 in 3 days 
0
over 1 year ago
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 India
avisUK
India From India     Offline
  Foundation Freelancer.co.uk Member
$250 in 1 day 
$125 Milestone Requested
over 1 year ago
0.0

0.0

0 Reviews
0% Completion Rate
Already ported your methods to vb.net. Please check you PM for more details
raman6sept India
DSC00216.JPG
raman6sept
India From India     Offline
$130 in 20 days 
0
over 1 year ago
I am ready to start this work.. reply
shikigame Philippines
shikigame
Philippines From Philippines     Offline
$50 in 1 day 
$50 Milestone Requested
over 1 year ago
for fast conversion . please accept me.. and get this done quickly
erwinyudha Indonesia
no_image.jpg
erwinyudha
Indonesia From Indonesia     Offline
  Foundation EUFreelance.com Member
$30 in 0 days 
$30 Milestone Requested
over 1 year ago
please check your pm
kmssharp India
kmssharp
India From India     Offline
$30 in 0 days 
0
over 1 year ago
I have been workin in VB.NET since 4 yrs. Expecting opportunity to show up talent.