Search results

That seems odd, as here in the US their return policy seems pretty good. We have returned items that either didn't work or we just didn't like with no problems. Heck, they make it easy as we can drop off return items at Whole Foods (a grocery chain affiliated with Amazon).

I hope for the best, but I'm not sure what they can do other than point items out. The President doesn't have line-item veto, so as far as I know he can't actually cut any spending. He would need Congress to cut the items, and even Republicans like their pork. :rolleyes:

From Access's point of view it's still a linked table, so I suspect it does. Or you can advise the OP how to get their existing code to work and prove me wrong. Won't be the first time I've been wrong.

From: https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-seek-method-dao You can't use the Seek method on a linked table because you can't open linked tables as table-type Recordset objects. However, if you use the OpenDatabase method to...

Is there a reason you don't run the deletes at the end of the process that creates the report?

It's very inefficient to open a recordset on the entire table and then look for a record. That will be even more of a problem with Azure; you can sometimes get away with it when the tables are local. Most of us would open the recordset on an SQL statement that searched for the specific record...

With the overturning of Roe v Wade, it is determined at the state level. The president has no say, other than signing or vetoing any federal legislation that may come down the pipeline. It was sad hearing about "Trump abortion bans" during the election. Fake news.

Sounds like cascading combos: https://www.baldyweb.com/CascadingCombo.htm

Given the lack of replies, it may help if you can attach a sample db here that exhibits the problem.

Welcome aboard!

Welcome aboard!

Welcome aboard!

Happy to help! Since the form stays open, rather than having your code open it, set the Filter and FilterOn properties as appropriate to the selection.

If the form is already open, change its FilterOn property to False in your code.

I get something similar, a small area of multi-colored blinking lights that over 15-30 minutes grows until I can't see it anymore. No pain or anything, but the eye doc said it was "ocular migraines".

Good job!!

In the change event, you have to use the .Text property: https://www.baldyweb.com/ValueText.htm

Welcome aboard! When you can clarify the issues, feel free to start a thread in the Forms forum.

I had a similar experience trying to learn C#, recommended by our IT guy. I could pass data from/to the SQL Server, but a form/subform situation? It was difficult enough to make me give up. But then I'm an old guy and that's a new trick. :ROFLMAO:

Happy to help!