Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. #31
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    644
    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 Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    644

    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