Search results for query: *

I need to make a mass change to a field that contains an email address. Values are standard format (joe@company.com, sally@company.com, etc). I need to change all the endings to @newcompany.com. The table holds about 500 records so I would like to write an update statement to do this. Not...

I have two tables Account and AccountExtra. Account is the primary table and the key is AccountID. AccountExtra is Left Joined via AccountID, since not every account will have data for the extra fields. I need to update a field in the AccountExtra table when a value is true in one of the...

I'm having an odd problem I've never run into before. I run Windows XP SP2 on a corporate domain. I'll lock my Desktop while away from my desk for a few minutes. When I return and ulock it, my Taskbar will be frozen. I cannot click any of the Quicklaunch icons, open the Start Menu or switch...

I need to create a view to summarize actual totals of orders by sales rep. It's got to be easy but, I'm a novice programmer so I keep getting lost. My table looks like this: Name Order Amount Date Smith ABC 100 12/1/2005 Smith XYZ 200 12/15/2005 Smith...

I have two sheets, one contains data imported from a database the second will display parts of the data. Sheet 1 looks something like this: Name Qtr Amount Smith Q1 1000 Smith Q2 1000 Jones Q1 800 Jones Q2 500 Sheet 2 looks like this: Qtr1 Qtr2 Smith...

I have recently had to take over some DBA duties for our SQL 2000 Server. As the old saying goes: I know just enough to get myself in trouble. We have a lot of old databases on the server that I suspect are no longer being used. Is there a way I can check the properties of the database/tables...

Here's my situation. I've got a few different ideas how to do this but, just can't wrap my head around the right solution. I have a View with the following data. An AccountID, ContactID, then four Boolean (T/F) fields. I need to look at each AccountID, then all of the Contacts at once and...

I have a script that writes values to a SQL Database. Unfortunately some of the data contains single quotes in the name (ie. Mom and Pop's Food). I can't seem to get the right combination of quotes to to get this to work. Here is the code that works great for a simple name (ie. Northern...

I'm stuck. I've been trying to get this to work all day and can't seem to find the problem. I am trying to insert a row into an Access table with data from an asp.net page. I have two drop-down lists and three text boxes on the page that the user will input data to. I generate a primary key...

I would like to add line on a web page that displays the current virus definitions on the server. I've identified the registry key that hold the definition date. Now I need to know the best way to show this on a web page.

We have a 10 page presentation saved as html files. We link to this presentation from our intranet home page. I would like to have links to a specific slide within the presentation. Example: Link1 on Home Page goes to slide 1, Link2 goes to slide 6. Linking to the main html file works fine...

I have a user that is constantly having to reset their proxy settings. Something is happening to his pc that is causing the settings to be cleared when he reboots. The only unusual thing that he has is AOL. He will access it from home using a dial-up connection. I suspect this is the cause...

I have a user that is constantly having to reset their proxy settings. Something is happening to his pc that is causing the settings to be cleared when he reboots. The only unusual thing that he has is AOL. He will access it from home using a dial-up connection. I suspect this is the cause...

We are using the FedEx, UPS and other types of shipping lables. Currently, they are filling them out with a typewriter. They would like to use and old dot-matix printer to fill out the forms since they have carbon copies. Does anyone know if there are any existing Word templates for any of...

I'm using a layout table to control placement however, the text that I'm placing in the cells is overflowing. It looks fine in design view, but when displayed in the browser it is going beyond the borders of the cells. All of the properties are set to fixed and there doesn't appear to be any...

I have created a Nav Bar using the Navigation Bar Option. I saved it to the Library for use on multiple pages. Everything works great except that when I put the Object into a page, a long script shows up at the top of it. It doesn't actually display on the final page, but it makes it hard to...

We are intersted in setting up a PC Controlled "Video Wall" to replace some of our bulletin boards. Does anyone know of a good place to get information on what it takes to do this. We would like do as much of it ourselves instead of getting a premade kit.

We are in the process of moving from an NT4 Domain to a Windows 2K Active Directory Domain. We are changing domain names in the process, so it is not just an upgrade. The only problem we are having is migrating the user profiles on the local machines. All of our workstations are already 2000...

We have an intranet web page that links to a network folder with a bunch of Word Documents. Everyone is able to click one of the files and IE will display the Word Doc in the frame. However, there is a user that will only get an image placeholder. If he goes back and clicks the link and...

I have a user with a Personal Macro Workbook that opens with Excel and stays hidden. She has setup custom icons on her toolbars that link to the macros. She is getting a new computer and would like everything back. I have the personal.xls file with the macros but can't find where the custom...