general odbc error excel 2003 West Pima County Arizona

Address Tubac, AZ 85646
Phone (520) 398-8046
Website Link

general odbc error excel 2003 West Pima County, Arizona

Thank you Siv -- Message posted from SKS Reply With Quote 06-22, 05:45 PM #2 Re: Excel VBA - Runtime Error "1004" General ODBC Error I probably shuldn't be responding I would truly appreciate the help. Chebyshev Rotation Why do train companies require two hours to deliver your ticket to the machine? Helpful Excel Macros Format Cells in The Short Date Number Format in Excel - This free Excel macro applies the Short Date number format to a selection of cells in Excel.

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 Is there a way to used the worksheet Name/CodeName as part of the FROM statement without opening the workbook? Counter = 1 qtcnt = 1 RowMax = 100 ColMax = 25 For Each qtc In ActiveSheet.QueryTables qtcnt = qtcnt + 1 Next qtc qttotal = qtcnt qtcnt = 0 cnt Yes, my password is: Forgot your password?

No, create an account now. We have checked that we have the same connections (Data Sources). 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 Reply With Quote Jan 4th, 2011,03:11 PM #4 Baconator View Profile View Forum Posts Thread Starter New Member Join Date Nov 2010 Posts 4 Re: General ODBC error Oh brother!

Thanks to those that responded. 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. To use the 32 bit manager, you must specifically run %SystemRoot%\syswow64\odbcad32.exe. Can you help me please.

Basically, I just set up an ODBC Connection and DataSource using the Control Panel/Administrative Tools. Changing to your solution (or removing the BackgroundQuery altogether), have no affect. within the Excel Questions forums, part of the Question Forums category; This is probably a real generic problem with about a thousand possible causes but I'm going to ask anyway. E-mail: Download Link: Top 15 Excel Tutorials Excel Tutorials Free Excel Macros Keyboard Shortcuts Excel Forum Contact Subscribe for Free Excel tips & more!

When i click on the shortcut, I get an error pop up: Run time error 1004' General ODBC error. By default, when you access the ODBC manager, you are using the 64 bit manager. Now, I got this working on my Laptop (running Excel 2007, however the workbook is an Excel 2002 Document). When we were on XP we were using Oracle 10g, and upgraded with the Windows upgrade.

Any help offered is appreciated, I'm out of ideas. Thanks Reply With Quote Jan 4th, 2011,01:57 PM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. One thing to > >> > check is > >> > the error option in BA. Jan 31 '08 #1 Post Reply Share this Question 5 Replies 100+ P: 491 daniel aristidou Since he said it might be date...which is possible have you checked you computer date

Join them; it only takes a minute: Sign up Excel 2007 - 1004 Run-time error Refresh Query Table up vote 1 down vote favorite It appears that this error is so The program works fine on my computer, but when my user tries to run > it on his computer, (same versoion of Excel, 2000), he gets the following > error. > I tried to transfer the workbook to a coworker and he couldn't get the connection to oracle to work. J.A Coutts When I go to change the shortcut in Data Sources (ODBC).

Data > From Other Sources > From Data Connection Wizard? Last edited by anziga; July 22nd, 2013 at 06:56 PM. I'm also concerned that if the two events happen across midnight the answer will be wrong, so I think I need to add the date value to the time value before Home Questions Office Help Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts Ask a Question Excel Microsoft Word PowerPoint Advanced Search Forum Office & Productivity

Thanks! --Art Ask Your Own Question Change Sql With Vba - Excel Excel Forum I have to change the SQL on hundreds of queries. excel vba odbc runtime share|improve this question edited May 6 '13 at 22:06 Undo♦ 18.4k157399 asked Apr 22 '13 at 16:03 lance 26115 Error 1004 is generic error but Howeverm unable to achieve the sucess. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

My code is as follows: Sub Main() Dim qt As QueryTable, qtc As QueryTable Dim Counter As Double, qtcnt As Double, qttotal As Double Dim RowMax As Integer, ColMax As Integer Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Run Time Error '1004' General ODBC Error Discussion in 'Microsoft Excel Programming' started by Advanced Search VBForums Visual Basic Office Development MsOf03 [RESOLVED] General ODBC error If this is your first visit, be sure to check out the FAQ by clicking the link above. Jeff Jeff Gross, Mar 25, 2009 #1 Advertisements JLGWhiz Guest Since you have several lines commented out, would you like to describe what line 32 looks like? "Jeff Gross" <>

This would also require them to to be values. The time now is 03:04 AM. Thanks! But now, my boss is not able to run the Macro either.

Please take our survey and let us know your thoughts! Results 1 to 3 of 3 LinkBack LinkBack URL About LinkBacks Bookmark & Share Add Thread to del.icio.usTweet this thread Thread Tools Show Printable Version Email this Page… Subscribe to this I'm getting a Run-time error '1004': General ODBC Error. Or if it helps the 2 cells are just This Year and last year (ie.

Share Share this post on Digg Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET CodeBank Visual Basic 6 I'd hoped it was a coding error on my part that involved the year change, but if it is, I can't see it. Thanks.

E-mail: Advertisements General Odbc Error - Run Time Error 1004 Search Excel Forum Posts, Tutorials, Macros, Tips, and More New Excel Help Service! share|improve this answer answered Apr 23 '13 at 1:44 lance 26115 add a comment| up vote 0 down vote Change your property .Refresh BackgroundQuery:=False to be .Refresh. Also check that the network connection...if the file is found over a network.. I have an Excel file with code that generates the following error: General ODBC error The line of code that is generating the error is: Selection.QueryTable.Refresh BackgroundQuery:=False Now, I did not

I appreciate the quick response. Remove Vlookup #N/A Error in Excel How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Exactly as I hoped for. After wasting a whole day in searching internet for the solution, I finally found a solution.

The VBA script seems good because it works fine if the data is going into a regular table instead - no new connections are created and the data in the table I'm getting an error, I suspect because they are stored as strings and not numbers. I tested the ODBC connection and it works fine.