Search results for query: *

Here's the whole function. "RunReportQuery" is a wrapper that passes the package name and report date to an append query of the name provided in the call. I call DeleteTempTables() twice, I know... since I auto-compact on close I wanted the local tables to be as small as possible for storage...

StoredData_Packages is a local table. I removed the logging from DeleteTempTables() for brevity's sake. I can see that it never gets past the first table deletion. Incidentally, all the things being deleted from in that sub are individual tables and have no relationships to anything else...

Here's the code leading up to the point of failure. First I check the data source to be sure it's up to date. Then I grab the list of "versions" of the report I run (same report, different data sources) and start a while loop where we actually run each of them. Other stuff happens after this...

...aaaaaand 3086 again. So the scenario here is that I have to run the same report for multiple criteria, which I do in a loop. What I do to keep my code readable is write the data via append queries to a local temporary table, which gets cleared (DELETE * FROM x;) after each run through the...

Update: I just found a page describing a permissions issue that caused the 3027 error. I noticed that the service account used to call the .accdb automatically was not explicitly granted permissions to the folder. I've given my service account full permissions to the directory and I'm...

Hey, sorry for disappearing... got busy with other issues! trevil620: the code to delete is in a module inside the .accdb file. The report isn't an Access report, but a spreadsheet that links to the .accdb via MS Query that does use that table but calls it much later in the day. I have...

Warnings are indeed off. This is what it does: docmd.Setwarnings False docmd.RunSQL "DELETE * FROM TEMPTable;" docmd.Setwarnings True I notice that you use the db.Execute rather than docmd.RunSQL... is that just a personal preference? Ben Hear the beauty... #> /proc/kcore>/dev/audio

That's the mystery... If I log in and run the vba manually on this report, it works fine. But if I let it kick off from the scheduled task (running as the same user I just logged in with), it fails. Ben Hear the beauty... #> /proc/kcore>/dev/audio

Hi all, I've got an access database that produces a report. It's set by a scheduled task to run in "headless" mode via a service account, and it's set to auto-start running my code when I kick off the database. This all works fine if I manually review it. However, when the scheduled task...

I've got an excel spreadsheet report that my team creates... takes a lot of work to run the report each month. We aren't sure how widely it's being used... if we ask, users say "oh this is critical to us" but we've had mistakes go out before that took them *months* to catch. So... this month...

In Ubuntu the Desktop is /home/$USERNAME/Desktop Note that Desktop is capitalized. Ben Windows isn't the answer; it's the question. NO is the answer.

I once found the solution to your problem; it was long and drawn-out, and I don't know where the link is. If you'd like a quick fix though, you might check out Likewise-Open. It's a package that joins Linux to the Active Directory domain very easily. I haven't used it extensively yet but what...

PHPmyadmin installs itself elsewhere (don't remember off the top of my head) and then links itself via apache for security purposes. You should be able to browse http://localhost/phpmyadmin and get the login screen if you installed it properly. Ben Windows isn't the answer; it's the question...

Well if you haven't done anything else to the system, just pop the CD in and re-run it. I found this site very helpful when I was first learning my way around: http://www.howtoforge.com/ubuntu_lamp_for_newbies Ben Windows isn't the answer; it's the question. NO is the answer.

I've run into this before. When you set up php with apache, you unfortunately have to do things in a really specific order. I'd try reinstalling php next. Try sudo aptitude reinstall php5 Then restart apache and see if that corrects it. Just out of curiosity, did you install the server...

What Linux distribution are you using? In many of these sorts of questions, that's the first important piece of information required to help you solve your problems. If you're trying Debian/Ubuntu, you should first do this: sudo apt-get install libapache2-mod-php5 followed by sudo...

http://www.pendrivelinux.com Howtos for many distributions... and I've installed a persistent Ubuntu 8.04 on a 2 GB flash drive, so yeah, it's possible to keep it under 2 GB. Comes in at about 1.8 right after default install (before you remove games, etc). Ben Windows isn't the answer; it's...

I just took a look there, but all the entries are blank. So I guess that's not the cause. Any other ideas? Ben Windows isn't the answer; it's the question. NO is the answer.

My office people reported a strange issue this week... We have an employee whose HOME TELEPHONE number is 555-0237. Conveniently, our PBX is on the same exchange, in the 2200 area (e.g. 555-2200). The office workers are reporting that when they try to reach the employee at home, they're...

A quick Google search turned up this thread on Ubuntu forums.org: http://ubuntuforums.org/showthread.php?t=942081 Looks very similar to your situation. Ben Windows isn't the answer; it's the question. NO is the answer.