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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 |