Search results for query: *

I have an Excel workbook with 6 columns. I need to combine them into one cell but maintain a specific number of characters per column. Example: Name Orders Dollars MTD Ord MTD Doll % of goal Name 1 $1,000 10 $1,000,000 15% Name would need to be 8 characters no matter the...

Hello! I have a macro in Excel that I wrote. I need it pause to 10 seconds before it executes the next set of code. I am using Application.Wait Now + TimeValue("00:00:10") This works but seems to freeze the entire application. I have ODBC updates running in the background that need to run...

I wrote a VB Macro to feed data from an Excel sheet to an ActiveX Control that runs an LED sign. This Macro is on a loop. I made a button to start it, can I make one to stop it?

I get several lists with inventory from my suppliers. I import the excel files into an access database. Multiple suppliers list the same inventory from the same manufacturer. I need a query to eliminate the duplicates. I have 5 columns: Part, MFG, Available, Vendor, Cost, Datecode, Package...

Hello! I have a gridview with phone call statitics for my sales dept. The 6th column is "TotalCalls". I need to change the font color to red if the number of total calls is less than 40 or to green if it is 40 or higher. I am new to ASP.net, so the simplest explanation will be appreciated...

Hello! I have a spreadsheet that imports via DTS. It has a part number column that may contain both numbers and letters. If the part number is numeric only and over 6-8 digits long the field is left blank. I know this has something to do with the way Microsoft "predicts" the data type by what...

I have a inventory I import daily from a Pick system via ODBC. I need to add 2 columns, Date and Source. Date being the date the import occured. Source will always be a fixed value. Can I do this with a DTS package? I am running SQL 2000 SP4. I am new to SQL so the simpler the better! Thanks!

Can I create a Stationary for MS outlook 2003 and load it in exchange and force all comany employees to use it as their default stationary?

I have 2 domains, one 2003 and one NT4.0. The NT domain contains one server running D3 for Pick. I have a 2 way trust set between the Domains. D3 needs to print to an XP Pro workstation in the 2003 Domain. Problem is D3 uses the NT System account when printing. The XP machine will not allow...

Hello! I have one user that has 2 exchange mail boxes. I created 2 profiles in Outlook to keep them seperate. Outlook always asks for a username and password for both profiles. This is making the user crazy. Is there anyway to make the profiles remember the username and password? I click the...

I have 2 2003 servers with SP1. I installed SQL 2000 on one server and Installed SP4 for SQL. Now if I try to install any software I get "Entry point Not Found in *****.dll" the DLL listed being different depending on what software I try to install. Thinking I had a bad server I moved SQL to...

I need to send an automatic email with an attachment each day at a specified time. I also need the attachment to be grabbed from a location on my network each as it changes daily. Can I do this with exchange? I am also using outlook 2003 as well. Thanks!

I must be missing something. I need a user that can send mail but cannot receive mail. I thought this is a "mail enabled user" but I cannot figure out how to set one up. Thanks!

On my Exchange server, in Active Directory, when I add columns to the display they do not remain if I close the console. Any Idea how I can make these changes stick?

My postmaster account is attempting to send mail to accounts using the full name of my server as seen on the internet. Example: email@mail.mycompany.com. My email domain is mycompany.com and email accounts are email@mycompany.com. Any reason why this is happening?

I have a single NT doamin. I recently upgraded my PDC to 2003 server with AD, DNS, DHCP and WINS. AD and DNS are working and replicating to my 2003 backup server I promoted to a DC. The only problem I can find is the NT servers are showing in DNS. I can run Nslookup and ping the NT servrs, but...

I currently call my NT domain "IRVINE" it is where we are located. The new 2003 AD domain will be "IRVINE.LOCAL". How will my XP clients attached to the domain react? Will I need to rejoin them to the domain? I hope they will update automatically, as the netbios name and SID are not changing...

Hello All! I have a Proliant ML370 with a single 733mhz cpu. I will be upgrading to 2003 soon from NT and want to add a second cpu as part of the upgrade. I can get 2 1ghz cpu's with VRM's off ebay. Will my server support these? I see the specs state that the G1 went to 1Ghz. If so what...

How do I setup relations in a SQL database? I am new to SQL but I have used Access alot and have gotten good at it.

Hello! Years ago my ISP had assigned us a block of IP addresses for use on our network. This proved to be a security nightmare and I added a firewall with a single external IP and released the IP block to the ISP. At the time I did not change the internal IP range. Now I plan to upgrade to...