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"

VB.NET Syntax (Toggle Plain Text) 
  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

Quick Reply to Thread
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
.net .net2008 2005 2008 access account application arithmetic array arrays basic bing button buttons c# center check checkbox code convert crystalreport data database datagrid datagridview date dissertation dissertations dropdownlist excel fade file-dialog filter ftp generatetags google gridview hardcopy images inline input insert intel internet listview mobile monitor ms net networking objects output panel passingparameters picturebox picturebox1 port position print printing problem project read remove save searchbox searchvb.net select serial shutdown soap sorting survey table tcp temperature text textbox timer timespan toolbox trim update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio2008 web webbrowser winforms wpf year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC