excel vba odbc error 1004 Cotton Center Texas

CCTV installation, CCTV monitoring, CCTV retrieval, Home intrusion systems, Business intrusion systems, Access control systems Fire alert systems, Floor alert systems, Medical alert systems, Carbon monoxide detection, Locksmithing and Insurance.

Address Frankford Ave, Lubbock, TX 79424
Phone (806) 686-6657
Website Link http://www.aeands.com

excel vba odbc error 1004 Cotton Center, Texas

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 What is the most expensive item I could buy with £50? Why did it take 10,000 years to discover the Bajoran wormhole? You may have to register before you can post: click the register link above to proceed.

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 - 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 The time now is 04:24 AM. Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

I always edit recorded macros eliminating >>>>>> the unecessary items and replace SELECTION with absolute cell references. >>>>>> >>>>>> "CLR" wrote: >>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice go to VBA menu Tools - Options - General - Error > > Trapping. > > > > "CLR" wrote: > > > > > Hi All......... > > > I 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 VB.net CodeBank Visual Basic 6 it's setting the variable once vs setting it 11x and reading it 10x with growing length every time.

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 The bit about strings vs. then put these changes in the > > non-working PC. > > > > Here are things that I think are un-needed > > > > 1) DefaultDir= > > 2) If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate?

Is there something wrong in my format that didn't show up during double digit months? Does this make sense to anyone and how do I proceed. 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! The problem is the way I'm putting the date variable into the array.

When you run 32 bit software, you are automatically directed to the "%SystemRoot%\syswow64\" directory. One thing to check is > the error option in BA. All rights reserved Home Forums Articles Badges Privacy Policy Support Sitemap Newsletter Signup Free Web Developer Tools

418,548 Members | 911 Online Join Now login Ask Question I have literally copied and pasted the sql bit into sql and it works perfectly fine.

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 Here are things that I think are un-needed 1) DefaultDir= 2) DriverId=281 Also make sure all your variables are references the correct path names like newfile2. "CLR" wrote: > Hi Joel........ By default, when you access the ODBC manager, you are using the 64 bit manager. You will see your connection string and SQL.

My CEO wants permanent access to every employee's emails. asked 3 years ago viewed 19814 times active 1 year ago Visit Chat Linked 0 QueryTables.Add application error Related 0excel vba run-time error 1004 - not clear why1Run-time error 1004 when Vaya con Dios, Chuck, CABGx3 "Joel" wrote: > It would help to know which line of code is failing. You may also re-connect the Excel file with the SQL server database.

Type: Print Worksheets("yoursheetname").Querytables(0).Connection This assumes that the query is the first one on that particular sheet, you may need to go up to (1) or (2) if you have multiple queries. I can never run the macro from my computer. Already a member? Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. VBA Visual Basic

Joel said: Recorded macro aren't very robust. When office mate opens it, it works fine (ie all macros run, excel file gets data,). Best Regards, Sally Tang Marked as answer by Sally Tang Wednesday, June 09, 2010 12:47 AM Monday, June 07, 2010 1:25 AM Reply | Quote 0 Sign in to vote If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception.

Here is a summary of the code: cn = "ODBC;Driver={SQL Server Native Client 10.0};Server=serverName;Database=dbName;Trusted_Connection=yes;" sql = "select top 10 * from tableName" Dim S As Worksheet Set S = ActiveWorkbook.Sheets("Medical") With Please post a thread in the appropriate forum. I have a little macro that queries an ACCESS file and returns desired values. It seems to be a conversion issue between what it takes successfully in the CommandText line and what MS Query shows and uses.

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 Register now while it's still free! One thing to > >> > check is > >> > the error option in BA. Not the answer you're looking for?

I would > > remove some unecessary line in the command until you get it to work. > > First > > try on the working computer to eliminate as many Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Registration on or use of this site constitutes acceptance of our Privacy Policy. Thanks to those that responded.