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

...this (note, I always die on the first delete): Public Sub DeleteTempTables() DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM TEMP_ApplicationPerWeek;" DoCmd.RunSQL "DELETE * FROM TEMP_AverageTimeToClose;" DoCmd.RunSQL "DELETE * FROM TEMP_NumberOfTicketsPerWeek;"...

...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 loop. I'm failing on the very first run through the loop (I do the "delete * from x" operation before...

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

...I use to temporarily hold things while I'm working through the report creation process. It's not attached to anything. All I'm doing is "DELETE * FROM TEMPTable;" via a RunSQL command. As I said before, if I run this code manually, it works fine. I noticed that at the same time the...

...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, I added a quick & dirty logging system to the spreadsheet that writes to a publicly-accessible location on...

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.