Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rmiller11
  • Content: Threads
  • Order by date
  1. rmiller11

    Can't turn off Write Cashing

    I am working with Windows server 2000 with SP4. I am having a problem with the SQL part of it locking up cause of the write cashing being enabled. I have it turned off on the Adaptec SCSI controller. When it turn it off through windows device manager, I go back in and it's enabled again. I...
  2. rmiller11

    pcAnywhere and Ports

    I can not get the pcanywhere to work with any other prot then 5631 and 5632. I set up the Linksys router for 5641 to 5642 for BOTH and then give it an internal ip number to go to. I set up the host and remote to match. If I change everything to 5631 and 5632 it works and works to any internal...
  3. rmiller11

    Distinct Select

    I am doing file labels for customers and can't quite figure out hot to get a distinct selection through crystal. The main Customer table does not have an active flag but I have the ARHist which has dates of transactions. So I did a link to it from the ARHist so that I only get id's that have...
  4. rmiller11

    Groupings and Columns

    I have not used columns and cross tabs at this point. We have our employees set up in evacuation Buddy Groups and would like to do a report for posting and would like the groups in columns to save paper ie: Office Office Shop Group 10 Tot 2 Group 20 Tot 5 Group 5...
  5. rmiller11

    Can't delete files and directories

    I opened up a directory for a day with FTP services. And, over night someone put files on there with directories for sharing. I can not delete those directoies and files. They seem to have spaces in them and probably have high asci characters that can not be seen. how do I delete them? Any...
  6. rmiller11

    Explorer Pulsing/Refreshing every 10 seconds

    When I bring up Explorer, it pulses, refreshes every 10 to 15 seconds, the hour glass come up for two seconds. How do I stop that from happening? It's driving me cray. I have it doing it on two machines now and don't know how to stop it. Win2000 machine and XP machine.
  7. rmiller11

    Account Password & .EXE files Not accepted

    I just got a new machine with XP on it...I have two issues with Outlook Express that I would like to get fixed.. 1. Is there a way to have it accept all files instead of going into the Registry and specifying each and every file extension? Actually the atricle in the knowledge base was for...
  8. rmiller11

    Day of week = Sunday

    I would like to get hours for a date range and only want the hours that were worked o Sunday. Ie: if datefield = Sunday then hoursWorked How would I do that?
  9. rmiller11

    Previous Date

    I know how to get the max date but how do I get the date directly proceeding it? Some records will not have a date proceeding but 90% will have many. I want to creat formulas based on previous date and most recent max date and need to be able to handle it is there is no preceeding date.
  10. rmiller11

    Max Date and Previous to Max Date, How do I?

    I am doing a wage review report. I need to seeon one line per employee the Effective date or their last rate change which may or may not have been an increase. Next column I want to find from the last effective of a rate increase the difference between the Most recent increase to the prior...
  11. rmiller11

    0 fill a number field, export to text file.

    I am trying to do a report for the back which has to be exported as a text file and sent electronically. I can not figure out how to "0" fill a number field to 10 digits ie: $2312.00 would be 0000231200 Also, would I be able to format the export to have 80 characters with no spaces...
  12. rmiller11

    Back up Strategy

    Currently I am doing two backups a day on two different databases to file. Night time and Noon. They are then backed up to tape which runs nightly. I would like to get more backups per day so am considering the differential with which I would have two different for each database since I have...
  13. rmiller11

    Count weeks

    We recently changed to a biweekly pay. Previously, I would count the paychecks in a quarter for Sate tax reporting. So now I need a way to count the weeks worked. It looks like DatePart would give me that info but I can't figure out the formula. I already select the info by quarter and year...
  14. rmiller11

    Item not found at boot up

    I am getting this message in /usr/adm/messages: WARNING: pnt0 11: device not found! %pnt 0x0800-0x0812 0 - pnt0 v2.1 Adapter Not Found How do I get this out of the boot up configuration?
  15. rmiller11

    Getting Last name & first name in a field

    I want to be able to separate the first, last, and (If exist) middle Initial and (if exist) suffix in a name field that is formatted like this: "Blow, Jr.~Joseph D" "Bollinger~Mary D" "Bird~Jane" How would I do this? I want to send it to Excel in separate fields...
  16. rmiller11

    Vlookup Help in Excel

    I have a formula which I am looking up figures in another sheet: =VLOOKUP(A1,Sheet1!1:65536,4,FALSE) The problem is, that when I copy the formula down, this is what happens: =VLOOKUP(A2,Sheet1!#REF!,4,FALSE) I want the second, third, and forth section to stay constant...
  17. rmiller11

    Date Range Parameter

    I am not sure how to do a date range parameter. I am new to parameters. I have a field called WoShipLog.ShipDate and I want the report to ask the beginning >= and ending <= Dates.
  18. rmiller11

    Select all records if field is curret month

    What I am trying to do is if the date in POCMonths.PocMonth month of current date is = to print time then I want >= and <= of POCMonths.PocMonth records but only if there is a current entry for the print time month. For th elife of me I can't figure out how to do it. I can get >=...
  19. rmiller11

    Won't let me subtotal a formula, How do I get aorund it

    Here is what I am doing: M00: If DateDiff('m',CurrentDate,{POCMonths.PocMonth}) = 0 Then {@Sales} else 0 @Sales: ({POCMonths.FabRate}*{POCMonths.FabHr}) + ({POCMonths.MachRate}*{POCMonths.MachHr}) + {POCMonths.BOMcost} + ({POCMonths.EngRate}*{POCMonths.EngHr}) + {POCMonths.AdditionalProfit} +...
  20. rmiller11

    Auto updating Schedules

    Is there a way to have a public schedule updated in public folders calandar? Would like 5 people's personal calandars in outlook to update the public calandar when they make entries.

Part and Inventory Search

Back
Top