Search results

  1. D

    Brain has abandoned me - return max date for each unique pair of foreign keys

    Happy whatever you celebrate to everyone! With the quiet holiday weeks I've been making long overdue progress on my EAV-based project, in fact I was hoping to post it for feedback soon, but I realized today I was making a simple mistake somewhere and apparently I've looked at it too many times...
  2. D

    Normalization / Approach question – arbitrary characteristics (ETA: Entity Attribute Value EAV)

    Greetings Access Wizards – been many years since I used Access, started to seem like the right tool again LAST February but then… well, you know, and my work shifted radically. Now things are getting back on track at my desk, so I’m again trying to scrape the rust off my brain. Which leads me to...
  3. D

    Hello, Again!

    I was "here" a long, LONG time ago. At the time, Access was the answer I used for a number of work questions, mostly by the good graces of several members of this forum. I'll jot down the names I remember below. But, then, my work took a turn, and Access was no longer really a part of it. I...
  4. D

    Access control of Word through VBA (error: remote server machine does not exist)

    Hey Gang! I've searched the archives but haven't found this one yet, and the MS KB was entirely unhelpful. I've created a tool to simplify and automate a lot of advance tasks for a touring stage production. In the interest of max flexibility for the end users, several of these tasks revolve...
  5. D

    Stored Parameter Query vs. Built SQL Statement in VBA (FE/BE Environment)

    Dear Assorted Access Gods: I'm (maddeningly) slowly working on my first split FE/BE project. This will be a distributed .mde FE that hooks to an Access BE stored on a web server (via, I THINK, providing the FE with linked tables that point at the server--but I haven't gotten around to...
  6. D

    determining system setting variables (first day of week)

    At that point I suddenly recalled the way we used to figure out if a number was even or not by comparing the results of (number/2) with INT(number/2). At least, I used to use that as a test, back on my C64 :rolleyes: Anyway, using the same idea and a known date (Jan 1, 2001 was a Monday), I...
  7. D

    Personal "Standard Library" Module of often used functions?

    Having been off the forums for a looooong while, I feel the need to get some new discussions going... here's a question for all you guru's out there. Do you have your own "Standard Library" of functions that you have found so useful that you just automatically include them anymore? What are...
  8. D

    ADO version of .nomatch method?

    Hey All - My recent silence has been caused by trying to convert a db from DAO to strictly ADO. All is going fairly well so far, but I've hit a snag and am under deadline pressure... Can anyone give me the skinny on the ADO equivalent for DAO's delightful .nomatch method? Trying to run a...
  9. D

    Easier method to refer to previous record?

    Hey Gang. Well, thanks to the Access World Forum's many helpful members, I'm venturing into coding some VBA, rather than using multiple hidden forms, queries, etc. to create convulted code-free solutions. Here's the latest item to be re-examined, but I haven't spotted the VBA solution yet...
Top Bottom