Search results

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

'Start Excel Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True ' Open the file Set ws = xlApp.Workbooks.Add.worksheets(1) With ws.querytables.Add("Text;" & srcFile, ws.range("A1")) .TextFileStartRow = 9 .TextFileCommaDelimiter = True...

Your form has an OrderBy property where you can specify the field or fields to order by. If your form is using a query string as source, you can add the OrderBy clause too.

You can store your forms in an array, collection, dictionary, or custom object. Each option has its quirks. You might even consider creating a custom form store using a class with methods designed for handling multiple form instances. Anyway, it is a lazy Sunday. I am just passing by to suggest...

I'd create a web API that both projects can access and be done with it. If an .accdb file is what I must use, then I'd put the file in a Windows server. That way, if either of the projects sends an HTTP request, the server simply connects to the .accdb file, does its business and returns what...

The ones I've seen come with an endpoint to fetch "now playing" or "popular", they come with pagination parameters, so you can easily browse through them. They also come with endpoints to search by title, year, genre, etc. You don't really need a db for that, because a browser control can simply...

Sorry about that, I merely tried to replicate OP's screenshot the best I could. In a real world scenario, it would probably be better to utilize one of the REST APIs out there and a web browser handles that much better than Access' built-in tools.

I know you're trying to learn, but if you get stuck, this file could help. I'm doing the no-seasons table approach here.

Tabbed docs ftw. 💅 Edit: tabs not relevant

That's my regular LLM experience

Well, the internals of Access are in english and Access is an ancient application that has not received a lot of love by its developers, so I believe it is my obligation to test that kind of thing after the testing done and shown in post 21. I'll check what happens if I change locale.

I changed the application's language to Japanese and Arabic, and I was able to open the FormBotoes.accdb file without any issues the same way I was able to open it using the regular english version and the spanish version. In Post 21, my main point was that I successfully used the arabic file...