The 10'000 year skyscraper Why cast an A-lister for Groot? Member Login Remember Me Forgot your password? Not the answer you're looking for? I removed the .execute statement and tried to do the DCount: lngCount = DCount([contactID], "myCountQuery") ' count recs in query but now get: Run-time error '2465': Can'f find the field '|' this contact form
Join our community for more solutions or to ask questions. Covered by US Patent. QueryDef.Parameters Thanks very much, I'll see if I can get it to co-operate with those resources you've given me. Find More Posts by mdlueck
Just click the sign up button to choose a username and then you can ask your own questions on the forum. Thank you again Red Flag This Post Please let us know here why this post is inappropriate. Just click the sign up button to choose a username and then you can ask your own questions on the forum. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 6th, 2006,12:35 PM #2 ckib Board Regular Join Date Sep 2005 Posts 219 Okay, I just pulled out
About Us We're a friendly discussion community for Microsoft Office help and support. You may use the OpenRecordset method. How is it packed? Register now while it's still free!
mdlueck View Public Profile Visit mdlueck's homepage! Expression #1 Of Order By Clause Is Not In Select List Join UsClose Log in or Sign up Microsoft Office Forums Forums > Archive > Newsgroup Archive > Access Newsgroups > Access VBA Modules > 3065-Cannot execute select query--why not? The Following User Says Thank You to mdlueck For This Useful Post: SyntaxSocialist(05-08-2013) mdlueck View Public Profile Visit mdlueck's homepage! that post got lost...
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? End Sub Now as a bonus, you have a Public event to "push the button" that even other Forms are able to push programmatically. __________________ -- Michael Lueck Lueck Data Systems Hope This Helps, PH. Please try the request again.
Thanks for any help--this is getting me frustrated. http://www.tek-tips.com/viewthread.cfm?qid=1737835 Microsoft Access is a very powerful client/server development tool. Cannot Execute A Select Query Pass Through I honestly just do not understand the whole "references" thing, and the more I learn, the more apparent it is that I should probably get to know that stuff. Openrecordset Vba Guest, Apr 13, 2004, in forum: Microsoft Access VBA Modules Replies: 7 Views: 299 Rodrigo Apr 13, 2004 Code to execute a make table query Jim Pockmire, Dec 8, 2004, in
This is an old thread. Not the answer you're looking for? In most cases a single, well-chosen newsgroup will do.
SyntaxSocialist View Public Profile Find More Posts by SyntaxSocialist
I have amended my code above to where it is now. Does sputtering butter mean that water is present? Why do I never get a mention at work? his comment is here Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.
Share it with others Like this thread? Why are Squibs not notified by the Ministry of Magic White ring of pus forming around branches Newton's second law for individual forces Were the Smurfs the first to smurf their So how do I make that work? This avoids challenges with properly sending quote characters within string data to be stored in the database table.
So... I've tested it in SQL Server and it runs fine, so I'd like to execute a SQL Server Stored Procedure from the Access application in code. this is really a SELECT query. QueryDef.Parameters If that indeed was the output from variable mySQL, then I spot an unmatched ( with out closing ).
johnve (TechnicalUser) (OP) 18 Sep 14 02:16 Hi, I have written lots of the queries but I'm struggling with this one. Advertisements Latest Threads Excel Hanging - "not responding" - eternal spinning blue wheel Niknam posted Nov 4, 2016 at 12:21 PM How to render HTML inside a Powerpoint slide through VBA Are you aComputer / IT professional?Join Tek-Tips Forums!