Ad:

VB.NET Discussion Thread
Marked Solved
Views: 329

Aug 4th, 2009

access help

Expand Post »

acees 2007 vb 2005
error: "Syntax error in insert into statement"

VB.NET Syntax (Toggle Plain Text)
  m_ColourCount = m_ColourCount + 1
        Dim drNewRow As DataRow = m_ColourDataTable.NewRow()
        drNewRow("CID") = m_ColourCount
        drNewRow("ID") = m_CustomerCount
        drNewRow("Colour Name") = txtColourName.Text.Trim
 
        m_ColourDataTable.Rows.Add(drNewRow)
        m_ColourDataAdapter.Update(m_ColourDataTable)
  m_ColourCount = m_ColourCount + 1
        Dim drNewRow As DataRow = m_ColourDataTable.NewRow()
        drNewRow("CID") = m_ColourCount
        drNewRow("ID") = m_CustomerCount
        drNewRow("Colour Name") = txtColourName.Text.Trim

        m_ColourDataTable.Rows.Add(drNewRow)
        m_ColourDataAdapter.Update(m_ColourDataTable)

Similar Threads

VB: Connect to Access database via ODBC datasource name in Visual Basic 4 / 5 / 6
Disable access to .htaccess in Linux Servers and Apache
Writing to an Access Database in Visual Basic 4 / 5 / 6
Writing to an Access Database using Java... in Java

babbu

Reputation Points: -1

Solved Threads: 23

Posting Whiz in Training

Offline

207 posts
since Jun 2009

Permalink

Aug 5th, 2009

Re: access help

Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.

bcasp

Reputation Points: 23

Solved Threads: 10

Light Poster

Offline

45 posts
since Apr 2008

Permalink

Aug 5th, 2009

Re: access help

How do I post a question!?!
I am being hi-jacked with this message-computer is infected(is not for a fact)
download this tool to keep secure.I did not download anything-I have enough protection.But it won't let me navigate some of my favourite sites.I don't know what to do.Can anyone help me?!?

Last edited by 49thbrat; Aug 5th, 2009 at 1:11 pm. Reason: don't know if I am doing this right.Sorry if I am not.

49thbrat

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Jul 2009

Permalink

Aug 5th, 2009

Re: access help

I am being hi-jacked with a message that says my computer is infected(it is not)This false message says I have to download some tool to fix it.It won't let me navigate my favourite websites. Can someone please HELP ME!!!!!?

49thbrat

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Jul 2009

Permalink

Aug 5th, 2009

Re: access help

Click to Expand / Collapse Quote originally posted by bcasp ...

Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.

tht worked
thnx a ton

babbu

Reputation Points: -1

Solved Threads: 23

Posting Whiz in Training

Offline

207 posts
since Jun 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: simple collision detection

Next Thread in VB.NET Forum Timeline: how do i display data in a listbox by using datasourse

DaniWeb Message

Cancel Changes

User Name
Password