Search results

I don't think my code is causing that error. It must be something from the main table you created and are trying to link to. Show us everything.

That might be easier with a multi-select listbox rather than a continuous form.

Bear in mind that not everyone will have drives mapped the same. You should use a UNC path if storing on the network.

I use code like the following to move or copy files to destination folders. If a file name already exists it will add a number to the file name like MyFile(1).txt, etc. Public Sub MoveFileRename(SourceFile As String, DestFolder As String, Optional CopyF As Boolean = False) If...

Take a look at FileSystemObject. https://analystcave.com/vba-filesystemobject-fso-in-excel/ Some of the methods you could use: https://analystcave.com/vba-filesystemobject-fso-in-excel/vba-buildpath/ https://analystcave.com/vba-filesystemobject-fso-in-excel/vba-copyfile/...

I believe it is a war crime and has been called out as such. But in simple terms, Two wrongs don't make a right. Regardless of what your opposition does you are still obligated to follow international laws and norms.

Pat, you are awfully violent. I was only responding to your comments to SachAccess. No need for you to put words in my mouth with what you think I think, nor make assertions that I'm anti-semetic. I asked A.I. if Israel targets civilians because you emphatically stated they don't. That was...

reports indicate that Israel has hit civilian targets, resulting in numerous civilian casualties. Key Points: Allegations of War Crimes: Various sources, including UN human rights bodies and organizations like Human Rights Watch and Amnesty International, have concluded that Israeli military...

That's because the bound column is 1 based, unlike the columns which are 0 based.

Just checked and it's still available through the Way Back Machine https://web.archive.org/

I must say I'm having a ball playing around with the controls collection. I re-wrote my Date picker class using the controls collection for the 42 command buttons for the dates. So much less code than before. It's also much easier to set the different properties and methods of the controls...

This example writes file paths to a table with no duplicates

I'm sure you meant "here"

I feel ya too Gasman. I've struggled with this since MajP's challenges a few years ago. Especially the pseudo controls one. It's finally sinking in though so don't give up hope.

In 1937 to 1977 G.E. dumped cancerous PCB's into the Housatonic river and polluted it from the middle of Massachusetts down to Pat's area in CT. The litigation to clean it up started 30 - 40 years ago and is still being litigated. I wouldn't say "easily handled"

https://jwcolby.blogspot.com/2025/05/the-book-event-driven-programming-in.html

The blog link takes me to an onboarding page.

Am I correct in thinking the latest versions are available at these links? If not, where?

john, I'm kicking myself in the ass for not looking through your database that has literally been sitting in the corner of my desktop for about a year and a half. For the longest time I've never been able to wrap my head around using collections of classes to do various things. Woke up this...

Figures it was the first time I used A.I. for code. Probably the last also.