Search results

I tried and did it step by step this time. Procedure: 1. Go into the immediate window 2. Type the class name of the form with a problem, followed by a dot to trigger intellisense. The idea is to manually check if there's any element with a weird name. 3. Found 3 elements with weird names. 4. I...

I will try to inspect if there's a solution. I was able to open the arabic file by renaming objects with names written with arabic characters to export and import the form as text. After that, the file worked for me. It's interesting that my samples are causing issues for you, @KitaYama...

I tried, but: Your Excel file has a lot of tabs and it's difficult to understand what you really want to do. You should upload only a tab with the dataset and another with the chart you have problems with. If possible, you should upload an image of what you want to see.

Not sure this is how you should think about it. You should not assume it's reading the internet like a book. It has been trained to respond a certain way based on its parameters, and the responses are always different, which means it's all statistics at play. This is why you should always try...

Whenever I see code I want to use in Access, I adapt it to my style so I can understand it better later. But working with a code sharing tool like this feels different. I see it more like importing APIs for things I don't want to deal with myself. In that sense, I care less about how it was...

@Pat Hartman I'm sorry, but that sounds a lot like a golden hammer, the one size fits all mentality. Forms can be bound or unbound in Access, so that is "THE Access way", by definition.

Absolutely, open source code faces these challenges by default, the important part is that it will let you advance much faster without a lot of bureaucracy and review upfront. That's why it should rely on the feedback of the community. Eventually, the best packages will rise to the top, the bad...

Now that I think about it, it doesn't have to be just for Access. It could cover the entire Office suite and anything else that runs VBA. With help from the Excel community, even though the VBA crowd can be pretty toxic, just like the Access crowd, we'd have a better shot at getting it adopted.

As for how to make it viable, one good starting point would be to reach out to the owners and admins of the different forums and communities where developers already hang out. We could ask for their help to promote the tool and make it visible to as many developers as possible. Even just having...

Or this

Now, since there are a lot of repos hanging out there in the wild, we could integrate them if their license allows it and then let the user claim their authority over it.

I forgot a key aspect to this, we HAVE TO integrate some form of AI in many of the steps. Luckily for us, there's plenty of LLM models out there to help with that. We could, ideally, let the LLM have some context of our environment and let it control it. That would really be the GOAT.

There are a lot of differences between what I'm talking about here and what's currently available today. What we have right now forces us to go hunting for what we really need. You have to dig through forums, blog posts, random GitHub gists, or old articles just to find a simple utility or...

Here's how I envision it. It has three main parts: The centralized registry of packages. The developer or developers who create and publish the package. The developer who will be using the package. Scenario: On a typical day, a developer is working on a form and realizes that a particular...

Yes, that’s exactly what I was referring to. Being able to find and mindlessly integrate stuff without a paywall and with an active community of people improving it and keeping it alive would definitely bring some life to this. @Josef P. I would share some time for that thread, if you're...

It would be nice if we could have all those classes and modules made by others in one place where we can simply select and bring into our development environment. Sort of like npm for NodeJS or nugget within .Net, you would not even need to classify them, you would just search for them and with...

You can use the unbound form, nothing bad is going to happen to your business if you want to show a read-only piece of data. You had to tweak the thing for that to occur, period. The unbound form does not need that extra pattern to be maintained. It laser focuses on presenting the data in a...

And that's a great thing. All other development kits are using frameworks for everything, saving thousands of hours, but nothing is really out there yet for every day Access development, save for a few classes and modules here and there to handle very specific scenarios.

Ideally, the debugger should be your go-to tool when a bug occurs, unless you're following a strict test-driven development approach. It sounds like you might have been expecting a more automated solution that can catch all scenarios. I've come across some tools that aim to do that, vbWatch, for...

I'll consider it. I'm glad you could find some use in it. The devs gave us some handy stuff, it's just not talked about much, but it's there. On top of writing your expressions, you can explore what the contents of an entire object looks like throughout the procedure and add all kinds of...