Recent content by drouz

Ha been playing around with it and finally cracked it, heres the code that worked for me, thank for the help michaeljryan78 Function SaveAttachment() Dim db As DAO.Database Dim rst As DAO.Recordset2 Dim rstAttachment As DAO.Recordset2 Dim fld As DAO.Field2 Dim strPath As String Dim intz...

thanking you, I have tried inserting this code, but I get a runtime error before I reach this point Run Time Error '3021' No Current Record I've commented in my code below where it happens, I'm guessing it happens because there are no attachments I think I need a check in here or something...

Hello, I'm fairly new to Access and VBA but have spend days learning how to setup a database with an attachments field, which I have done successfully, this database is on a shared network drive and is used by my workmates, so data is entered via a form, I wanted to add a command button to email...