Recent content by wildek

Also, the jumper on the new drive is set to Cable Select. I'm not sure what the jumper is set to on the Master (original) drive. Could this be the problem.

I have an HP 854n PC. It currently has a 120 GB 5400 RPM hard drive in it. I just purchased a Seagate 300 GB 7200 RPM to use as the slave. I was not able to get the PC to detect the new drive with the exisiting cable. I tried setting the jumpers to slave, and then to ignore drive size on the...

Thanks so much. I think I have it now!

I probably could just put the PP22, pP23, etc.. in the sheet, and have the macro point to that particular cell. I think that my work, rather than editing the actual macro code.

I am trying to change part of the code. Here is the macro code I am opening and want to change: Sub lock2_502() Workbooks.Open ("F:\daysheets\502.xls"), writerespassword:="password" Application.Goto Reference:="pp22A" ActiveSheet.Unprotect password:="password" Selection.Locked...

Hi, I'm trying to get a macro to open another macro in a different worksheet (the worksheet will already be opened) and then prompt the user to enter the text to find, and the text to replace within the macro (not on the workesheet). Basically, I'm tryin got find the code to open and fill in...

I have a Windows Server 2003 SP 1 which is running as a web server (not doing any highly intensive work yet as we are still piloting this program so only a limited # of users can access it, and they only do so for short periods of time). The server keeps locking up at least once per week, maybe...

Thanks so much! That worked.

It is supposed to enter in the rate that the user inputs into Column U and delete the information (a rate code) in column D. I also tried Range("U" & MY_ROWS).Value = SB1446_FootCare_Rate And Range("D" & MY_ROWS).ClearContents

This is my input box code: Dim SB1446_FootCare_Rate For MY_ROWS = 1 To ActiveSheet.UsedRange.Rows.Count If (Range("N" & MY_ROWS).Value) >= 0.01 And (Range("H" & MY_ROWS).Value) = ("H720") And (Range("C" & MY_ROWS).Value) = "1446" Then SB1446_FootCare_Rate = InputBox("Enter the H720 - Foot...

Please see this thread (originally posted in wrong forum). thread222-1054027

Hi, I have an excel input box that prompts the user to enter in a person's temporary pay rate if it finds a certain code in another column. If the user enters in a pay rate with cents in it such as 40.66 or 39.50 it rounds the number off to 41 or 40. How can I get it to keep the cents and round...

Hi, Every night I back up using Brightstor 9 on a server running windows server 2000 SP3. I am using Maxell DLT 40/80 tapes. The media is overwritten/formatted nightly before the backup. The job status shows the backup as complete and finished. When I look in the Activity log, I see a ton of...

Please disregard my previous post as I figured out what was wrong.

I'm trying to backup an ADP database using SQL Talk. The database name is pay4win and the server name is fred3. This is the script I have in SQL Talk: connect pay4win user/password; set server fred3; use 1; backup snapshot to c:\backup\pay4win on server; disconnect pay4win; I get the following...