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...
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...
Does anyone know a good way to accomplish this?
I have a table (X) which has a primary key. This is referenced in another table (Y) that has its own primary key.
I want to delete everything in X that's related to Y, given Y's primary key.
I'm writing a VB app to feed the SQL to the database...
Hey all,
I have an application that uses a locally-installed MySQL database to store records from our shop floor's production lines. However, for reasons out of my control, the computer is in a very dangerous spot. I'd like to have a script back up the data to my server on a regular basis...
Hey all,
I'm looking for a way to track printer use. I have a server set up with all my printers, and my users map the printers they need...
I was trying to use print auditing in Windows, but it doesn't give me an indication of file size or number of pages. I'm looking for a way to find out...
Hey all,
I've found the @Command for printing files, and I've seen a similar counterpart in NotesScript, but I can't seem to find out how to automatically set the print job to be double-sided.
Is there a way I can make an action button or something that will print the current document in...
Hey all,
We have a weekly meeting of all supervisors, and each section has a few custom powerpoint slides that they show during their respective parts. I'm looking to automate the presentation building process as follows:
I want 1 master presentation in folder x. X has subfolders, 1 for each...
Hey all,
I am attempting to run a VBScript on my webserver when the user clicks a button. For some reason I was unable to add the script directly into my asp code... it's a mail send routine for Lotus Notes and it doesn't behave well with ASP. My workaround was to make a standalone script on...
Hi all,
I've been working on an ASP helpdesk ticket system I found for free on the web. I had to make some modifications to it because our company uses Notes, and I wanted to be able to email notifications to users and techs. I can't set up a virtual SMTP server and do it the easy way, of...
Hey all, I'm usually more of a programmer but I've been thrust into the role of network admin and I'm in need of a little help.
I am suffering from a DNS Poisoning attack. I have run all the anti-spyware tools I could find on both workstations and servers, and nothing turned up. I keep...
Hey all,
We're replacing our file server (and updating the OS to Server 2003), and taking advantage of the changeover to reorganize some things that could be done better.
I'm learning that Windows has the ability to give a user a certain quota in terms of the amount of info they can store on...
Hi all,
I'm brand-new to programming for SQL Server, after having started in Access. I decided after installing Visual Studio .NET 2003 that I would run through some of the tutorials for ASP.NET. I followed the directions to the letter for creating the web form and every time I run it I get...
Hi all,
I'm trying to learn ASP.NET. I've installed IIS and all the tools that I was told to... I downloaded the source of some sample apps (one through the MSDN help, the other off a random website) and any time I try to load an ASP page in IE, I get a white page with all the source of the...
Hi all,
I've never been responsible for servers before and, as a pet project, I've installed RedHat Linux (Enterprise v4) on a box. I want to learn how to run lots of different types of servers: mail, ftp, http, everything on my own. What I need is to know how to get started. Will I need a...
We're getting ready to start using SQL Server in our plant. Currently, we have a file server for everyone to use. We are considering running SQL Server on a partition of the file server because it appears to have plenty of CPU to spare; will we be ok for a small operation (~85 users), or...
Hi all,
Not sure if this is the right place for this, but I didn't see anything that fit it better...
Our company uses Symantec Web Security to filter websites on all work-related PCs. We admins get email notifications after things have been blocked, which we then investigate and forward to...
Hey, I just got a call from a guy who can't print to a Xerox N4525 on our network. I can print a test page from my PC. When we try it on his, we get an error message that "procedure could not be found in ntprint.dll". We've tried replacing his .dll with the one from a working computer, got...
Hi all,
How can I assign a consecutive number to each document that gets created? I'm designing a ticket system for our I.T. department to use for help calls. The first document should be 1 and each new document that gets created will increment this value.
Ben
There's no place like 127.0.0.1.
Hey all,
I am building an application in Access and in one area, I'm using VBA to build an SQL string. My problem is that it cuts off at ~250 characters. My statement is pretty involved, so it's long. Like, maybe twice that long. An app that I wrote a long time ago didn't have this problem...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.