Recent content by yaya

Thanks for the replies! After further digging, I have discovered what was wrong as well as a solution! The code running on the two machines was exactly the same, so I realized that the issue had to be with the one machine somewhere. Then, after verifying it wasnt a permissions issue (I could...

Hello DBguy, I tried removing the asterisk and then got the same error, when I add a trailing slash to the source path i get a path not found error. I have tested this code on another machine and it works. I cant figure out what is wrong with the permissions for the other computer because...

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...

Re: Automated Report Printing "This document was previously formatted for printer..." Hey Gemma, I tried to reply to your private message but I dont have enough posts yet to do so hahaha So it appeared to be fixed for that one report that was initially causing the issue, but then a report that...

Re: Automated Report Printing "This document was previously formatted for printer..." I think switching the configuration from the specific printer <PRINTERNAME> to the default printer may have solved the issue. I tested it out by re running the scheduled task and it worked but I wont know...

Re: Automated Report Printing "This document was previously formatted for printer..." Is this not what the function posted does? It doesn't set it to nothing when its done but rather it stores the original default until the print is done and then sets it back to that afterward. I didnt know...

Re: Automated Report Printing "This document was previously formatted for printer..." Yeah I just modified the auto process to only do that and then i re ran the scheduled task that runs in the morning and it worked. Although i wont know for sure until tomorrow morning. Fingers crossed! If...

Re: Automated Report Printing "This document was previously formatted for printer..." When I go to design and then over to the Page Setup tab, the Page Setup dialog box opens and then if I go to the page tab in that, the correct specific printer <PRINTERNAME> is selected. Perhaps I need to...

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...

I am one of the IT guys -_- BUT WE FINALLY FIGURED IT OUT!!! It turns out that on start up, Access was trying (and failing) to connect to the internet and call home. The proxy settings weren't set up on the server yet and so we opened IE and turned on our auto script. Doing this solved our...

I just tried with a blank database and the same thing happens.

I have tried opening the database normally and opening while holding shift down. Regardless it takes around 30 seconds. This happens for any database I try to open.

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...

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...

I created a new query using the tables themselves and it works now. I'm not sure why exactly the other query didnt work, though i suppose it has something to do with it being a query from using a query inside another existing query! Too many nested fields from all over the place grouped up...