No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Here is my code: If optName.Value = True Then Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If Me.List1.ItemsSelected.Count = 0 Then[COLOR="Red"][/COLOR] MsgBox "Must select at least 1 employee" Exit Sub End If 'add selected values to string Set … |
|
|
Okay here is my code: If optName.Value = True Then Dim strSQL As String strSQL = "SELECT * FROM Usages WHERE UsageID = " & List2.Text & "" Adodc1.RecordSource = strSQL Adodc1.Refresh Refresh is causing an error in from clause?? I tried setting my adodc1 to an adcmdunknown recordsource, with …
|
|
|
I have created a db in access and an access report which I need to open from a form in visual basic. My vb form contains: 2 calendar controls: I would like the user to be able to select a date range to query for the report. 2 list boxes: … |
|
|
Ok, here goes my first post. I have created a db in access and an access report which I need to open from a form in visual basic. My vb form contains: [U] 2 calendar controls[/U]: I would like the user to be able to select a date range to … |