Recent content by Dave E

It appears from outside the US that MAGA means making trouble.

Now tell me, Pat, was that before or after the Israelis were pushing out the Palestinians to make room for an expanded Israel? I see no difference in the two tribes fighting each other except one has power and persuasion in the US and one doesn't. I don't see anyone trying to push the Iranians...

It matters not, Pat, what you and I think is right. The fact that we've had this conversation, and acknowledge the world's disapproval of Israel's attempt at genocide, whilst carrying on with their sneaky settlers illegally clearing and living outside of their state, means that the tide is...

And Israel is different,how?

Your comment speaks volumes. Neither side may want a two state solution but both sides want to eradicate each other. It could be a solution with a short-term demilitarised zone to stop them killing each other. It sort of works in Korea. As long as the Jews believe they are the chosen ones, there...

Increasingly, the West agrees. There is more support for the Palestinians than the Jews, these days.

Israel are seen, more and more, in the West, as a Tyrant state. They have, since 1948, intimidated and killed Palestinians to force them off the land they've lived on for generations. to allow their own borders to expand. It makes Hamas's incursion seem small by comparison, over time. Netanyahu...

Thanks for that. It is an interesting routine and I will take it away and try it out. Dave E

I tried your idea of changing Name to VBA.Name without success. These two lines were typed in and the newname has a missing backslash for the newname. That oldname (that which is stored in the db) has been used, in the syntax shown above, without error, for many years.

It isn't about the error message so much as the strange appearance of the table's name over the Statement.

The query for the table "ImageTest" is: SELECT ImageTest.Tot, ImageTest.ID, ImageTest.LatinName, ImageTest.Picture, ImageTest.Corrected, ImageTest.Correct FROM ImageTest ORDER BY ImageTest.Tot; Hmm...there is a slash after the C:

It works with all the filenames that use single apostrophes and have plantname and stored name matching. There are over 400 plants in the db and only a small percentage have thrown up the problem. It seems odd that MS have a listed statement using Name oldfile As newfile. But the MS site shows...

Thanks for that. The code section I submitted is just the crux of the problem. In previous code, the Stored path/filename ([Picture] in the db MainTable) is copied to a new table, "ImageTest" together with the MainTable [LatinName] for the corresponding record IF its filename doesn't match...

Hi all, I have never used the Name statement before and I want to rename some filenames to match the path/filename stored in the db. The format is Name oldname As newname Myset.MoveFirst Do Until Myset.EOF TableName = Myset![Picture] FolderName = "C:\Access Files\OurGardenPics\" &...

Hi Isaac, Now, I'not sure which function you are referring to so I will offer the code for the IsNothing() function Function IsNothing(varToTest As Variant) As Integer ' Tests for a "logical" nothing based on data type ' Empty and Null = Nothing ' Number = 0 is Nothing ' Zero length string...