User Profile

Collapse

Profile Sidebar

Collapse
Ed Pisa
Ed Pisa
Last Activity: Jan 21 '11, 04:16 PM
Joined: Dec 6 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ed Pisa
    replied to Insert Command Syntax Error
    in Access
    Thank you everyone for your help I have figured out the problem.

    I needed to add the following code

    Code:
    ds.Tables(0).Rows.Add(dr)
                cb = New OleDb.OleDbCommandBuilder(oAdapter)

                [B][I]cb.QuotePrefix = "["
                cb.QuoteSuffix = "]"[/I][/B]

                oAdapter.InsertCommand = cb.GetInsertCommand()
    ...
    See more | Go to post

      Leave a comment:

    • Ed Pisa
      replied to Insert Command Syntax Error
      in Access
      I have a form in access but the problem is the staff that uses it is not the most technically inclined. Through their clicking it was managed to delete an entire column and lost alot of information. I know that you can sent permissions and what not but I thought by creating an easy to use interface through visual studio 2010 it would help the end user. Thanks for your reply I am just going to have to try try again.
      See more | Go to post

        Leave a comment:

      • Ed Pisa
        replied to Insert Command Syntax Error
        in Access
        Thanks for the advice I will have to try it first thing tomorrow since it is on my desktop at work.
        See more | Go to post

          Leave a comment:

        • Ed Pisa
          started a topic Dataset insert into access database insert into Syntax error
          in Visual Basic .NET

          Dataset insert into access database insert into Syntax error

          Hello,

          I have been working with this problem now for several days. I can delete and Update my data but I can not get it to insert a new record. I receive the syntax error insert into. I am not using any reserved words and I have not been able to find my answer googling like crazy. Any help would be greatly appreciated. below is the code that seems to give me the problem.

          Code:
          ElseIf NEWMODE = True Then
          ...
          See more | Go to post
          • Ed Pisa
            replied to Insert Command Syntax Error
            in Access
            Thanks for the reply. I am using the Oledbcommandbui lder. I think I am just incredibly lost at this point. I am very new to all of this and I have been following several different guides to accomplish my task. I am so close to finishing as it does everything but insert a new record. Do you have any suggestions on a better way to insert a new record that would get rid of this syntax error?
            See more | Go to post

              Leave a comment:

            • Ed Pisa
              started a topic Insert Command Syntax Error
              in Access

              Insert Command Syntax Error

              Hello,

              I have been working with this problem now for several days. I can delete and Update my data but I can not get it to insert a new record. I receive the syntax error insert into. I am not using any reserved words and I have not been able to find my answer googling like crazy. Any help would be greatly appreciated. below is the code that seems to give me the problem.

              Code:
              ElseIf NEWMODE = True Then
              ...
              See more | Go to post
              No activity results to display
              Show More
              Working...