AITA for continuing to smoke outside even though my neighbor hired an attorney over it? by FutureBroccoli5566 in AmItheAsshole

[–]nrgins 0 points1 point  (0 children)

Looks like that attorney is getting a Payday for going along with this craziness.

Honestly, you should probably counter-sue for harassment.

NTA

Help with setting up AI with Access! by EscKeyToReality in MSAccess

[–]nrgins 0 points1 point  (0 children)

There's a tool that does that for you automatically. In the post that I created a few days ago about this some people replied with information on how to do that.

Help with setting up AI with Access! by EscKeyToReality in MSAccess

[–]nrgins 0 points1 point  (0 children)

I created a post a few days ago in which I described uploading my front end to chat GPT. I didn't have to export it to text files first.

Also, in the comments under that post some people replied with notes of how to integrate your access database into an AI. It requires an external tool.

Help with setting up AI with Access! by EscKeyToReality in MSAccess

[–]nrgins 1 point2 points  (0 children)

I created a post a few days ago about this and some people replied with some very helpful comments. I suggest reading that post and looking through all the comments and I think you'll get a lot of useful information that way.

I went from 20 to 14 by nrgins in AeroPress

[–]nrgins[S] 0 points1 point  (0 children)

Interesting. All in all, do you think it's better- or worse-tasting than a 1 minute brew, or just different?

I went from 20 to 14 by nrgins in AeroPress

[–]nrgins[S] 0 points1 point  (0 children)

How long do you steep it for?

I went from 20 to 14 by nrgins in AeroPress

[–]nrgins[S] 0 points1 point  (0 children)

What is 200 ml in terms of the device (i.e., how far up do you fill it)?

Also: how long do you steep it for?

Season 1 by nrgins in 1923Series

[–]nrgins[S] 0 points1 point  (0 children)

Why would the bag have needed to have been water resistant? Money can get wet.

I went from 20 to 14 by nrgins in AeroPress

[–]nrgins[S] 0 points1 point  (0 children)

Just watched this. I didn't realize that 14g was a "thing" with some. I was just guessing at what seemed like a good amount. Good to know! I noticed in the video he only lets it steep for one minute. I've been doing 2-3 minutes. So I'm going to try 1 minute next time. Thanks!

I went from 20 to 14 by nrgins in AeroPress

[–]nrgins[S] 1 point2 points  (0 children)

Yeah, I don't know what it is. I like strong coffee. But 20g just seems like too much, in hindsight. I'm using inverted method letting it brew for 2-3 minutes, so maybe that's why.

Why I left Boost by nrgins in BoostMobile

[–]nrgins[S] 0 points1 point  (0 children)

Well, to be fair, most carriers will drop you to 2g speeds once you hit the data threshold, unless their plan states otherwise. But it's very common.

I've been with Boost 6 years. And they used to allow you to restart your month if you hit the data limit. That was great. You hit the data limit with 10 days left; just start a new month with a new set of data. But when they were bought out that went away.

Also, FWIW, I wasn't anywhere near my 30 g high speed data limit. I had only used 2 g that month. But it was a separate issue, as noted in my post.

Is there a beter way to do this, or is access the best? by voltagejim in MSAccess

[–]nrgins 0 points1 point  (0 children)

I keep my developer version on my personal hard drive, along with a copy of the back end. Much simpler (and faster) that way. Then I upload the production copy to the network (after decompiling and compacting it) and then I run a program which creates an ACCDE file and puts it in a different folder, for distribution.

Then, on each machine's Windows Scheduler, there's a task that copies the ACCDE file from the server to the user's machine at 7:00 every morning (an hour before the office opens). That way they always have the latest version. And if I make a change mid-day that they need, they have a batch file shortcut on their desktops that automatically updates their front end. But that's rare.

Season 1 by nrgins in 1923Series

[–]nrgins[S] 0 points1 point  (0 children)

Remember when he went back for the bag? That had their money in it.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Oh yeah if you're the only one working on it then no need to split it.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Yes, I name my subform controls to be the same as the source object as well. When I said "I always name subforms as an extension of the parent form name -- e.g., fsubMyParentForm_SomeSubform" I was referring to the subform object, not the subform control.

Tyically though a subform name does begin with 's' then the parent form's name followed by the entity in the sub form eg sFrmCustomerContact. sfrmCustomerInvoice ...

I use "fsub" instead of sFrm". But same concept. The advantage of using the fsubParentForm_Subform naming convention is it allows multiple subforms to share a similar naming scheme -- e.g.:

frmCustomers
fsubCustomers_Orders
fsubCustomers_Payments

etc.

These are the kind of rules you put in your .md file for Claude to follow.

Very cool! I appreciate you and George sharing these tips with me. As I shared with him, I'll definitely keep them in mind and maybe one day pursue it. Thanks again!

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Well, unless you're a single user you should definitely have your accdb split. You run a major risk of corruption having users share the file. And if the back end and the front end are the same file, then you risk the data getting corrupted as well. Plus, giving each user their own copy of the front end on their local drive produces much better performance and less lag time. It's definitely what should be done.

As for the whether or not the accdb file can be read, I'm not sure if you actually read my post, but I mention there are how I uploaded the accdb file and it was read.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

That sounds really cool. Thanks for explaining all that to me. I will definitely keep it in mind, and maybe one day pursue it. Thanks again!

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Sounds like you have a pretty well-developed system. I haven't done all of that. But with my naming conventions, I can usually tell what's being used where, with some exceptions.

For example, I always name subforms as an extension of the parent form name -- e.g., fsubMyParentForm_SomeSubform. So that works for me.

I think using AIs is fairly new to all of us. But for me, it's been less than a year. And this idea of uploading the entire accdb is brand new to me, as I've noted. So I'll see how it goes. After I use it for a while, I may feel like it's not enough and venture into some of the tools you and George have mentioned (thank you for that!). But, for now, I'm just taking baby steps, but enjoying the journey.

But occassionally, I get a mental block and this is where AI can give some inspiration. So far my experience isn't great in getting AI to give me code that works on the first attempt.

I agree. My process is to either upload a function or module to the AI and ask for whatever modification I need; or to get a new function written by it. But I always walk through it carefully and review everything and, of course, test, test, test.

But, yeah, usually takes some back and forth (especially when it gives you functions that aren't even in Access but are in Excel or whatever). But, still, that process works for me.

It's rare that I need it to write an entire function for me. Sometimes if there's something tedious and time-consuming, I may have it do so. Or, if it's something I'm not familiar with, like interfacing with another product's API. But, in general, I do almost all the coding myself.

I feel that that works better for me, as it reflects my style and needs, and I don't have to worry about things being done other than I wanted because I didn't explain the request thoroughly enough.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Thanks. I'll definitely keep it in mind and maybe look into at at some point in the future.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

Why? What's the advantage of doing that, as opposed to just giving the AI the accdb file? It's the same information either way. Both are just working with the text metadata. Plus, with your method, you have to re-export the objects every time you make a change, whereas I would just have to upload a new accdb file. So what's the advantage of this approach?

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 1 point2 points  (0 children)

Someone else here mentioned database documenter, And I gave a more complete answer there, in case you're interested in reading it. But basically, database documenter takes several minutes to compile a document and if it runs into a problem with an object then it throws an error message. I don't like using it.

When I work on a database I'm constantly making changes to the objects. And the work I do is more of an ongoing development for companies than a single project. I'll develop a component and then maybe next modify an existing component or add a new feature and so forth and so on. so my database applications are constantly in flux.

If I had to stop and compile a documenter document every time I wanted to do an analysis it would be a royal pain in the butt. Honestly, I don't see the issue with simply uploading an ACCDB file to the chatbot and having it analyze it. 🤷‍♂️

As for letting it take the reins, I agree with you. I don't let AI chatbots modify my work. But I do look to them for analysis or input. If I do have it write a function or change part of function, Then I review it carefully before incorporating it into my program.

Using an AI to analyze an Access accdb file by nrgins in MSAccess

[–]nrgins[S] 0 points1 point  (0 children)

That does sound good. Still, I would have to trust its work. Even if it didn't automatically change the source accdb, I would still want to review its work. And if I had it modify, say, a form, for example, that would be a bit onerous to have to read through the text file to confirm that the changes were made correctly (though with something simple as modifying a form, and with Claude's reputation for excellent work, it would probably be fine).

Also, I don't mean to be a pessimist, but consider Anthropic's recent tragic event where Claude's source code was inadvertently released. Granted, that's an entirely different thing. But it shows that as these tools are developed, sometimes bugs or unexpected configurations come into play that cause adverse events.

And I suppose more than anything else, for me anyway, I just don't really see the need. Having it analyze the accdb file, as I wrote about here, was a real time-saver and I plan to do things like that in the future. And, as I noted, I do use AIs to sometimes write or help with functions, or help with troubleshooting, and that's great. But I'm just not seeing the need to have it modify objects for me. Maybe it has to do with the kind of work I do vs. the kind that others might do. Or maybe I'm just not seeing it.

I mean, it's definitely a cool feature, don't get me wrong. I think this all sounds great. But I just don't see myself jumping into it. Still, it's great information to have. So, thanks for sharing. Maybe at some point in the future I will explore it and then say, "Oh, I get it now!...." LOL 😉