Search results

Thanks for the samples. But those are working only for Non-Multiselect listbox , not working if i change listbox property to Multiselect = sample.

My user wants this functionality, even the sorting order does not matter.

I have a list box contains 10 times . I have UP and Down buttons to move item up and down. My VBA works only if i set listbox multiselect property to 'None'. For the multiselect=simple option it throws error like in valid use of null in this line of code sText =...

Cool........Works Perfect. Thank you so much.

Not specific reason. Is the problem with ADO or DAO?

I'm trying to write record set contents to excel. My query runs perfect in access query wizard, but recordset showing as null. My VBA code Dim cnn As ADODB.Connection Dim recordst As ADODB.Recordset Dim strSQL As String Dim strPath As String Dim appXL As...

To Combine SELECT MyTable.FirstName & " " & MyTable.LastName FROM MyTable

Getting lots of duplicates i.e same records from Q1 and Q2 to Q3. Result seems wrong.

Access says syntax error (Missing operator). I guess we need to give some operator between two left joins? I gave AND it is the same error.

I'm trying to retrieve data based on the contents of one column. sample table Description EID Basecode ----------- ---- --------- ssdad 1001 S2378797 gfd 1002 S1164478 gfdsffsdf 1003...

I have a table (tbl1) contains sample records in Basecode column like S2378797 , R1165778 , W1165778 , N1165778 Description EID Basecode ----------- ---- ---------...

I'm sorry. But it says the form couldnt find or misspelled. when i add the piece of code you specifid.

But how do i call that in access vba

I want to pass a string aPath contains path of the active workbook to access vba module or sub. Below is my excel vba code that will open access db form. How do i pass the string value to access vba. Dim aPath, aDbase, aDSource, aTable, exePath As String Dim fileParam As...

Galaxiom,Could you please give an example

I've a method **querylistboxitems** and i want to call this method in several click events, only difference is listbox,dropdown values change based on the event i call. Public Sub querylistboxitems(lstbox As listbox, dropdown As ComboBox) Dim drpdwnvalue As String drpdwnvalue =...

It is Unbound control. Yes i'm referring control name. My full code inside the onEnter event Private Sub Combo1_Enter() Me.Combo1.RowSourceType = "Table/Query" Me.Combo1.RowSource = "Select F1 from Dropdownvalues " & _ "WHERE F1 <> 'FM'; " End Sub

I forgot to change that name in post. Actually it looks like this Private Sub Combo1_Enter() Me.Combo1.RowSourceType = "Table/Query" Me.Combo1.RowSource = "Select F1 from Dropdownvalues ;"

yeah, OnEnter event of combo1 sets the Rowsource. Private Sub Combo1_Enter() Me.Combo1.RowSourceType = "Table/Query" Me.Select_CM.RowSource = "Select F1 from Dropdownvalues ;"

Not working, i mentioned like this