Recent content by laffeg

bingo ! that's great, thanks for the help

yes it was missing the .Address part of the hyperlink - now sorted that and getting file not found error on the filecopy line can you explain the logic of the sting parts ? the hyperlinks all point to another folder on the S drive - I changed your Environ$ line to the source folder

hi arnelgp that throws run-time error 9 subscript out of range error on the first Split line i've never used Split before - does that need a reference adding ?

thanks Ranman256 I tried calling Copy1File first - when the first file appeared I thought great - however it then proceeded to just overwrite/rename that 1 file as it looped thru records Private Sub refreshbp_Click() Dim dbs As DAO.Database Dim rsQuery As DAO.Recordset Set dbs =...

hi I have a query showing a subset of records including a hyperlink field I need a form button to run a do while not EOF loop to save each file to a folder never done anything like this before so no idea what would be the best method. Found URLDownloadtoFile but struggling to see the correct...

excellent - gold star to you ! works a treat many thanks

hi got a field that is a long string of information with spaces to separate different bits of information that include a date in simple ddmmyy no slashes or dots I'm using various left and instr functions to separate out the information into individual fields in a query all working other...

many thanks bastanu - that is now working the way i want it to - much kudos :)

so with rs instead of me I get attachments with the right certificate numbers as the filenames, however the 2nd attachment is just the first PDF duplicated - if that makes sense

hi anyone able to help ? thanks

hi trying to get an email in outlook with as many PDF attachments as there are records in the continuous subform -ie 1 attachment per subform record in code below ( which is button on the subform ) 4 possible values for Me![Master] hence the if then statements - it should determine which...

the client renamed the files using the excel method i posted. so job done. doesn't need me after all :( i've designed a few access databases for them and normally get by with my limited vb skills.

yes thanks. i've not tried finishing the access vba code but client is sorted.

thanks for all the advice, i've learned a few things for future tasks. I was on the road a lot yesterday and my client beat me to it by using this Excel suggestion https://benholland.me/tutorials/2011/11/11/rename-multiple-files-using-excel-in-windows.html

so i've copied the code into a module and modified the Name line as below theory being replace from first space onwards for 16 characters with result from lookup field Name CStr(varItem) As Replace(CStr(varItem), mid(varitem,instr(varitem," "),16)...