access help

Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Jun 2009
Posts: 143
Reputation: babbu has a little shameless behaviour in the past 
Solved Threads: 14
babbu babbu is offline Offline
Junior Poster

access help

 
0
  #1
Aug 4th, 2009
acees 2007 vb 2005
error: "Syntax error in insert into statement"

  1. m_ColourCount = m_ColourCount + 1
  2. Dim drNewRow As DataRow = m_ColourDataTable.NewRow()
  3. drNewRow("CID") = m_ColourCount
  4. drNewRow("ID") = m_CustomerCount
  5. drNewRow("Colour Name") = txtColourName.Text.Trim
  6.  
  7. m_ColourDataTable.Rows.Add(drNewRow)
  8. m_ColourDataAdapter.Update(m_ColourDataTable)
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 45
Reputation: bcasp is an unknown quantity at this point 
Solved Threads: 10
bcasp bcasp is offline Offline
Light Poster

Re: access help

 
0
  #2
Aug 5th, 2009
Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.
Reply With Quote Quick reply to this message  
Join Date: Jul 2009
Posts: 3
Reputation: 49thbrat is an unknown quantity at this point 
Solved Threads: 1
49thbrat's Avatar
49thbrat 49thbrat is offline Offline
Newbie Poster

Re: access help

 
0
  #3
Aug 5th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Jul 2009
Posts: 3
Reputation: 49thbrat is an unknown quantity at this point 
Solved Threads: 1
49thbrat's Avatar
49thbrat 49thbrat is offline Offline
Newbie Poster

Re: access help

 
0
  #4
Aug 5th, 2009
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!!!!!?
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 143
Reputation: babbu has a little shameless behaviour in the past 
Solved Threads: 14
babbu babbu is offline Offline
Junior Poster

Re: access help

 
0
  #5
Aug 5th, 2009
Originally Posted by bcasp View Post
Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.
tht worked
thnx a ton
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the VB.NET Forum
Thread Tools Search this Thread



Tag cloud for VB.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC