Ms Access Error 3141
Can I get an error message out of the process? 9 22 22d Access VBA Form - Filter Multiple and/or 7 31 15d How to place a condition in a filter I fixed that, and I now have a seemingly functional process. Rabbit, I have tried re-working the code several ways, all of which produce error messages. I've been looking for missing commas, or brackets I forgot to close, etc, but I haven't had any luck finding anything. this contact form
About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. It takes just 2 minutes to sign up (and it's free!). May 1 '07 #13 reply Expert Mod 10K+ P: 12,110 Rabbit Rabbit, I have tried reworking this. You can't use a non-action query like a SELECT sql statement with DoCmd.RunSQL.
How to use breakpoints for debugging Why did Pondo Baba and Doctor Evazan in the cantina dislike Luke so much? Forgot your password? If you're having a computer problem, ask on our forum for advice. I am not sure i am going about this in the most efficient manner.
May 1 '07 #3 reply Expert Mod 10K+ P: 12,110 Rabbit Post your entire code. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We pdteHaulProdDate is declared as an actual Date and is set to the particular day that I want to display records for. Please help: Error with simple SQL statement P: 31 jverri01 Hi.
Browse other questions tagged sql ms-access-2003 or ask your own question. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find Option Compare Database Option Explicit Public wSort As String Public wField As String Const Sort1 = "SELECT tbl_tmp_Metrics_1yr_Captured_New.Barcode, FROM tbl_tmp_Metrics_1yr_Captured_ATS " Private Sub Form_Open(Cancel As Integer) wField = "Barcode" wSort = All rights reserved.
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. https://bytes.com/topic/access/answers/760425-error-3141-a I am building a process that retrieves a value from a combo box, and based on the value, one of two SQL processes occur. Join the community of 500,000 technology professionals and ask your questions. Join the community of 500,000 technology professionals and ask your questions.
Expand|Select|Wrap|Line Numbers [Loc_Name]='"&Me!Combo12&"'" What is the input box asking you to define? weblink Suggested Solutions Title # Comments Views Activity MS Access VBA Font Text Wrap After So Many Characters 25 31 27d Shell command fails while merging PDF files. In which case you'll have to change query defs or the record source of a form I am trying to build out an IF...THEN Block If response in comboA = X Thanks in advance.
Share Share this post on Digg Del.icio.us Technorati Twitter If posting code please use code tags. Steele" wrote: > Description is a reserved word. May 1 '07 #19 reply P: 31 jverri01 I see nothing wrong with it as long as Combo12 is the name of the control on the main form that calls this navigate here Now, as I initiate the process, any time I choose an option OTHER THAN "-ALL-", the system prompts me with an Input Box, asks for a parameter value for whichever option
See Reserved Words Especially Date and Time for details. You want them to see the results of the SQL much like if you ran it as a query correct? I had this in an old database (A97) and it worked fine.
Exception vs empty result set when the inputs are technically valid, but unsatisfiable Who is the tallest?
Thanks in advance for any little bit of advice you can offer me. What I am doing: I have a Form with 4 combo boxes (call them A, B, C, D) and a command button. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums PC based Database Applications Microsoft Access Runtime error 3141 If this is your Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search
Thanks. The SELECT statement is selecting all fields (*) from the field Prod_Date in table tbl_SponProd. Microsoft Access is a very powerful client/server development tool. his comment is here I will keep that list handy... "Douglas J.
After reviewing my code and trying different things I figured out that it wanted Company/Event to be in brackets. [Company/Event] Thanks for your help though!!! I get a runtime error 3141 telling me my select statement contains a reserved word, misspelled word, punctuation missing or incorrect. I've double checked all spellings, field, table names, ect.
© Copyright 2017 securityanalogies.com. All rights reserved.