Recent content by Edgar_

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

I typically perform this type of analysis using Excel, as its flexibility and ease of data transformation and visualization make it very convenient. Since you're working with engineering data and large decimal values, it's a good idea to first create a backup of the database and modify the data...

It's most likely the version of Access where I tested it. Not sure, but if a form has to show, it's probably out of my screen.

hello everyone I won't rectify, but I will let you know that attempting to drop the menus down would simply not show anything or let me do anything until I press the escape key I didn't see in the article the methodology to make those hidden tables available, you only mentioned "trickery" as...

Not my doing, but there are a lot of people who write code declaring variables without a type, or even without declaration. People coming from JavaScript, for example, they would happily write VBA code without Option Explicit. Then there's those that prefer their type being defined, and thus...