Recent content by Edgar_

Where are my posts in this thread? You guys sure love your censorship.

When I start developing in a VBA-enabled application, the first thing I do is check whether it includes a macro recorder. If it does, I use it to see what code gets generated for typical actions, and then adapt that code to fit my needs. If there's no macro recorder, or if I need to go beyond...

🤷‍♂️ It does what it does, when it does, and vice versa.

I don't know what's the deal with so many people here claiming web = slow, it's not 1995. No idea what sort of web app you've made that was slow, but they are not inherently slow.

Have you given any thoughts to the possibility of moving that application to a web environment?

Assuming you have Activities, Opportunities and Rep Reports as tables or queries, 1. Create a continuous form for each of them, if you don't have them yet. Each form will have its own independent query. 2. Create a blank form 3. Add subforms to the blank form. a) You could drag the 3...

Put this in a module: Public Declare PtrSafe Function SendMessage Lib "user32" Alias "SendMessageA" ( _ ByVal hwnd As LongPtr, _ ByVal wMsg As Long, _ ByVal wParam As LongPtr, _ ByVal lParam As LongPtr) As LongPtr And from your form: Private Sub Command10_Click()...

Does that mean overlap? or maybe one next to the other? What is sloppy? the popup version? the side by side version? the overlapping version? What is it supposed to solve? Why 3 forms? Why exactly 3 and not more?

I haven't confirmed, but I trust your word That's right. It wouldn't detect terms that are split across line breaks. The syntax you showed seems to have consistent character lengths, so I assume something could be programmed to work around that issue. Or, maybe, if one line ends with a quote...

1. Get the value and type of anything that is currently running by using the debugger: You don't even have to know the name of what you're looking for, everything is there for you to explore and start using right away, even undocumented stuff (a lot of stuff is undocumented). Avoid those pesky...

Good catch, I didn't think about that scenario. The SaveAsText output does not split the lines on its own, though, according to a few tests I just did. So, I believe the scenario you're talking about would be entirely on the user. I mean, I would not write like this if I wanted to read it...

Try this function Function FindString(searchTerm As String) As String Dim folderPath As String, line As String, tempFile As String Dim f As AccessObject, r As AccessObject Dim output As String, counter As Long, fileNum As Integer Dim found As Boolean folderPath =...

Gemini can use python, powershell, node and other tools to help you make the access file, add tables, columns, data and other things. It could write the code in external files, for sure. It can't create forms, though, although it can try if you give it the tooling yourself. You could try giving...

I don't know what you're talking about.

Although the system is definitely insecure, it offers a really efficient way to build UIs quickly. Sure, there are limitations, and the UI doesn't exactly meet security standards. But it's still functional enough to get the job done. It's a usable UI in the sense that it lets you interact and...