Search results

I don't recommend it. When I tried it, the software crashed a lot and when it "worked", the work wasn't protected anyway. I don't know if they fixed the multiple issues it had. I've had success making an Add-In with VSTO. The distribution of the solution is convenient and it protects your work...

Fair point. I was going to recommend tools in other languages that you can trigger from your Access UI, but if you want to stick to VBA, here's the deal: 1. If IE is working fine for you, that's great! is it making you uncomfortable that it's such an old browser? OK, you still have...

Authentication is only one part of the puzzle, or challenge, depending on who you ask. Security strategies are changing everyday, and it's best not to trust too much. Nothing happens, people say, until something happens. For reference, this website lets you check whether your email has been...

Neat, I can understand despite the language differences, so thank you for clarifying. That is a nice framework indeed, and I can see how it would benefit you in creating new applications. There must be quite a lot of work behind so kudos for that. There really is no problem in you...

Let's suppose you want to build a contacts list. I suppose the first step for you is to open a blank file with the framework prepared, right? The framework items in your file has some code modules, tables for the metadata and forms to define the fields. All is well here, right? The second...

After 100+ posts, the conversation seems to be going in circles, so... like, show a "To Do" app generated by your framework maybe? no idea why forum members think it's impossible to do what you say you did, but you also don't seem to have a clear intent with this thread and it has been alive for...

All right, since you're using Python, I had DeepSeek write a WebSocket for me and it came up with this code: Now all you have to do is run it, I'm already attaching it to this post, though. BUT the idea is to integrate it into MS Access. For that, the first thing you need to do is enable...

WebSockets are servers that need to be deployed somewhere. You can write your own, or let ChatGPT do it for you. Since you're already using Python, you could potentially add the WebSocket feature to the server that is currently managing your calls. I write mine with NodeJS, but there is an easy...

Based on my experience, data macros do not respond to external changes, such as writing to a table through a Python script. The WebSocket approach was suggested because the Python script can trigger the updates via the WebSocket in real time and the browser control can react to those changes by...

WebSockets respond to external stimuli. The legacy browser control supports them with IE11 emulation, and the Edge control should too. The process is as follows: Load web browser control with WebSocket listener. Python script writes to table via ODBC. Python script triggers the WebSocket. Web...

If you really want to use Excel as a CRUD application. You have roughly three options, IMO: 1. Using data models and connections, which is the majority of the Data tab 2. Using list objects 3. Not using list objects With data models, you can import tables from external sources, make queries...

1. Create a Word template, adding you field names in the places where they need to be 2. Open a recordset with your query 3. For each record, open the Word template from Access 4. Run a Find and Replace routine to find your field names and replace them with their values according to your query...

Trigger the code from the popup form and you will get it correctly. I confirm those two events do not trigger.

Add an image control and load a PNG circle.

It seems that you've been struggling, but I doubt the only way to do it is sending a key combination. There must be something else going on, which is why I'm asking for your code, but a reproducible example would be best. I'm not sure what you mean I'm getting a different behavior than the one...

How are you opening your forms? Do you have code trying to set focus on something? If yes, how? if no, why not?

This line caught my attention, so I tried to reproduce that through this I did encounter an error when attempting to retrieve the active form name from the Immediate window while only the popup was open. However, when I added a button within the popup to query the active form, it correctly...

I was copy-pasting from Google's OCR but it didn't read it correctly, when I typed it myself, it worked. OP translated database and it's attached. @Faoineag We're in post #42, the form design has been covered by now, I think you should focus on the database schema that works best for you, I...

The best thing that you can do is learn to use any control from the toolbox from scratch. Subform controls will only ask you for these 3 things: 1. Source Object: the form or report to display 2. Link Master Fields: the field(s) in the parent form that exists in the source object of the subform...

Yes, many times I end up doing it myself, but it's a handy tool. In general, before I submit my prompt, I ask myself how can they use this prompt against me later?