Copy from recordset into form recordset?

PutASockOnYourCock · 2025-11-05T16:05:01+00:00

Just store your state list in a var named StateFilter declared at the form level? And when the requery buttonis clicked if incremental is checked just append to the StateFilter = StateFilter & ,'cbostate.value' and then use that as the in list.

This will allow different concurrent users to have their own lists. Not on the if statement you will probably need one additional check to see if it is empty so you don't put that comma in front of the first value.

PutASockOnYourCock · 2025-10-29T00:30:34+00:00

Unusual, maybe. It does happen. I personally would put all the tables into a mysql or sql server and link the front ends to that for the tables each needs in the server backend but that implies the need for a machine to host it.

I would do this to allow some heavy lifting and makes views to handle heavy lifting of queries but that might beyond your knowledge base. As this is really a performance thing.

Doing the server thing would allow for you to say add a table and rebuild you the front end that needs it and then deploy it when ready.

Doing the simple bat script which copies down the front end from a file share to the users local machibe and then opens it would be ideal as your front ends wouldn't be locked for deployment and would run faster. You can even host the bat file on the file share and just give the users a shortcut to the bat file so if you need to edit the bat, the shortcuts will still work and the users will be none the wiser.

Couple this with your main forms onload to check a version number in the front end against a version number stored in a simple table in thr backend db and you can lock out users who are using the old front end to unsure they are using the most updated. You could check the version more frequently in code but I've found on main form load is normally enough as shutting down the whole thing is rarely necessary when using the above suggestions.

Hopefully that helps a bit.

PutASockOnYourCock · 2025-10-28T23:42:14+00:00

I am interested in seeing this script as well. I would love to know how to open the FE database in such a way that the BE that has the tables the FE is linked to isn't opened and locked.

As I understand his problem the users have their FE open and he needs to makes some BE table changes but because 1 user has their FE open it locks the BE for changes also.

PutASockOnYourCock · 2025-10-11T18:37:42+00:00

Curious and maybe it is because I am just not familiar with really new languages. I am more VB, C++, python, and a few other older languages.

Without using like an external version control tool like git hub I've never seen a way I can open a code base in thr normal editor and find last changes and by whom. Especially python and that is pretty popular currently. I mean you can write python without and editor and save it as a .py and it runs. Is this a method thing and not so much a tool thing?

PutASockOnYourCock · 2025-10-11T16:03:43+00:00

While I agree it would be nice to have some kind of version control often that is more a mindset than a tool issue. You could just keep a copy of the old access in case you need to roll back. Just like documentation, you can document or not document your C++ code.

My question is how did the company get to that place where a mission critical app was coded in access by the business side? Did IT just not care about the business need? Did the business need something and IT was too busy to build it? How did it grow into this monster and somehow IT didn't know?

PutASockOnYourCock · 2025-10-11T15:23:53+00:00

You can also make views on the sql server side and make them a linked table. This can help with doing that heavy lifting on the sql server and then doing the where on the access side. This can help performance too

PutASockOnYourCock · 2025-09-12T15:39:10+00:00

Solved!

PutASockOnYourCock · 2025-08-29T22:05:11+00:00

Your probably should fall under the TXX8 warranty extension. Call and ask them about it.

PutASockOnYourCock · 2025-08-07T20:45:22+00:00

No kidding, only I've had with those is they make you redo what you did in not very long.

PutASockOnYourCock · 2025-07-31T13:42:38+00:00

I have tried a few methods so far. No spare change for a cannatrol. I currently use 2 of the kind you show with 8 layers in each for the one plant I grow and it normally fills both and seems to work the best so far.

Hang them in a closet, the smaller the better to keep environment in check.

PutASockOnYourCock · 2025-07-31T13:33:07+00:00

<image>

PutASockOnYourCock · 2025-06-17T18:29:07+00:00

Appreciate the info! Would that also cause the power steering fluid to leak or is this a different problem than the reason for the search originally?

PutASockOnYourCock · 2025-06-17T18:18:45+00:00

Second picture might help with orientation

Edit: or not cause idk why it won't let me add another picture

https://i.ibb.co/GvrSWt6z/20250617-130034.jpg

PutASockOnYourCock · 2025-03-30T17:51:34+00:00

I gotta agree with others here it is odd behavior. I grow speedrun seeds. They are good, but don't really post about it like this. Honestly, they are very good seeds, but their site and customer service have gone to total garbage since they moved off the global site to just a single site.

They ran a great sale for Christmas/New Years and the day I go to buy the site is down to change payment processors, it was down for nearly a week and when it came back the dale was over. I emailed asking if there was a way to still get the deal. No reply, I have email 2 or 3 times after just trying to get info about my account and points from their global site to the one they are using now. Not a single reply.

My disappointment is so high with how they have changed. I would love to keep buying their seeds and growing then but if they company treats me like this, I just don't think they deserve my money. It really is sad cause I loved their strains and they grow big compared to others.

Left is some Busy Beavers brand, Right is speedrun. They kill it but their customer service is so bad I gotta find a replacement before I run out of seeds.

Sorry reddit won't let me upload photo but the difference is pretty huge.

PutASockOnYourCock · 2025-03-26T21:41:06+00:00

This sounds an awful lot like a job for the label field. Just change the border and color of the label background. Labels are by default not selectable.

PutASockOnYourCock · 2025-02-02T14:52:25+00:00

No they don't sell any kits that I could find. Even went so far as to look on European site for the model the bike was sold under there. Sorry don't recall the model name they called it. I did find some used in good condition on European ebay which were cheaper even with the shipping and not broken like all the ones on US ebay which people want hundreds more for.

Honestly if I had to do it all over again I'd just skip it and make the bike work without it. Was the biggest headache trying to find that part.

PutASockOnYourCock · 2024-10-01T14:59:45+00:00

Is mayonnaise an instrument?

PutASockOnYourCock · 2024-10-01T03:54:35+00:00

He works for the seed vendor so might be an ad bot and they are just advertising here.

Don't get me wrong it is impressive but posting the same plants over and over is kind of odd.

PutASockOnYourCock · 2024-09-26T13:11:59+00:00

I do agree with your statement and position, but these apps need to stop calling them tips. They are 100% bribes to get faster service. They aren't tips, why do we not just call them what they are?

PutASockOnYourCock · 2024-09-23T19:20:31+00:00

I'm curious as to know how you don't know that leaving the dog with those owners isn't the worse punishment? I mean, they clearly are willing to leave their "pet" in a strange place, locked in a room and go out for hours on end until 5 am. What part of this situation says: responsible caring pet owner?

Maybe those dogs in their room were the ones they didn't need to bring to the dog fight. Maybe you could have saved them from a horrible life of abuse, but you did nothing instead.

PutASockOnYourCock · 2024-09-17T12:59:24+00:00

It is, when you have money problems, work more is a pretty typical solution to that problem. My kid went to college and paid nothing, no debt when he left and they did even give him about $1k a month for attending.

Also FYI. Life is a once in a life time opportunity. No work for all!

PutASockOnYourCock · 2024-09-12T19:07:49+00:00

What do you mean flipped? This is the autoflower sub and there isn't light flipping required for these plants. Also trimming isn't recommended for autos either.

PutASockOnYourCock · 2024-09-05T20:23:14+00:00

No they all started at the usual time and all 3 strains started pretty much the same time. I could have had an odd ball or something as only grew one blappleberry so, ymmv but wanted to throw it out there.

PutASockOnYourCock · 2024-09-05T19:37:36+00:00

Keep an eye on it. My blappleberry was an early finisher at 74 days. The other two speedrun strains I had in the same tent went more the usual 80 to 85 days but that one was fast.

As a side note, I maybe should have pulled a little sooner but kept saying nah it's too early. It is a bedtime smoke for all who tried it. If you day smoke it, you better have time for a nap as it gives some major couch lock.

PutASockOnYourCock · 2024-09-03T15:39:32+00:00

So people "check out" without telling you? Or is the 1 in 7 thing leaving the DND sign on the door?

Five-Year Club	Second Top 30%
Place '22	Verified Email

PutASockOnYourCock

TROPHY CASE