+ Reply to Thread
Results 1 to 2 of 2

Still Learning VBA.... My SQL seems off

  1. 12-26-2018, 04:16 PM #1
    richertt
    richertt is offline
    Registered User
    Join Date
    12-26-2018
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    1

    Post Still Learning VBA.... My SQL seems off

    Hello Guys ans Gals,

    I'm new to writing VBA code so please excuse my ignorance. I have been using the same bit of code to extract data from an Access database (three seperate databases). This time, for some reason, it is not working. See below...
    Please Login or Register  to view this content.
    In this instance, I extract the field headers but none of the actual data stored in the tables is being pulled into Excel. I have a feeling there is some error in my SQL. Can anyone help?
    Last edited by Leith Ross; 12-26-2018 at 04:47 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 12-26-2018, 07:39 PM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Still Learning VBA.... My SQL seems off

    Have you tried
    Please Login or Register  to view this content.
    to
    1) if SWONo is a numeric field
    Please Login or Register  to view this content.
    2) if string field
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it worth it to pay for excel classes ? Learning on your own vs in class learning
    By Ephy in forum Excel General
    Replies: 8
    Last Post: 02-12-2020, 02:47 AM
  2. Learning
    By ShashiSuppi in forum The Water Cooler
    Replies: 2
    Last Post: 08-01-2017, 05:54 AM
  3. Hi All Just learning here.
    By Windyz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-01-2016, 01:38 AM
  4. Learning...
    By kand526 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-05-2014, 10:57 PM
  5. Still learning .....
    By Weatherbee50 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2012, 08:49 PM
  6. Learning VBA - Suggestion for Beginners Learning Curve
    By sighlent1 in forum Excel General
    Replies: 1
    Last Post: 08-26-2010, 12:58 PM
  7. Learning VBA
    By motomoto1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2010, 11:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1