Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    11

    Unanswered: Syntax Error help!! I'm going insane!

    I run this VBA code and it says that i have a syntax error and that i am missing an operand. ANy ideas?

    SQL = ("UPDATE [Product]" & _
    " SET [Product Name] = Forms![-- DM: Product].[Product Name]" & _
    "[Product Type] = Forms![-- DM: Product].[ProductTypeCombo]" & _
    "[Program Type] = Forms![-- DM: Product].[ProgramTypeCombo]" & _
    "[Basic Price] = Forms![-- DM: Product].[Basic]" & _
    "[Team Price] =Forms![-- DM: Product].[Team]" & _
    "[Early Bird Price] = Forms![-- DM: Product].[Early Bird]" & _
    "[Other Price] = Forms![-- DM: Product].[Other]" & _
    "[Retail Price] = Forms![-- DM: Product].[Retail]" & _
    "[Production Date] = Forms![-- DM: Product].[Production Date]" & _
    "[Production End Date] = Forms![-- DM: Product].[Production End Date]" & _
    "[Date Entered] = Forms![-- DM: Product].[Date Entered]" & _
    "[Date Last Modified] = Forms![-- DM: Product].[Date Last Modified]" & _
    " WHERE [Product Name] = Forms![-- DM: Product].[Product Name]")

    thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    update tableA
    set columnA = 'x', columnB = 'y'
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jun 2004
    Posts
    11
    Thanks! Worked like a charm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •