Search results

For each record in recordset, add user-defined form and recordset.record to user control. What is this thread about?

I googled some of the most active forums on the internet, the best homepage in my opinion was github, but it looks like it was made precisely by "crack" devs, it has a lot of animation and movement (by the way, you can check out framer motion for react, it's dead simple and powerful). The...

Hey Jon, I understand that the website may not have been entirely created by you and that you may have limited control over its features. I also understand that the template may not be fully customizable. However, I want to mention that it's not a big deal for me to go through extra clicks and I...

As a logged-in user, I am presented with a welcome page trying to convince me to join, even though I have already joined the community. This requires an extra step of clicking on the "Forums" tab, and then navigating to either "What's New" or "Watched" to access my relevant content. This adds an...

I never used the What's New tab before, but it looks exactly like what a logged in user should see as the homepage. For what it's worth, I remember utteraccess had a more functional appearance and it currently looks more "modern" with that washed out look, but it's not intuitive, everything...

Both chrome and edge share a similar location. I go to: Edge: C:\Users\USERNAME\AppData\Local\Microsoft\Edge\User Data\Default\Bookmarks Chrome: C:\Users\USERNAME\AppData\Local\Google\Chrome\User Data\Default\Bookmarks Each respective location contains a file without extension called Bookmarks...

Hey Jon. In my opinion there should be two versions of the homepage - one for guests and one for registered users. The two example images you provided look more like what a business would use for its online presence and in my opinion it looks off. This website is well established, so I think...

I encourage you to do stuff in languages you want to toy with. I had it write a custom intent classifier from scratch using BERT in python. It threw errors but it also solved them, so that's AI doing AI, not bad. It's also great to help you learn design patterns and architectures. Needless to...

Anyone not having fun with ChatGPT is missing out. It can do much more than just commenting it, it detects bugs, refactors, translates, etc. On its own, it will give you generic answers first, but if you know your stuff, you can correct it and make it spit out better info.

You guys have some issues... Take some meds or something, that passive aggressive behavior can't be good for your health.

Am I wrong?

I respect that you like using those platforms. I personally like using firebase for my web databases, having google and facebook authentication in my apps, setting up virtual private servers on hostinger, coding with github copilot for rapid development, etc. But I know my preferences today can...

To get the desired output in Access, you can use a combination of a query and a crosstab query. First, create a query that groups the data by Name, Item, and Value_ID, and calculates the sum of the Value column for each group. This will give you a table with the following columns: Name, Item...

It's part of a success story. The client at first only wanted to work in his office. He was saving time because of the Access solution provided, so he decided he could also work "outside" (He visits businesses) using his laptop. But then he hired another guy and databases needed to be in sync. I...

The switch will output the Column Names, I also posted a simpler version and it's similar to yours, if not equal.

Additionally, this will just give you a zero if the column has only nulls, which can be better for doing things in VBA: SELECT COUNT(Id) AS CountOfId, COUNT(FirstName) AS CountOfFirstName, COUNT(SurName) AS CountOfSurName, COUNT(Address) AS CountOfAddress, COUNT(City) AS...

This will also work SELECT IIf(CountOfId = 0, "Id", "") & IIf(CountOfFirstName = 0, ", FirstName", "") & IIf(CountOfSurName = 0, ", SurName", "") & IIf(CountOfAddress = 0, ", Address", "") & IIf(CountOfCity = 0, ", City", "") & IIf(CountOfEmail = 0, ", Email", "") AS empty_columns FROM (...

And this will give you all column names: SELECT 'The empty columns in the table are ' & empty_columns AS result FROM ( SELECT Switch( CountOfId = 0, "Id", True, "" ) & Switch( CountOfFirstName = 0, ", FirstName", True, "" ) & Switch(...

SELECT 'The empty columns in the table are ' & empty_columns AS result FROM ( SELECT Switch( CountOfId = 0, "Id", CountOfFirstName = 0, "FirstName", CountOfSurName = 0, "SurName", CountOfAddress = 0, "Address"...

Oh Access is great. I love the program, it's easy and fast to develop with it. I always do my most complex SQL queries in Access. And it's great for local environments. But if clients need their frontend on the web, then I resort to web. My two most recent bigger scale projects started in...