Search results

  1. A

    is microsoft access still used at your company

    My company still uses it but I think their goal is to get rid off it.:(
  2. A

    Solved Listbox.Recordset - Column Orders

    Thank you!!! it worked!! I assumed you meant Listbox.RowSource. The order is now same as my SELECT statement. Have a great day!
  3. A

    Solved Listbox.Recordset - Column Orders

    Thinking of setting the column values individually instead of using ListBox.Recordset
  4. A

    Solved Listbox.Recordset - Column Orders

    Yes, the order of columns displayed on the listbox. I would love the order of the columns to be the order of the SELECT statement but columns are ordered alphabetically on the listbox. Thanks for your help!
  5. A

    Solved Listbox.Recordset - Column Orders

    Hello Friends, Hope everyone is doing well! I have a listbox on a form that displays data from a ADO recordset. How do we change the order of the columns on the list box? They seem to be ordered alphabetically. Here is the code Dim rs1 As New ADODB.Recordset Set rs1 = New ADODB.Recordset...
  6. A

    Solved Ordering when loop through all the controls on a form

    Thank you! I will mark this as resolved - I wish I could explain this a bit better without creating confusion. Thanks again everyone for helping :)
  7. A

    Solved Ordering when loop through all the controls on a form

    Sorry for the late reply guys. We had some really bad snowy weather here yesterday so I stayed home. Micron should have experienced the weather yesterday. I recall he's based in Ontario Canada too :) From my previous jobs, we always call the boxes on a form "fields" (like the username field...
  8. A

    Solved Ordering when loop through all the controls on a form

    Hello Friends, Sorry for the confusion created. The form is created for users to input values (or insurance quote information) and to return a premium. The entire purpose is to improve the functionality that stores all the values on a quote into a table which allows users to retrieve later...
  9. A

    Solved Ordering when loop through all the controls on a form

    Thank you! I hope they were based on something we could easily control like the tab order :)
  10. A

    Solved Ordering when loop through all the controls on a form

    Thank you friend! We have a form which displays the table that stores these values. Users may open the form and find the record they would like to retrieve so It would be nicer if these values are stored in order. I guess I only need to make sure the columns are in a desired order on that table...
  11. A

    Solved Ordering when loop through all the controls on a form

    Thank you, that sounds like a great plan! Let me try coding that in
  12. A

    Solved Ordering when loop through all the controls on a form

    Dim Fields As Control For Each Fields In Me.Controls If Fields.ControlType = acComboBox Then FieldsOnthisForm = FieldsOnthisForm & "," & Fields.Name & "'" & Fields.Value & "', " End If Next Fields MsgBox FieldsOnthisForm Hello Friends, I am trying to loop through all the...
  13. A

    Solved Referencing a control with a string?

    Thank you for your detailed explanation. I have learned a lot :)
  14. A

    Solved Referencing a control with a string?

    That's very good to know. Thank you!
  15. A

    Solved Referencing a control with a string?

    Wow that was quick! Thanks a lot for your help! It works perfectly. (y)(y)(y) For learning purpose, is there a way to reference a control using a string? Let's say I know that the control name is "CustomerName". How do I reference that control so I can do something like CustomerName.Value =...
  16. A

    Solved Referencing a control with a string?

    Hello Friends! Happy Friday and V-Day! The code below is used to change the value of a field to the next one. (Found on Google or possibly this forum, works pretty well) Private Sub Combo385Scroll() [Combo385].SetFocus If [Combo385].ListIndex <> [Combo385].ListCount - 1 Then...
  17. A

    Solved difficulty when highlighting a variable from a long sql query in VBA editor

    Thanks a lot for your help! Holding shift works pretty well - this is really useful! Double-clicking will certainly help in certain situations(selecting the variable only) but I am usually selecting the quotation marks as well. e.g '" & [Variable A] & "'
  18. A

    Solved difficulty when highlighting a variable from a long sql query in VBA editor

    Hello Friends! Let's say I have a line of code like this below: Set rs1 = New ADODB.Recordset rs1.Open "SELECT * FROM WHERE [Column1] = " & [Variable1] & " AND [Column2]= '" & [Variable2] & "' AND ................[Column10] = '" & [VARIABLE10].Value &", CurrentProject.Connection...
  19. A

    Solved Run Time Error 438 when calling a sub from another form

    Hmm out of top question - Did they remove "mark it as solved" and the button to thank a person?
  20. A

    Solved Run Time Error 438 when calling a sub from another form

    Good morning, Thank you for your input here. The sub I was trying to call didn't have any "Me." but it's good to keep that in mind for future. Allan
Top Bottom