Ms Access There Was An Error Executing The Command
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 03-21-2011, 12:45 PM #1 kessmiller Newly Registered User Join Date: Mar 2011 Posts: 8 Thanks: 2 Thanked 0 Times in 0 Posts What does 'error executing the command' mean? I have a database that I created in Access 2003 that creates a report. The report runs fine when I run it on my computer using Access 2003, but gets and error 'There was an error executing the command.' when I try to run it on another machine running Access 2007. I don't know where to look even to find out what this error means and can't find any posts on it. Which brings up a general question on the search feature on this site... When I try to search for key words error executing command I get all posts with any of these words. Is there an option to search for only posts with all of these words? I see it in the FAQ section, but not here. kessmiller View Public Profile Find More Posts by kessmiller 03-21-2011, 02:54 PM #2 gemma-the-husky Super Moderator Join Date: Sep 2006 Location: UK Posts: 13,140 Thanks: 50 Thanked 885 Times in 857 Posts Re: What does 'error executing the command' mean? i take it you are using the MS switchboard that message is a generic message for any switchboard command that fails maybe the switchboard item isn't set up correctly. maybe the target doesn't exist. maybe the target form/report just didn't open. they all produce a similar cryptic message. i actually modify my switchboard code to provide a more meaningful response. try opening the form/report directly - see if it opens. if it does, then there may be something wrong in the switchboard code. __________________ Dave (Male!) Gemma was my dog if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside. gemma-the-husky View Public Profile Find More Posts by gemma-the-husky 03-22-2011, 06:49 AM #3 kessmiller Newly Registered User Join Date: Mar 2011 Posts: 8 Thanks: 2 Thanked 0 Times in 0 Posts Re: What does 'error executing the command' mean? OK. Big duh moment. I had not installed the ODBC links needed on my users PC. They're on mine, so I didn't think of them. Thanks for pointing me in the right direction. How would I edit the switchboard message
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 19 Oct 2016 08:19:35 GMT by s_ac4 (squid/3.5.20)
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance https://www.experts-exchange.com/questions/26397094/Receiving-the-error-There-was-an-error-executing-the-command.html Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store https://www.reddit.com/r/MSAccess/comments/23scy1/error_executing_the_command_ms_access_2007/ Headlines Experts Exchange > Questions > Receiving the error: There was an error executing the command Want to Advertise Here? Solved Receiving the error: There was an error executing the ms access command Posted on 2010-08-11 MS Access 1 Verified Solution 7 Comments 2,132 Views Last Modified: 2013-11-28 This database began using Access 2000. In 2009, I upgraded to 2007 and because there was no need to buy copies for all PC's, put MS Access Runtime 2007 on the client PC's. Everything ran perfectly until about 4-6 weeks ago when I made a ms access there major change to our inventory table by splitting it into a parent table and a child table as it should have been. Because of this obviously queries and forms had to be updated. Everything works perfectly on my PC but on the PC's using Runtime there are three forms that will not open. The error message is: 'There was an error executing the command' I use the basics of basic code. For example the most elaborate my code gets is: Private Sub RcvROInv_Click() On Error GoTo Err_RcvROInv_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmRcvRO" stLinkCriteria = "[RONumber]=" & Me![RONumber] DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_RcvROInv_Click: Exit Sub Err_RcvROInv_Click: MsgBox Err.Description Resume Exit_RcvROInv_Click End Sub Which is basic. The only other things I do are again simple things like: Private Sub Actual_Weight_AfterUpdate() Me.Weight = Me.Actual_Weight * 1.3 Me.WeightConversion = IIf(Me.Weight < 1, Round(Me.Weight * 16), Round(Int(Me.Weight + 0.9999999999))) Me.WeightConversion = IIf(Me.Weight < 1, Me.WeightConversion, Me.WeightConversion * 16) End
»reddit.comMSAccesscommentsWant to join? Log in or sign up in seconds.|Englishlimit my search to /r/MSAccessuse the following search parameters to narrow your results:subreddit:subredditfind submissions in "subreddit"author:usernamefind submissions by "username"site:example.comfind submissions from "example.com"url:textsearch for "text" in urlselftext:textsearch for "text" in self post contentsself:yes (or self:no)include (or exclude) self postsnsfw:yes (or nsfw:no)include (or exclude) results marked as NSFWe.g. subreddit:aww site:imgur.com dogsee the search faq for details.advanced search: by author, subreddit...this post was submitted on 23 Apr 20141 point (100% upvoted)shortlink: remember mereset passwordloginSubmit a new linkSubmit a new text postMSAccesssubscribeunsubscribe2,330 readers~5 users here nowAll things related to Microsoft Access. ___________________________________________________ New to Access? Check out the FAQ page. Special thanks to /u/humansvsrobots ___________________________________________________ Mark your post "Solved" using link flair when your question has been answered. If you are posting code make sure to indent each line with four spaces. ___________________________________________________ Other subreddits of interest: /r/Excel /r/VBA /r/SQL /r/Database /r/sqlserver created by ---sniff---SQL | Interoperability | VBAa community for 4 yearsmessage the moderatorsMODERATORS---sniff---SQL | Interoperability | VBAScheckschyhumansvsrobotsnrginsaccess düdabout moderation team »discussions in /r/MSAccess<>XSpecific duplica