Search results

  1. Y

    PERMISSION DENIED ON .CopyFolder

    Hello, I have set up a function to automatically backup the scheduled task files on our computer, located at "C:\Windows\System32\Tasks\Databases" The following code is throwing a permission denied error: objFSO.CopyFolder "C:\Windows\System32\Tasks\Databases*", archivePath objFSO is...
  2. Y

    Automated Report Printing "This document was previously formatted for printer..."

    Automated Report Printing "This document was previously formatted for printer..." Hello, We recently moved a database to a new server and have been experiencing this issue irregularly, seemingly more and more often: Every morning there is an auto process kicked off and multiple reports are...
  3. Y

    32 bit Access Databases Slow Startup On 64 bit Windows Server

    Hello, I have recently moved an old .mdb database over onto a new 64 bit 2012 Windows Server from a 32 bit Windows Server Standard (2007). I've noticed that the database takes about 30 seconds to open where before it would open almost instantly. After googling around I've tried messing...
  4. Y

    Zipping folders with vba

    Hello, I have a folder that at the root level contains both files as well as an images folder containing .jpg files. I was wondering if it were possible to use VBA to create a .zip file from that root folder. So far, I have only been able to create a new .zip file, and then add files to that...
  5. Y

    BETWEEN date AND date filter in query excludes year in result set

    Hello, I have the following crosstab query to sort grouping of transactions and list the total number of transactions by group: TRANSFORM Count(sourceQuery.Grouping) AS CountOfGrouping SELECT sourceQuery.[Major Grouping] AS [Transaction Type] FROM sourceQuery WHERE (((sourceQuery.ProcessDate)...
Top Bottom