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...
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...
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...
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...
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...
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.
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...
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?
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.
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...
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...
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...
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...
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?
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...
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...
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.
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 >=...
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} +...
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.
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.