Search results

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

I don't disagree, but I'm going to opt for marital harmony; I'll let you ask her if we ever meet. She's not on this or any forum.

No discord, we joke that we usually offset each other's votes. There was a ballot question regarding requiring ID to vote and we both agreed on it. She probably didn't get the memo that she was supposed to oppose it. ;) She probably falls into the conservative Democrat bin, but she hates...

My wife went to a Harris rally before the election. In the arrival instructions was (bold theirs, not mine): "To enter, you must provide a government-issued photo ID that matches your name on the check-in list." So you don't need one to vote, just to get in to her rally... :confused:

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.

I use eM Client on my home laptops. Seems to work well for me, I'm not sure what features you're looking for. My needs are pretty basic. I have the free version on one laptop, the paid on another, which lets me have several accounts. The free is limited to one or two if memory serves.

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!

Yeah, I got accused of that during Obama's campaigns (the racist part anyway). You can't just disagree on the policies, it must be because you're racist. :rolleyes:

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