Search results

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

hi would that not loop thru the lookup table ? i need it to loop thru the filenames in the folder thanks

hi my vb skills are very limited and I need help with a task to rename 1500 jpg files in a folder ( left hand side of attached screen grab ) I've got the data on the right hand side in an access table i need code to loop thru the folder and rename such that in simple terms the new filename =...

hi code below - was previously using blnHasFieldnames variable but now just forced it to false Dim strPathFile As String, strFile2 As String Dim strTable As String Dim blnHasFieldNames As Boolean ' Change this next line to True if the first row in EXCEL worksheet ' has field names...

I've tried saying no to has fieldnames. works fine if you manually import and have the fieldnames as F1, F2 etc. if you then run transfertxt via VB i get "you cannot record your changes because a value you entered violates the settings defined for this table or list...

Hi got same issue with CSV file sent from vehicle tracking company who are being less than helpful. can i ask if your 3rd party company were able to resolve, and if so do you know what had changed ? thanks