Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
ADO Set cn = New ADODB.Connection Set rs1 = New ADODB.Recordset cn.Open "Provider=SQLNCLI;Server=10.0.0.10\SQLExpress;Database=FDThomasQC;Trusted_Connection=yes;" rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn, adOpenKeyset rs1.MoveFirst rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value If rs1.EOF Then MsgBox "Not Found" Else 'HOW DO I POPULATE FORM FIELDS HERE? End If
|MS Access Order Form. Auto Fill The Price Control Depending On The Product Control Value||5||28|
|Query to summarise data Like Pivot Table||3||29|
|After renaming tables, queries, forms in a database, VBA doesn't recognize the new names||14||15|
|Simple "INSERT INTO " give "Compile Error - expected end of statement||2||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!