Recent content by Amnross

  1. A

    Use a form to filter dates on a query, or leave blank to show all dates

    I ran across this post and it would seem to be the closest that I have found to helping me. However, I'm still having some problems. In my query "criteria" line, I put: Between Nz([Forms]![IPR Search Form]![Test Review From],#1/1/2013#) And Nz([Forms]![IPR Search Form]![Test Review...
  2. A

    VBA to backup and zip a file

    While I don't disagree and there are procedures for offsite backups, it is very time consuming to recover "lost" information thru our current system. All I'm looking for out of this forum is some assistance with moding my code to convert files into a zip format. I would be happy to discuss our...
  3. A

    VBA to backup and zip a file

    Our tech guys don't need a rationale for what they do, but the running theory is they want to reduce the amount of static data on the network servers. The org that I work for has several 100k employees, so I understand where they are coming from. My archived pst is on the order of 2-3 gigs right...
  4. A

    Backup current access file using vba while the file is open

    You can use the following code to back up a folder and all file within even if they are open. Private Sub Command2_Click() 'This example copy all files and subfolders from FromPath to ToPath. 'Note: If ToPath already exist it will overwrite existing files in this folder 'if ToPath not...
  5. A

    VBA to backup and zip a file

    I have a block of code that I use as a backup function to move files between my server drive and my local drive. Our network guys told us last week that we were no longer allowed to keep out outlook pst file on our server drives. As I spend a great deal of time away from my office, I need access...
See more
Back
Top Bottom