Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim cmd As ADODB.Command Dim strConnect As String Dim ACCOUNT_NUMBER As String strConnect = "provider=sqloledb;Server=RMDB5.campus.com;Database=SS_Pro;Uid=xxxx;Pwd=xxxx;" ' Instantiate the connection object Set cnn = New ADODB.Connection ' Open the connection based on the strConnect connect string arguments cnn.Open strConnect ' Instantiate the command object Set cmd = New ADODB.Command ACCOUNT_NUMBER = Me.SUPPLIER_LOOKUP ' Assign the connection and set applicable properties cmd.ActiveConnection = cnn cmd.CommandType = adCmdStoredProc cmd.CommandText = "sp_qsupp_LOOKUP" cmd.Parameters.Append cmd.CreateParameter("@Account", adVarChar, adParamInput, 10, ACCOUNT_NUMBER) Set rst = cmd.Execute Set rst = Nothing Set cnn = Nothing Set cmd = Nothing
|Can i Import Access Table Into Oracle Using Toad||36||166|
|object variable or with block not set||6||25|
|Access sql to sql server express||10||32|
|I am working on a project management and would like to track the time spent on project task.||10||38|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!