Search results

My mistake. It was not posted by you.

The link you posted doesn't appear to work. Can you try again? I'm not sure what you mean by "...it's a better management system." Please clarify. Also, could you respond to Tom's question in Post #13? Thank you.

I'm not great at extracting relevant details from a narrative. Perhaps, though, if you provide some sample data for each of the tables described, it would help.

I'm afraid that it would be extremely difficult to help you create an "ideal database" without knowledge of the context and circumstances in which it will be used. We can offer suggestions and guidance, as others have done in the previous 14 or 15 posts. Here are some references to resources...

What problem are you trying to avoid or resolve? Thinking through the process: A record is committed to the one-side table via the main form to which it is bound when you leave that main form. Whatever fields have been populated in that table are saved, but if there are no entries in controls...

I am aware of a couple of Access related websites, one of which is based on Wix, the other WordPress. You can see how successful such implementations can be. I have also created a web app built on Blazor, with the assistance of Claude and Chatty, my AI team. That one isn't yet approved by the...

I would treat it as a normal software development project. Leave the current production application alone, except for required maintenance or bug fixes. Treat the new version as a development application, regularly updating data if necessary for testing as you go. Deploy a test version of the...

Although I also know of no good books on Access/Azure SQL, there are a lot of parallels between hosted instances of SQL Server and Azure SQL. You should find a lot more relevant resources by including SQL Server in your research. The main design consideration, IMO, is that Access FEs with any...

We need more specific details before we can offer specific suggestions. It may well be related to how the subform is linked to the form in which it is embedded. Given the circumstances, providing a copy of the database for review might be the most expeditious way to share the information we...

In addition to the suggestions arnelgp offers, you should consider whether you can implement a Power Automate Flow that reacts to a SQL Server table trigger or other event and sends a notification that Access can receive.

Here's another example of the design pattern for forms to manage many-to-many relationships. It's based on songs and musicians, but the logical structure is similar, as is the interface. https://www.gpcdata.com/downloads/MusicandArtistDemo.zip

I agree that GROK is moving ahead of the pack lately. I use Claude first, then ChatGPT for backup/verification. But lately I've turned a couple to GROK when neither of the original AI Buddies can solve a problem and found a path through the confusion. Both Claude and Chatty are prone to...

Interestingly enough, the limitations you have encountered are some of the strongest arguments for using a database, not a spreadsheet, for tasks like this. :unsure:

"100% correct." Professional carpenters drive nails accurately; they always strike nails exactly so that they go into wood smoothly and correctly. Amateur carpenters don't do that. They frequently strike nails at an angle or not quite squarely. The nails bend. So, if you hit the nail on the...

You have been given the answer twice. See post #2 and post #5. This form was created in a newer version of Access. It uses a a control or property that is only available in that newer version. Now you are trying to open the form in an older version of Access which doesn't recognize that...

I agree. It's hard to be excited without the "Before" and "After" versions to compare.

I learned the hard way what Tom warns about. I have used an accdb as a library reference for many years. It includes my error handler. The last time I decided to modify it, I ended up chasing down dozens, if not hundreds, of instances in nearly a dozen databases I use. Never again. Instead, if...

It does occur to me that a significant aspect of this discussion originated in the emergence of the UK's new Online Safety Act as a weapon against unapproved speech.

Join me tonight for a demo of what I like to call "Light-weight Audit Logging" for an Access database application. Using the code co-created with my Claude AI assistant, you can create the objects and code with 3 mouse clicks plus a bit of copy/paste. If you want to try your hand at automating...

Point One: I find that Claude is very good a very high percentage of the time, but every once in a while I get into one of those loops where it recycles variations on a wrong answer. I often break out by asking Grok to analyze and clarify the results I'm getting from Claude. It has been...