User Profile

Collapse

Profile Sidebar

Collapse
HTDon
HTDon
Last Activity: Jan 29 '09, 04:22 PM
Joined: Jan 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • HTDon
    replied to Trying to concatenate variable into SQL Statement
    in Visual Basic
    Thanks from across the big pond!

    Worked like a charm, I knew there was one comonation of ' " ] } and )s that I missed!
    See more | Go to post

      Leave a comment:

    • HTDon
      started a topic Trying to concatenate variable into SQL Statement
      in Visual Basic

      Trying to concatenate variable into SQL Statement

      I have the following working SQL in my Function;

      strSQL2 = "SELECT Merch.Loc, Merch.Hub, Merch.Item, Merch.[Total Qty], Merch.[Avg Cost]" & _
      "into TblTemp2 " & _
      "FROM [Merch]" & _
      "WHERE (((Merch.Item)= '1387' ));"


      I want to replace 1387 in the last line with a variable called itm, the string below doesn't work, despite trying about 1000...
      See more | Go to post
      • HTDon
        replied to Function Sample
        in Visual Basic
        Thank You!

        You Mr. Melvin are a gentleman and a scholar!

        Don
        See more | Go to post

          Leave a comment:

        • HTDon
          started a topic Function Sample
          in Visual Basic

          Function Sample

          Hi all;

          I haven't used VBA much since 2007 and am having trouble building a function from a query in Access 2000. Can you point me to a simple function that does this? My current problem is that VBA doesn’t recognize what a Dynaset is in my Dim Statement. I am sure I will have other problems once I get past this so a sample would be the best solution.

          Here is what I got so far, it's not much I know.

          ...
          See more | Go to post
          No activity results to display
          Show More
          Working...