Recent content by Bangorgav

geoff, Did you ever manage to sort this upgrade from winzip code to 7zip? Im struggling at the minute with the same task.

Hi guys, having a bit of trouble at the minute with a new query, I have 4 colums DATE 1 DATE 2 DAYS Days with reviewer i need a query to check if DATE 2 = blank,(if true Datediff between Date 1 and now in days),(if false, DateDiff between Date 2 and now in days)...

Hi guys all has been going well recently, untill ive encountered a wee problem... Run down: So i have a Query pulling the following DATA Contract Name, Vendor Name, Status, Create Date, Design Date , Current Reviewer. And so far ive got everything working bar the current reviewer. The...

hi guys back with the same code, all the zipping is working fine, however how do i add the functionality of everytime i click the zip button it replaces the current zip files with new ones. The zip files will be zipped everyday, with new information in the source files...

Following on from this, codes working and im Zipping over 10 folders seperatly, After the files are zipped i have a button to Email the zipped files. however since the program will be used by other staff I need to have a way to let the user know when they can click the button, incase they click...

PeterF Your a gentleman and a scholar!, Thanks for all your help. the both of you!

Can't at the minute as i'm in work. I got the information from dotnetpeals 7zip examples. which says the "a" command should put all the files within the zip folder, which makes me think the VBA code is incorrect. Thanks Guys

Hi guys, trying to zip files at the click of a button in an access form, at the minute i've got it working for individual files but i can't get it to zip the entire contents of the folder in one zip folder.. Its ziping each individual txt file in its own zip file. I'm hoping its something...

Hi guys pretty new to using VBA in access, basics are pretty much nailed but im having some trouble so i thought i'd sign up on here get some help! Thanks Guys!