Search results

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

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

Access may not be functioning as expected in terms of record loading (in forms). I have a continuous form that supposedly loads 1million+ records. When the form is loaded, Access appears to fetch an initial batch of up to 501 records, and additional records are retrieved as I scroll. For...

After some testing, this is the combination of previous format and import format that worked for an english installation of Office. The installation of Office wasn't the culprit, it was the Regional settings of Windows. If the system's date has the MDY format, this code will work: Sub testEng()...