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 array arrays basic beginner browser button buttons center checkbox client code convert cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic eclipse excel fade filter forms ftp generatetags gridview html images inline input insert intel internet lib listview mobile monitor net objects open panel passingparameters pdf picturebox port position print printing problem read remove save searchvb.net select serial settings shutdown soap sorting sqlserver survey table temperature textbox timer timespan transparency trim update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms wpf wrapingcode year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC