Search results

Hello all, Can someone expline how I can attach an ADODB Recordset ( backend is SQL) to a form. Here is the code I currently use: Dim conn As New ADODB.Connection Dim CMD As New ADODB.Command Dim strSQL As String Set conn = New ADODB.Connection Set CMD = New ADODB.Command Set ImportRs = New...

I have a combobox with a OnChange event and im calling the following code: Private Sub cbCompanyName_Change() Dim cbo As ComboBox Dim sText As String cbo = Me.Controls("cbCompanyName") 'Set cbo = Me.cbCompanyName sText = cbo.Value 'sText = cbo.Text 'sText =...

I have a form with 6 unbound checkboxes, 6 comboboxes, 1 button in the header and several bound fields in the detail section. When a user clicks the button, VBA code runs that generates SQL based on which critera ( 6 comboboxes ) then the SQL is passed in to the RecordSource of the form and a...