Search results

There are files in the folder and subfolder. The code I have now works fine which is good. I create the zip in a temp folder. Clear the main folder then move the zip to the main folder from the temp one. It's not elegant, but works for the basic needs we have. Thank you for your help, your code...

Hi Gasman, That code only deleted files and not folders. Now create the zip file in a temp location, empty the source folder then move the zip file back. I had to put a 2 second pause after the zip file is created otherwise it deleted the files before it was finished. I used the code on the...

Hi Gasman, I went with this approach in the end. I create the zip file in a temp folder, clear the first folder, then move the file from Temp to Original. I will update this thread once I have it working. At the moment it is deleting the files/folders before the zip has complete. ~Matt

Hi moke123, This just gives an error as below. ~Matt

Hi Gasman, I cannot seem to get this to work. It doesn't remove anything :( ~Matt

Hi all, I have looked but cannot find a method for this. I want to delete all files and folders from a main folder, apart from anything *.zip. I can find code to delete everything, or all of a certain file type, but nothing to only leave a certain file type. ~Matt

Hi All, I have a 2 step command I wish to create. Step 1, use a network folder location and create a zip file with all folder files in it. Step 2, delete the files that have since been zipped. I have a network folder that files will be moved into. I then need to add these to a zip archive...

Ignore me, I have figured it out. I had the wrong expression on the listbox requery after box checked. Been a long day. ~Matt

Hi All, I have generated a query that filters from options of a form. When I open the form, the list box posts the below error. But if I open the query itself, it shows the data and no error. Just won't display it in the list box. I have 3 check boxes for the dates Created Date, Sent Date...

Thanks ebs17, Apologies if it sounded like I was moaning. Your code was better than anything I could have done and is how I learn. I do read and understand the code and will make use of this for sure. ~Matt

This also only show 1 person, and 1 date. If there are multiple dates, it doesn't show each day and person. Below is the full table for this job in case that helps. WorksOrderRecordID WorksOrderReference BookingDate EnteredBy StartTime FinishTime 127304642 21639-003 12-Feb-24 Operator 1...

This looks good, however there is an additional challenge I forgot to add. There may be times where an operator logs onto another operation, on the same day, but after the last finish time. this would then need to be treated as brand new time logged. As an example, the same operator above may...

Yes, this is correct. The current system logs all these as different times. I want the first start, the last end and then to discount all starts and ends by the same person on the same job between the first and last ones if that makes sense. And then use that time as the amount of time logged...

Hello forum brains, I am hoping someone might have an idea on a solution here. We have a 3rd party application to for our production people to log their times on jobs. It works, almost, how we want it to. Where it falls down is when people log onto multiple operations at the same time (which is...

For the full background on this I have a time labour calculator for our internal BOMs. Our company timings are done as a decimal of the minute, in 6 second (0.10) or 15 second (0.25) breaks. When I export our BOM into a 3rd party application, their labour is broken into 3 fields, Hours, Minutes...

Thanks all. I have this working perfectly now. I used arnelgps code and it did exactly what I needed. ~Matt

Thank you, works perfect ~Matt

Hi All, Does anyone have a snippet somewhere on how to separate a minute field into each hour, minutes, seconds? IE 75.5 would be 1 hour 15 minutes 30 seconds ~Matt

Update. Quick search and I have changed the Dim for Public, but the below now does not work. Says invalid outside procedure. But when it has Dim, is works. Do I need to add something else? Public strLoggedUser As String strLoggedUser = DLookup("EmployeeID", "tblEmployee"...

Hi Pat I didn't get the chance. I will give it a go though as their bug is still creating the records. Just working on something else at the moment with a tight deadline. ~Matt