Recent content by hansiepansie

Hi Poppa Smurf (nice name :-) ) I won't distribute this code. This code is only used to fill my table in the database once. I want to distribute the db after the filling job has finished. Regards, Hansiepansie

Good news!! Problem solved after some struggling :banghead: This is the correct code rst_tune.AddNew rst_tune("t_title").Value = rst_tune_in("title") file_string = "G:\sibelius\scores\volksmuziek\dans\branl1.jpg" 't_jpg is a field with data type "attachment" in...

Hello Poppa Smurf, Tnx for your reply!! OK, but I want the jpg itself to be included in the database and not only the location where to find it. That is why I created a field with data type "attachment". Reason is that I want to be able to distribute the database to several people who...

Hi Forum, I did the same test on another pc with the UK version of access 2010. The error message I receive is Run-time error 3259 Invalid field data type Is it impossible to attach a .jpg file to a field with data type "attachment" ? How should I change my code or my table setup to be...

Hello Forum, I want to add a record with attachment to a table in an access (2013) database. If I ignore the attachment error everything works as it should, but as soon as I add the code for the attachment I receive error code 3259. Private Sub add_tune() Dim dbtune As...

Hello Forum members, My name is Hans (Hansiepansie) and I am new to this forum. I do have some access experience. Created several databases with forms, reports and vba code in the past, but no Access experience for the last 2 years. It is nice to have found a forum with a lot of activity. I...