Recent content by Dave E

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

Yes. It looks like either a function, which I'm going to try, or an UPDATE query and see which one fits my purpose. It seems odd that it's possible to use a function like DLookUp to get data from a table but not be able have a DPut function to put data into a table. Still, now I see there isn't...

Yes, it was a befuddled question, and it deserved your response. Basically, I have a new table with 2 fields, both containing dates. One for Reminders and one for a ToDo list. The two fields hold the dates for the next date action required for the monthly/seasonal work required in the garden and...