Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: riccaldwell
- Order by date
-
From Data from Word to Access using SQL INSERT INTO
Yep ... rookie mistakes that I'll not make again. Thanks again for all your help!- riccaldwell
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
-
From Data from Word to Access using SQL INSERT INTO
lespaul & SBendBuckeye ... Thanks a million; you really got me going in the right direction. I was still getting the syntax error message and a friend of a friend took a look at the code and found the crux of the problem; I thought I'd pass it on in case it could help others. If you look at...- riccaldwell
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
From Data from Word to Access using SQL INSERT INTO
Great catches! Thanks! In looking at your solutions, I noticed that I also made some very "rookie errors," i.e. omitted a field value that is in my db and didn't exactly match field names. I've ammended the following docmd to the above code, and I am still getting the same syntax...- riccaldwell
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
From Data from Word to Access using SQL INSERT INTO
I am trying to create a survey in a Word form and dump the values in to an Access table. Following is a part of the code from my module to load the responses (in this case only question 1). I get a 3134 "Syntax error in INSERT INTO statement" error on any one of the 3 ways I tried to...- riccaldwell
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
