Query works in Access, but not VB .NET


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: Query works in Access, but not VB .NET

Threaded View

  1. #1
    Join Date
    Jul 2007
    Posts
    3

    Query works in Access, but not VB .NET

    Hello,

    I'm a relatively new programmer, and I'm attempting to duplicate an Access query in to VB .NET. I expected this to be a simple copy/paste from Access, but that has not been the case. When I attempt to run the following query from Access, I get a ton of records. From VB .NET in a AccessDataSource control, I get nothing. Here's the query:

    <query removed>

    And here's the code (which has worked fine with other queries):

    <query removed>

    Any ideas would be greatly appreciated! I've burned 99% of my brain on this today. Thanks!
    Last edited by Brad Jones; 10-02-2012 at 11:35 AM.

Similar Threads

  1. Replies: 0
    Last Post: 01-07-2003, 03:20 PM
  2. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 01:22 PM
  3. Coding Access in VB
    By Scott in forum VB Classic
    Replies: 1
    Last Post: 05-12-2001, 05:17 PM
  4. Russell Jones
    By Bill Seddon in forum .NET
    Replies: 85
    Last Post: 02-01-2001, 03:49 AM
  5. Replies: 3
    Last Post: 05-12-2000, 05:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center