Results 1 to 5 of 5
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Richmond, VA

    (Partly) Wasted Effort Rant

    Yesterday I spent a half hour detailing a frustrating function failure. It was a dCount function that wouldn't update based on the criteria I was passing it, but it wasn't being flagged with a syntax error either. Domain aggregate functions are a bugaboo of mine with their confusing brackets and quotation marks. I never seem to get them right the first time, but I went at it six ways from Sunday and was getting nowhere. So I came here and painstakingly documented my efforts and formatted my code. I even stayed late to do it and when I tried to publish my topic, my browser crashed. After a brief expletive, I decided to call it a night and start fresh today. I started from scratch again, copied and pasted my code and described the various results. Everything I tried had failed and I was just about to put it in your hands when I made one last attempt to get it right and what do you know? I succeeded. This is not the first time this has happened. The very process of laying out the problem here frequently results in a solution, but the world will never see my well constructed masterpiece with its many iterations of faulty code. As it is, I appreciate this forum and the support I get here. It is a great learning tool and rarely fails to come through when I'm in a pinch. I just wish I'd tripped across my solution much earlier.

    Rant over.
    Last edited by Paul H; 03-30-2016 at 01:01 PM.
    Thanks, Paul

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Ontario, Canada
    Sometimes the solution is to sleep on it. Seriously, I once listened to a fascinating radio program about sleep, deprivation of, dream states, nightmares, the whole gamut. There is a sub conscious area of the brain that processes when the rest of you is "turned off" for the night. Often, when you awake, the solution, or at least a path to it, is passed to the conscious mind without you realizing it. Don't mean to profess a great deal of knowledge on the subject, but that's probably why we have the expression "sleep on it" and I for one, practice it when need be.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Knoxville, Tennessee
    What you need sir. Is a rubber duck.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Ontario, Canada
    That quacks me up! I agree the duck is a better option than a co-worker. Not only will you have the duck's rapt attention, you can throw him in a fit of frustration and he will happily sit there and listen again next time.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL

    Welcome to the club!! You are not alone. Been there.

    PS: It's quite amazing that rubber ducks are so patient.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can I have a rant on a Friday afternoon please?!?!?!?
    By datahead in forum General Chat
    Replies: 4
    Last Post: 08-19-2015, 09:28 AM
  2. Interviewing a database "admin" (rant)
    By Paul H in forum Database Design
    Replies: 0
    Last Post: 02-24-2015, 12:59 PM
  3. Partly sharing database
    By Jamesd1802 in forum Access
    Replies: 7
    Last Post: 08-19-2014, 09:42 AM
  4. Replies: 3
    Last Post: 12-13-2013, 11:22 AM

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 - Senior Forums