Search results

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

I created a website using Blazor with assistance from Claude. I found it to be a bit confusing for a while, to be honest. But once we got the hang of it, we did pretty well. You're showing the html, which is the interface component. I wrote the code in C#, or rather, Claude wrote my code in C#...

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

<<The most well known app, which begins with S ,is, in my opinion as well, probably not going going to be worth the cost>>

Hi, there might be a slight language problem. We do not need to see a screenshot of just the result. We also need to see a screenshot of the form in design view showing us the actual rule you wrote for the conditional formatting. That's where the problem lies and where we can help you find an...

In my own family tracking database, I've wrestled with the appropriate terminology for roles and relationships for the people involved in households and families. Traditionally, we have talked about marriages consisting of husband and wife and families consisting of spouses and children...