Recent content by DimWit

  1. D

    Designing Tables for Ease of CSV Import Updates

    Progress: we're down to "wa." 😁 No, seriously, when I process long enough the mist clears. It's not you, I just have to exercise the frontal cortex in ways long-atrophied. Metaphorically, I'm an old man with a walker in lane 8 of the Olympics Men's 100 Meter event. Your example very nicely...
  2. D

    Designing Tables for Ease of CSV Import Updates

    There's so much good stuff going on in this thread but I stop for a trivial issue. I tried to include the entire link to Doc_Man's 6-year-old post at the top of this thread and when I went to post, I got a message saying it looked like spam. I was able to proceed by removing https : / /...
  3. D

    Designing Tables for Ease of CSV Import Updates

    You make my head hurt--but in a very good way. Old dogs, etc. Thanks much Ken.
  4. D

    Designing Tables for Ease of CSV Import Updates

    Thanks for the insights. My initial port to Access was from an .xlsx file--I initially tried to work in Excel but ran into inconsistent results using vlookup. Coding background: Back in the last millennium I started with VB3 and stepped away from VB6 when it appeared that VB.NET was C#-based and...
  5. D

    Designing Tables for Ease of CSV Import Updates

    In deference to your advanced age (;)) I wanted to make it easy and tried include the full link but when I went to post, it barked about spam. [I hope in 2 years I have a fraction of your memory and recall.] The (up-to-date, complete) export at the end of November was 2.8K rows. But the request...
  6. D

    Designing Tables for Ease of CSV Import Updates

    I'd prefer it be cumulative. Data retrieval was demonstrated to me and the person responsible for retrieving information (a 3rd year law student [lawyer jokes aside, is both intelligent and smart]) had so thoroughly bollixed up the four date selection criteria that it took minutes to gentle...
  7. D

    Designing Tables for Ease of CSV Import Updates

    Thanks plog I started in Excel using vlookup and got inconsistent results appending levels. Plus Excel (what's the technical term? oh, yes) 'sucks' at reports. And, sigh, I understand Access better than Excel [that is a relative comparison]. My goal is to deliver a user-maintainable solution...
  8. D

    Designing Tables for Ease of CSV Import Updates

    Thanks Mark. I'll get back with a few questions if I go this way. Great point about level-creep (don't forget silver, platinum, titanium, lanthanum, cerium, praseodymium, etc. 😁)
  9. D

    Designing Tables for Ease of CSV Import Updates

    (Posted here b/c the referenced post was here--feel free to suggest a different forum) In the planning stage of a database. Background A non-profit wants track member progression through training courses hosted by a third-party Learning Management System. The NP has arbitrarily split courses...
  10. D

    DimWit Intro

    Thanks Doc, I think I'm a wit but my wife often gently reminds me I'm only half right. Dimly so.
  11. D

    Solved Display Image Conditionally

    Thanks for the orientation/mentorship Doc_Man. Props where due. Thanks all!
  12. D

    Solved Display Image Conditionally

    This forum is awesome for the collateral information gained. Thanks @DHookom
  13. D

    Solved Display Image Conditionally

    SUCCESS!!! Thanks, Dave for seeing what I'd missed. Thanks MajP for your correct diagnosis. Thanks ALL for your informed analysis. Where the Null is I'm not sure, but that did the trick.
  14. D

    Solved Display Image Conditionally

    The database is not in use. I inspected the tables and there are no empty records. Some grace requested if it appears I'm getting pedantic, but I want to be sure your words were correctly received. - Checkboxes, LvlnChk, are placed in the same section as the image boxes LvlnImg - LvlnChk...
Back
Top Bottom