excel vba run-time error 1004 general odbc error Currituck North Carolina

Address Edenton, NC 27932
Phone (252) 209-7996
Website Link http://www.mackenzieserv.com

excel vba run-time error 1004 general odbc error Currituck, North Carolina

How to get this substring on bash script? Is there a role with more responsibility? Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate

One thing to check is >> the error option in BA. asked 1 year ago viewed 1476 times active 1 year ago Related 2Excel 2013 - 1004 runtime error Refresh Query Table BackgroundQuery:=False4Run-time error '1004' Range.boarders1.refresh BackgroundQuery:=False error 10040run time error 1004 When I held my cursor over 'reportdate' it showed reportdate="exec jpm_tiretrack '12/01/2002', '09/01/2010'"The excel version is 2000 and the server is sql server 2005.Thanks RE: Run-time error '1004' General ODBC Error Thanks to those that responded.

Then I have this very annoying forth, which is causing my a real headache, that goes as follows: strSQL = "Select * strSQL = strSQL & " FROM [XXX].[ABCCustomer] As A" If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

I am passing SQL code to run in the database, and I have tested the SQL code in Access and the query runs fine. How can I get it to keep from being changed? My "Error Trapping" setting is "Break on unhandled errors".....if my User's computer has a different setting could that be the reason? (He's tied up right now so I can't check his If you right click in the cell you should see the refresh option. –AxGryndr Apr 22 '13 at 16:54 It does in 2010, but not in 2007. –lance Apr

then put these changes in the >>>> non-working PC. >>>> >>>> Here are things that I think are un-needed >>>> >>>> 1) DefaultDir= >>>> 2) DriverId=281 >>>> >>>> Also make sure How to solve the old 'gun on a spaceship' problem? House of Santa Claus Removing elements from an array that are in another array Meaning of S. Thank you for your help. > On Friday, November 07, 2008 9:38 AM CL wrote: > Hi All......... > I have a little macro that queries an ACCESS file and returns

If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception. Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! 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 is there any syntax that isn't compatible in 2010? –Matt Feb 3 '15 at 10:46 Is it still timing out even if you remove the On Error Resume Next

What are Imperial officers wearing here? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2009,01:42 PM #7 ChrisM Board Regular Join Date Jun 2002 Posts 2,127 Re: General ODBC Error - Do it in the immediate window (CTL-G) Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 4th, 2009,06:12 AM #9 John Wood Board Regular Join Date Sep Raiders #1 AKA:Gangsta Yoda™ Posts 60,221 Re: [RESOLVED] General ODBC error Thanks for the update but I thought nothing had changed so this would mean you were running it with different

If you're having a computer problem, ask on our forum for advice. How should I interpret "English is poor" review when I used a language check service before submission? But now, I can't even debug. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Here's the code... TIA Vaya con Dios, Chuck, CABGx3 CLR, Nov 7, 2008 #1 Advertisements Joel Guest It would help to know which line of code is failing. This is the error we have got: Run-Time Error 1004, General ODBC error.

RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 16:05 Here is the returned stringODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=PowerYou did NOT return the entire string.Get rid of the Array() functions also! By default, when you access the ODBC manager, you are using the 64 bit manager. Please take my word that the unaltered code has the " at the end. I am facing the similar problem (the one shown below by CLR)..

I always edit recorded macros eliminating the unecessary items and replace SELECTION with absolute cell references. "CLR" wrote: > Hi Joel......... > Well, you saved the day, or week, or several Thanks! All times are GMT -5. facebook google twitter rss Free Web Developer Tools Advanced Search  Forum Programming Languages - More Visual Basic Programming Excel VBA General ODBC Error Thread: Excel VBA General ODBC Error Share

I know that this error is generic and I was hoping that I could get some assistance with what could be wrong with the code. Cyberpunk story: Black samurai, skateboarding courier, Mafia selling pizza and Sumerian goddess as a computer virus With the passing of Thai King Bhumibol, are there any customs/etiquette as a traveler I I almost have this working but I'm getting stuck on this error every time I execute it. How to tell why macOS thinks that a certificate is revoked?

I can never run the macro from my computer. Other than that no other reason. –Matthew Hopkins Nov 27 '14 at 15:43 Just remarque: you are missing closing quotation mark after "Select * which makes the rest of Faq July 23rd, 2013,09:47 AM #4 No Profile Picture eljefe_cendigit View Profile View Forum Posts  Registered User Devshed Newbie (0 - 499 posts)  Facebook Google + Join Date I'm sure someone more intelligent than me will come along and give reasoning behind this, but until then, thats what solved it share|improve this answer answered Feb 4 '15 at 10:49

Reply With Quote Jan 4th, 2011,03:58 PM #5 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. share|improve this answer answered Jul 2 '15 at 13:09 pkk 1 Could you please elaborate on where this should go and what it does? –SuperBiasedMan Jul 2 '15 at When run on the server it doens't throw any errors.ALTER PROCEDURE [dbo].[jpm_tiretrack] (@endd int) AS--Altered to report all trucks11-25-09 /*DECLARE @sDate datetime, @eDate datetime, @startd int, @endd intSET @sDate = '2010-01-01'SET Thanks Minh Monday, June 02, 2014 10:10 AM Reply | Quote 0 Sign in to vote I'm hitting this same issue and you're post is the first one I've found experiencing

You’ll be auto redirected in 1 second. If it ran fine until the 1st of the new year then perhaps its a data issue. Joel said: Recorded macro aren't very robust. Sign up now!

If so nothing more than to keep it easy to read through for colleaques etc. Option Explicit Type StyleType StyleName As String FontSize As Variant FontStyle As String TextBackColor As String RowHeight As Variant ColumnWidth As Variant Alignment As TH Can a Legendary monster ignore a diviner's Portent and choose to pass the save anyway? Join them; it only takes a minute: Sign up Excel 2010: Run time error 1004 general odbc error up vote 0 down vote favorite I have a small Excel 2010 query

Vaya con Dios, Chuck, CABGx3 "Joel" wrote: > It would help to know which line of code is failing. When making the connection to the OLE DB or ODBC data source, Microsoft Excel uses the connection string specified by the Connection property. Register now while it's still free! How to calculate time to empty With the passing of Thai King Bhumibol, are there any customs/etiquette as a traveler I should be aware of?