Search results

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

Given the direction this discussion went, I'm going to preface this with a caveat: I assume this is a legitimate effort to gain access to the data. There is an open source tool called DBeaver, which is sort of a universal database management tool. Think SSMS for dozens of databases. It doesn't...

Re: Decompiling fixes random errors. "Stuff happens; it's Microsoft."

The only thing visible in that screenshot is a layout containing three controls. You can apply gridlines to the layout so that the top, bottom, left side or right side of the cells in the layout are visible. It appears that you have set the gridlines for those cells in that layout to solid. If...

Thank you. The three label controls at the top have borders around them. That's controlled in the property sheet in design view. It would appear the lines between records in the detail section are horizontal lines at the bottom of the detail section.

You know what would help me understand the problem? Attach a couple of screenshots showing your reports in Print Preview and Report View so we can see these gridlines (or the lack of them).