Search results

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

In this case the Date is generated, not selected or input by a user. The code detects when a set period has elapsed and then recalculates the new one as a DateAdd('d', 30, Date). That is then saved to the holding table and used by the relevant form's OnOpen routine which looks at the saved date...

I simply wrote a function that opens a recordset for one table, one record, with two fields and the same unique ID. When used, a new date is saved to the table as in - MySet.Edit MySet![ReminderDate] = Forms!MyForm!ReminderDate MySet.Update It works. I have set up two fields on the main...

Yes Pat. Thanks. I have written the code for two forms that take and put data into a table. It works well, and I was content to write the code knowing there wasn't a pre-existing function available. It does seem odd that one doesn't already exist in Access when the DLookUp function is commonly...

Thanks. I will write a DPut function and try an UPDATE function to see which is best for me. Dave E

I knew that you'd pop up with a definitive reply. The comment was a tad tangled but I wasn't, nor am I a newbie, having written many database programs for my uni and personal use, such as the one that keeps me occupied during my retirement. I will go ahead, now, and try out a function and an...