Search results

Got this working great and i can copy the files selected from the listbox. Now heres my next question. At the moment the code is looking at the hyperlink URL and copying the file but ultimately i want to copy all the files within the folder part of the url except any *.doc files. would this be...

Either or Really

I have records that have Doc_ID, Doc_Num, Doc_Desc, Hyperlink Every record has its own filesystem folder based on doc_num and the files within it.. (doc files, pdfs etc) The hyperlink looks at the pdf path within the folder. E:G \\server\docproduction\doc_num123\12345.pdf My form looks at this...

I have a filtered report grouped by name and their competence. so if someone has 3 competencies based on the filter it shows the 3 comps under their name in the group. i Have added a =Count(*) to the name header showing their 3 comps and would like the report to order by the highest competence...

Only show staff with any 3 selected that have all 3.

I have a form with a listbox showing 15 competencies linked by Comp_ID and a subform linked to query1 showing all staff with all competencies. when i highlight a competency from the list box the subform reduces the records based on that competency.. GREAT! what i want to do is use a multi...

I am trying to populate a field in a table based on the Autovalue in a form. My query has a value of the form, and ID but it populates the field in the table with [] instead of say, 3 which is actually displayed on the form field. if i create an unbound text field on the form and manually type...

Knew it would be simple. thanks.

I am trying to create a calculated filed in query based on the following. If the date is null then calculated field= No If the date is not null then calculated field =Yes here is what i have tried to no avail: Status: IIf(IsNull([Date]),"No") & IIf(IsNotNull([Date]),"Yes") The error i get is...

This wont work for me.. really need it to be for each record the user chooses. every record has a different hyperlink path so it gets the file from that location and adds it to the existing email.

Ok i have button that can send an attachment via email.. it launches outlook if its not open, creates an instance and attaches a file based on the populated hyperlink field in the record.. GREAT! What i want to do is then goto another record, press the button and it adds the second attachment...

Heres the code that worked. Private Sub Command65_Click() On Error Resume Next ' <-- Comment out for troubleshooting. Const Prep = "\\Servername\DART$\Document-Library\Doc-Production" Dim objfolder Set objFSO = CreateObject("Scripting.FileSystemObject") Set objfolder = objFSO.getFolder(Prep)...

You sent me on the right track.. Thanks. Here's the code that worked for others. Private Sub Command65_Click() On Error Resume Next ' <-- Comment out for troubleshooting. Const Prep = "\\Servername\DART$\Document-Library\Doc-Production" Dim objfolder Set objFSO =...

Cheers Cronk but getting same error.

getting the same error which makes me think the code is in the wrong place.

I am trying to delete empty subfolders from Doc-Production older using a button but am getting the following error. Run-Time error '424' Object required. Code stops at imoji. Private Sub Command65_Click() 'On Error Resume Next ' <-- Comment out for troubleshooting. Const Prep =...

Ok the only issue i can find with this command is it also deletes the parent folder. i need it to delete only the empty subfolders.

Thanks, Is there any way to only delete the folder if it is empty. happy for it to delete all empty subfolders rather than specific folder.

I have a button that moves files from location 1 to location 2. If the folder doesn't exist in location 2, it creates it before moving the files. What i am trying to do is delete the empty folder from location 1 once the files have been moved to location 2. How would i do this? Here is my...

I am trying to automatically open a word document in a folder based on the criteria of a field on the form. I Can get it working so i can get to the folder and then double click to open the file but how can i get the file to open just by clicking the button preferably in read only mode. Here...