• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. C

    Automate Compact/Repair

    Ha yes, I understand. I had assumed each user has a local FE that links to server BE i.e., no one is sharing FE (I should stipulate this architecture assumption). Agreed that there's generally no reason to C&R FE. FE users DO NOT use such an admin tool: thus the name "Admin Compact DB tool". I...
  2. C

    Automate Compact/Repair

    What do you mean by "shared" in this case? Shared across front-ends? Across users? Across back-ends? I'm not sure I see the issue you're referring to so please educate me pls
  3. C

    Automate Compact/Repair

    I hear you, that's why by default the tool looks into the current folder and that's the way it should be used. But since users can change the folder I can see how the cross-computer issue might happen; in hindsight I'm thinking I shouldn't let users change the folder and this issue would never...
  4. C

    Automate Compact/Repair

    Gosh, I have to imagine I'd tinkered with that without noticing it's impact. Thanks so much.
  5. C

    Automate Compact/Repair

    Tool to let your clients compact themselves I couldn't find a general tool to let clients perform compact/repair on their own, so I made one that I'm happy to share and get your feedback. I've got it running at one client's site but there surely somethings I could improve. Hope this helps...
  6. C

    Drag and Drop Outlook Emails to Form and Save it Windows Explorer Specific Folder

    Disclaimer: I love drag & drop, I think it makes UX sense. This being said, my current position is that it is generally not worth the complexity and reliably issues to implement in Access, but I could be wrong obviously. I researched and developed drag & drop from Win Explorer a few months...
  7. C

    Automating FE updates

    Hi Spud, I just spent some time with this last week: used the following insightful post https://www.access-programmers.co.uk/forums/threads/auto-updater.303898/ , which I assume you'd read. As per your specific question: I had similar issues and it came down to have a time delay between the...
  8. C

    Hope to contribute

    That's usually the way of things, its all about appropriate use in the right context. I appreciate the welcome, ty
  9. C

    Hope to contribute

    I generally agree...SQL is and should be easy. I'm often torn between building a long fancy SQL string vs. using the clarity provided by the Access VBA recordset and its methods...I like a powerful SQL string but it's awful ugly in your code...the recordset object makes better looking code but...
  10. C

    Hope to contribute

    Started out doing strictly Access QBE queries but I taught undergrad Intro Databases and had a T-SQL contract so I got the chance to hone my SQL skils...but always more to learn. Happy to share given how much I've learned from these types of communities.
  11. C

    Hope to contribute

    Good question: I'd say I enjoy making useful UX's but I'm full-stack so I do it all...some things better than others obviously. I can model anything with tables and relationships (i.e., ERDs), I can do anything I want in SQL but Access doesn't do CTEs so I tone it down in there, love VBA for...
  12. C

    Hope to contribute

    My clients and I are using Access for Office 365
  13. C

    Hope to contribute

    Hi, I was "forced" to learn Access development back in 1995 with Access 2.0. Since then, other techs have come and gone, Access and Office Dev is the one constant throughout my career so far. I would have never predicted. Looking forward to sharing Access and database knowledge folks!
Top Bottom