03-02-2010, 06:58 AM #9 MSAccessRookie AWF VIP Join Date: May 2008 Location: Central NJ, USA Join them; it only takes a minute: Sign up VBA Run-time error 3134 up vote 4 down vote favorite The following code creates a SQL string which produces a syntax error http://stackoverflow.com/questions/10593422/vba-run-time-error-3134 I know you can't do that through a single Insert into statement so I read that I should create a transaction and include multiple Insert statements.

You currently have 0 posts. .................................................. ...... Access 2010 Vba Dlookup The best procedure is to start with a very simple version of the query and then adding the other parts step by step while trying it out everytime. Related 382Is it possible to insert multiple rows at a time in an SQLite database?0Insert SQL in VBA got runtime error 31340Access VBA/SQL “Run-Time error '424': Object required”2VBA Error 3134 Syntax How do I directly display a man page?

Access 2010 Vba Case Statement

I did some google searches, but no examples I found really include the "". More hints Why were hatched polygons pours used instead of solid pours in the past? Access 2010 Vba Error Handling Andy One thing that stands out the most for me is that you never declare or define any of your variables, so it is not possible to verify whether all of Access 2010 Vba Open Form Since they are already there enclose each field name with a space in it (ie Last Name) in square bracketes like this [Last Name] Sometimes the Programmer Sometimes the DBA Mazz1

You currently have 0 posts. see here Does Antimagic Field supress all divine magic? Unless you left it out of the sample code (perhaps because your variables are globally defined), You might want to consider defining them. __________________ No one is expected to know everything This is a big no no. Access 2010 Vba Close Form

There is an unbound form that when double clicked, a sub pop-up form comes up with each field for the specific record selected on the main form. If this resolves your issue could you do us a favor and use the thread toos and mark this as resolved. This forum is about taking the next step (or perhaps the next two steps) toward becoming a better Access programmer, and the AWF Forum Members will help you on your journey.To this page An example is the ability to programmatically talk to Microsoft Outlook.

Redefining cases command How could banks with multiple branches work in a world without quick communication? Access 2010 Vba Create Table Thanks. MSAccessRookie View Public Profile Find More Posts by MSAccessRookie « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes

vba ms-access share|improve this question edited Mar 30 '15 at 9:18 Jean-Francois Corbett 23.9k1678113 asked Mar 30 '15 at 8:56 eelc016 1 Can you take a moment to apply

Since you did not include your shared Global definitions in your example, I was pointing out the fact that it was up to you to verify the type of each of But I think it is most likely the trailing final comma before your final closing ) of the inserted values making it look like it wants another field to be inserted. My current issue is with the following code which executes on a button click on an unbound form: Code: Private Sub Command44_Click() Dim query1 As String query1 = "INSERT INTO User Access 2010 Vba Loop Through Recordset Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?

Not the answer you're looking for? Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. strConv is a VBA function. http://axisnice.com/access-2010/access-2010-error-3326.php theory/application: how would someone begin translating a new language?

You'll be able to ask any tech support questions, or chat with the community and help others. INSERT INTO tblItems ([desc], descExtended, itemNumber, currentPrice) VALUES ('APPLE GRANNY SMITH SLI IQF', 'GEMS OF FRUIT', 2050791, 49) or better INSERT INTO tblItems (Descript, descExtended, itemNumber, currentPrice) VALUES ('APPLE GRANNY SMITH I keep getting 3134 run time error on my second insert statement. Tuesday, November 09, 2010 12:54 AM Reply | Quote Answers 0 Sign in to vote Chrsitina Glabas wrote: Dim StrSQL As String StrSQL = "" StrSQL = "INSERT INTO tbl_records FacilityLocation

Full list: Reserved words in Access SQL share|improve this answer edited Mar 30 '15 at 13:09 answered Mar 30 '15 at 9:32 Gustav 12.3k21026 This was exactly the issue! Thank you all so much for your help & quick responses!!! 0 Message Author Comment by:Daisy802010-05-14 All- I like to briefly revisit this as it's a learning opportunity for me. Well if it seems to be real, it's illusion... I would suggest renaming that field and going on as NAME can be a very bad, very bad reserved word to use.

Privacy statement Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy In addition, the order that you reference the columns in the first part of the statement needs to be the same order as in the second part. Or is it something that can be changed somewhere to 'trick' the code into working without all the fields being entered? Sudoers file messed up Redefining cases command Does Antimagic Field supress all divine magic?

Connect with top rated Experts 15 Experts available now in Live! Browse other questions tagged sql vba syntax or ask your own question. Why were hatched polygons pours used instead of solid pours in the past? Peter Doering [MVP Access] Marked as answer by VanderghastModerator Friday, November 12, 2010 9:45 AM Tuesday, November 09, 2010 1:36 AM Reply | Quote 0 Sign in to vote Peter is

SOS View Public Profile Find More Posts by SOS 03-01-2010, 01:04 PM #3 ghudson Newly Registered User Join Date: Jun 2002 Location: USA Posts: Thanks Sometimes the Programmer Sometimes the DBA Mazz1 Reply With Quote Quick Navigation Database Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic try enclosing it in brackets: [Updated?] 0 LVL 119 Overall: Level 119 MS Access 119 Query Syntax 36 Message Active today Assisted Solution by:Rey Obrero2010-05-12 change this part "Updated? = Rewards System: Points or $?

A professor has only proofread my paper. Potion of Longevity and a 9 year old character How do I calculate how many watts of energy I need when camping? function on this forum really does work. More About Us...