Recent content by Richard Rost

One thing I’ll add is that even in cases where you’re passing values between forms, like using Forms!CustomerF!CustomerID to default a value on another form, you often don’t need the control on the form at all since the field is already in the record source. I’ve tested that myself and it works...

Greetings. :)

My approach is to create an archive table that mirrors the structure of your original table, but change the primary key from an AutoNumber to a regular Number (Long Integer). That way you can copy the original ID values over without worrying about AutoNumber conflicts. Also, make sure the...

The key idea is that the delivery note is a separate business event from the work ticket, so a separate Deliveries table makes the most sense. That is not duplicating the work ticket, it's just recording that a delivery happened for that ticket, along with the delivery quantity, delivery date...

Welcome to the world of Access, Rob. Learning something new in retirement can be both fun and rewarding, and Access is a practical tool for organizing all kinds of projects. I've seen many beginners make great progress just by exploring their own ideas and asking around when they hit a snag. In...

There's a bunch of them out there just Google "Microsoft Access Calendar Template." LLAP RR

Yeah, a student of mine asked me if it was possible to do a Gantt chart in Microsoft Access a few years ago, and I cobbled something together. And it works, but it's a lot of work. And honestly, something like this is better done in Excel. My database is pretty much a proof of concept that you'd...

If all you need is for it to *display* that way, then Minty's suggestion is the easiest route. You can build a report with multiple columns (just like you described), and then embed that report inside a form. The report can handle the top-to-bottom-then-across layout very easily, and it will...

It's exciting to see passion projects like Rubberduck getting full-time attention and proper backing. While it's not quite on the scale of something like twinBASIC, steady progress on community tools is always welcome in the Access and VBA ecosystem.

This is a neat utility concept, and sometimes the simplest tools end up being the biggest time savers in real workflows. I remember making a "scratchpad" form in one of my personal databases years ago to keep track of temporary text snippets, so saving clipboard history feels like a practical...

This topic comes up a lot in conversations with my students these days. Personally, I find AI to be a fantastic sounding board for brainstorming or untangling concepts, but I still rely on my own experience for most of the design and teaching. Tools like ChatGPT and Copilot work best when you...

Greetings! I lurk here myself as well. Been poking around for a few years. But it seems like every time I find a question I can answer, three other people have already answered it lol.

That's pretty nifty. Yes, I said nifty. :)

What exactly do you mean by "show only border?" You only want to see the border around a control based on conditional formatting? Can you be a little more specific? From the screenshot it looks like you are trying to highlight certain rows by showing only a border around them, rather than...

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...