Search results

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!

Happy to help!

Add a test for a new record: If Not Me.NewRecord Then

You did not declare or set the db variable. You could use CurrentDb instead. Edit: Or the DBEngine(0)(0) that Allen used.