Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. #31
    twgonder is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    383

    Quote Originally Posted by Minty View Post
    Think about it logically.

    You are loading a restricted dataset.
    Don't load all of it then filter it if you know the initial filtering - load it with the where clause initially.
    Filter further afterwards. This is not inefficient. It's way more efficient.
    Well silly me, I thought MS would do it in one pass if a filter was active, before doing the actual record source query.
    They do on loading, but not subsequently (at least what I can tell from my testing).
    So, I ended up having to do what you said. Now if that's logical to have two different ways, in a form, of loading data from a record source that has a filter, I'll leave for greater minds to determine.

  2. #32
    twgonder is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    383

    Only three words?

    Quote Originally Posted by CJ_London View Post
    ...as an aside have you heard of Wha3Words? This describes a location anywhere in the world to within a square 3m x 3m

    For example this is an address on a street in Bogota
    https://w3w.co/cucumber.phantom.frame

    This is a location in the middle of the Chingaza National Park

    https://w3w.co/familiar.habituated.rediscover

    Just thinking, with your international aspirations, potentially this provides you with a unique location ID anywhere in the world....
    And to think I was going to use longitude and latitude. When sailing I was just happy to hit the correct 30 meter-wide cove on a twenty-five mile island.
    But I've got to say three words is better than the crazy + system Google came up with. Unless the tree words are limited to English.
    Last edited by twgonder; 12-05-2022 at 04:10 PM.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query with the statement COUNT(*) and WHERE
    By charly.csh in forum Access
    Replies: 7
    Last Post: 09-28-2022, 12:19 AM
  2. Nested Count Iif Statement
    By Topflite66 in forum Queries
    Replies: 3
    Last Post: 02-27-2018, 08:23 AM
  3. Replies: 5
    Last Post: 04-23-2013, 03:22 PM
  4. Count Iif statement
    By seth.murphine in forum Queries
    Replies: 3
    Last Post: 04-23-2012, 12:36 PM
  5. Update Statement in form code
    By ksmith in forum Programming
    Replies: 9
    Last Post: 11-07-2011, 12:04 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
  •  
Other Forums: Microsoft Office Forums