A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

What is wrong with this SQL string?



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 1st, 2004, 07:13 AM
external usenet poster
 
Posts: n/a
Default What is wrong with this SQL string?

Hi guys,

I have a SQL string here that is intended to add the contents of a textbox
into an unrelated table at the click of a button(the table is the rowsource
for the textbox).

DoCmd.RunSQL "INSERT INTO tblLetdownplaces([Place]) VALUES( " & Place.Value
& ");"

When I run this, it brings up a little dialog box asking me for the value of
whatever text I have entered into the textbox.......eg. if I type in ABCD,
it will ask for a value for ABCD. If I enter a value into the text box, it
accepts it and places in the table.

What am I doing wrong?

Thanks guys.

Kenny


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Function isn't available in expressions in query expression Reiner Harmgardt General Discussion 4 July 21st, 2004 09:30 AM
SQL string problem Gary D. Running & Setting Up Queries 6 June 7th, 2004 04:02 PM
SQL string problem Gary D. Using Forms 0 June 1st, 2004 08:45 PM
Question re MailMerge and VB.NET thecoiman Mailmerge 5 May 17th, 2004 04:13 PM


All times are GMT +1. The time now is 01:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.