Search results

  1. L

    Using variable in SQL string

    Hi Arnelgp. GREAT THANKS WORKED PERFECTLY FIRST TIME. Just question: Why you used char(34) instead simply " Best regards
  2. L

    Using variable in SQL string

    Nothing. Just Name
  3. L

    Using variable in SQL string

    Hello. I have a PEACE of code looking like that: Dim ElKup1 As String Dim sq As String ElKup1 = (Forms!frmNotInList!Combo6.Column(1)) & " " & Forms!frmNotInList!Combo0.Column(1) sq = "Update tblElements Set ElementName = ElKup1 WHERE ElementName=null;" DoCmd.RunSQL sq When I run the...
  4. L

    How to get index of new entered sorted combo box item

    I think Ihave resolved the problem. You helped me to find out that I don't need indexes. I've used "syntax" like follows Combo0=i where i (as integer) =DMax("[ID]", "tblNames") Thanks to all for help:)
  5. L

    How to get index of new entered sorted combo box item

    No. "Joe" is unbound column. ID of "Joe" is bounded
  6. L

    How to get index of new entered sorted combo box item

    Hello. First time on any forum. I'm not exactly Access user begginer, recently I've started using SQL and some VBA coding. Here is my problem which I'm dealing with for last month. With NotInList event I'd like to add "new item" to combo box and select it programmaticaly like...
Back
Top Bottom