I am migrating a WORD report project from connecting via querying a local MSAccess database to now using a local SQLServerExpress 2008 database.
So far my attempts to write the connection string to SQL and query the table have been unsuccessful
I need remote assistance to write the connection string, and set up a few queries
I want to schedule a time were meet meet via my WEBEX account so we can work together on the project
I need someone who is very experienced with VBA and SQL Server
Please bid for an hour's time and in the message let me know your additional hourly rate via freelancer
here is the old code that I used for the connection and query a table
'open the connection
db = appDirectory & "\[url removed, login to view]"
Set conn = New [url removed, login to view]
Set rs = New [url removed, login to view]
[url removed, login to view] "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & db
.Source = "Select * from TBLClients WHERE CLientID = '" & sClientID & "'"
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockReadOnly
.ActiveConnection = conn
Set rngFound = [url removed, login to view]("EvalDate").Range
[url removed, login to view] rs("assessdate")
Set rngFound = [url removed, login to view]("FName").Range
[url removed, login to view] rs("First Name")
Set rngFound = [url removed, login to view]("LName").Range
[url removed, login to view] rs("Last Name")
13 freelance font une offre moyenne de $44 pour ce travail
Hi, I have more 10 years experience with MS Access and SQL Server, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
Hello. Please check the pm that I have sent you for some important details about this project. I'm a professional VB programmer and database developer.
Dear Sir, Kindly refer to the Private Message for more details. Regards, R. Krishna Prasadh
Dear, i am expert one in VBA,SQL Sever 2000/2005/2008. .NET and over 5 years experience in Application Development, and if you are interested kindly contact.