Results 1 to 9 of 9

Thread: Fetch Data From Access Database Using SQL Only If All The Where Criteria Is Selected

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 08-06-2013, 06:28 AM #1
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    14
    Suggest you post a copy of your spreadsheet and code behind the userform as well as a sanitized copy of your database for testing and analysis

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg. A0opm95t2XEA0q3KshmuuY
    https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
    https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314619#p314619
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314600#p314600
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 03-19-2024 at 01:11 PM.
    Reply With Quote Reply With Quote
  2. 08-06-2013, 06:38 AM #2
    bethrah
    bethrah is offline
    Junior Member
    Join Date
    Jul 2013
    Posts
    12
    Rep Power
    0
    ALMSOURCE for the first option filter everything. Besides that, the rest works perfectly.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Compact and Repair MS Access Database
    By LalitPandey87 in forum MS-Access Tips And Tricks
    Replies: 8
    Last Post: 04-17-2017, 03:41 PM
  2. USD10 To Modify Codes From Access Database To Excel Database
    By bethrah in forum Hire A Developer
    Replies: 4
    Last Post: 07-29-2013, 08:25 AM
  3. Fetch multiple values based on criteria
    By Lucero in forum Excel Help
    Replies: 8
    Last Post: 04-07-2012, 12:35 PM
  4. Fetch Data from multiple sheets based on criteria VBA
    By Raj Kumar in forum Excel Help
    Replies: 7
    Last Post: 03-06-2012, 07:49 AM
  5. Checking Table Exist in Access Database or Not
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 11-16-2011, 04:32 PM

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