Recent content by CodeByJim

Hello. I have a procedure that collects control names from a subform into a CSV string. I have been using procedures like this for years without any problems. Suddenly I start getting Run-time error '2455': "You entered an expression that has an invalid reference to the property Form/Report."...

If you have CSV data in a text file, you can read each string into VBA and use the Split function to create a one dimension array which can be saved into a pre-designed table. I use CSV strings a lot when handling data movement into and out of my tables.

You sent an example of your data in an excel spreadsheet. Why don't you simply export the data to an Access table. Edit your tables and then set up Access relationships.

Thanks for your comment Pat. The only time my db gets backed up is when I physically back it up and when I do, it goes to three seperate folders on a different hard drive partition and to three seperate folders on a SD card. Backup are only done after a compile and save. By the way, I like...

I assume(poor word choice) that warnings are on by default. I have never touched that setting. The program ran error free before the backup and it runs error free after being decompiled, repaired, compacted and re-compiled, with no edits made to the code. Apparently the modules don't compile...

theDBguy is right. Change the dim to: Dim rsc as DAO.Recordsetclone That catches me up all the time since moving to 365. In 2000, I never had to worry about that. Old habits...

I don't know what Me.Recordsetclone refers to, but I would Dim rsc as Recordsetclone Then dimension a variable to hold a bookmark from the recordsetclone. Dim varBookmark As Variant After the following line, MsgBox "Number Found", vbOKOnly add this: varBookmark = rsc.Bookmark When you want...

Try re-writing this line: Set rs = CurrentDb.OpenRecordset(SQL) as follows. Set rs = CurrentDb.OpenRecordset(SQL, dbOpenDynaset)

Hello. I am a single user developing a database for my personal use. I am not using a back end database. Everything in my database is contained in one ACCDB. A while ago, I was single stepping thru some code, setting bookmarks, after stopping at a breakpoint. I had done no editing! There...