Recent content by Richard Rost

  1. Richard Rost

    Batch file for updating local frontend Access database copy

    That’s an excellent point, and I agree completely about not using code you don’t understand. A batch file can certainly work fine once it’s set up with the proper UNC paths. I was just offering another alternative with a loader database, which can handle updates from inside Access itself. Both...
  2. Richard Rost

    VBA Code to Email using the Free Version of the Outlook App.

    Like IslaDogs said, the free Outlook app cannot be automated. I recommend using CDO (Collaboration Data Objects) instead, which lets you send email directly from Access through SMTP without needing Outlook at all. There are tutorials online that show you how to set this up. If you search for...
  3. Richard Rost

    Batch file for updating local frontend Access database copy

    You don’t necessarily need to go down the batch file route to handle front-end updates. A common pattern I use is to split the logic into two Access databases. The first one is just a small “launcher” file. That’s the one your users actually open. All it does is check the back-end (or a network...
  4. Richard Rost

    Access going away?

    It is very time consuming, but it's something I love doing, so I make the time. 😁 Thanks for the compliment.
  5. Richard Rost

    Access going away?

    Thank you very much
  6. Richard Rost

    Access going away?

    Thanks.
  7. Richard Rost

    Access going away?

    If I had a nickel every time someone asked me this, I'd have... Probably enough for a steak dinner. Not at a high class steak house... Maybe like Outback... But yeah... Probably once a week. I get asked this so much, in fact, I made a video about it. I'd post a link to it, but your forum won't...
Back
Top Bottom