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 strongm 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: pscad
  • Order by date
  1. pscad

    Antivirus for Fileserver?

    Trend makes a seperate version, ServerProtect. Installs WITHOUT a reboot.
  2. pscad

    Changing users permisions to access a mailbox?!?!?

    Are you trying to access this mailbox....secretly? First, get permission! Secondly, if you're in the Exchange Admin security group, and you're running OWA, you should be able to go to http://exchangeservername/Exchange/username. What version of Exchange are you running?
  3. pscad

    Firewall log entry

    Looks like it's going over port 80, so it may be from someone browsing to a site that is using a security cert from Verisign. When you access a secure site, it contacts the cert vendor to verify the integrity of the cert. Looks like your firewall is deeming it "unsafe". Have you had users...
  4. pscad

    External caller wants to page

    Thanks all. Your suggestions give me some things to try. Happy New Year.
  5. pscad

    External caller wants to page

    I have a VP that wants to be able to call in from home and page someone in the plant to call him back...can this be done? I understand that using CCR 2.0 will allow you to Park and Page, but what gets "paged"? Can the caller say something over the paging system? TIA.
  6. pscad

    Need to produce a multiple field prompt box to enter info in WORD?

    fumei, Can I get a copy of that userform sample you have? This is exactly what we've been looking for. Thanks.
  7. pscad

    Formual works if typed, but not if copied

    That was it! Thanks so much.
  8. pscad

    Formual works if typed, but not if copied

    Excel 2003. I have a formula that simply subtracts 2 cells (=G8-E8). If I copy and paste that formula to the next cell below, it appears to work (=G9-E9). However, it copies the result from the cell above. If I manually type in the formula (=G9-E9), it works fine. I've tried to copy and...
  9. pscad

    report on activity between 12 am and 8 am

    Yeah, I feel like a dork! I figured it out. TimeValue([EvnLog]![TimeDate])<#8:01:00 AM# maybe this will help someone else!?
  10. pscad

    report on activity between 12 am and 8 am

    I have a single table that has date and time info in one field, such as '6/2/2003 12:51:04'. What I am being asked to do is to report all activity on ALL dates but only that which happened between 12:00 and 8:00. The time is 24-hour formatted, so there won't be any confusion between midnight...
  11. pscad

    Error: 534 while running report

    Fixed it! It was a conflict of crpe32.dll versions. Hope this helps someone.
  12. pscad

    Error: 534 while running report

    Error running Crystal 8.5 report one machine, but not all machines. Both machines tested are running Win2k, accessing the same DB via the same version of the front-end program. The error I get is AFTER I choose my parameter field options, so I know it's at least reading the report. The...
  13. pscad

    Average Calculation On Text Field

    Because it's looking for a string? I don't know. I'll just try something else. Thanks.
  14. pscad

    Average Calculation On Text Field

    I have 2, neither of which is working. The formulas are: Val ('{TICKETACTIVITY.UNITS}') and if Val('{@UnitValue}') > 0 then 1 else 0 Thanks.
  15. pscad

    Average Calculation On Text Field

    Thanks Ken. Apparently I have a formula that is not eligible for summing, but I will put this info to good use anyway!
  16. pscad

    Average Calculation On Text Field

    Okay, I feel stupid, but I'm trying to do the same thing Nerdlinger is, and I am trying to implement what Ken has suggested, and I'm lost as to how to Sum a formula field. Sorry if you've already covered this, but this is the closest converstation I've come to what I want to do that I've been...
  17. pscad

    Crystal Reports-Citrix - Physical Database not found

    I've had this problem, and fixed it by placing the Crystal runtime files in the Windows\Crystal subdirectory of the users default home folder.
  18. pscad

    change case of data using UPDATE

    Thanks for the input. I'd seen this on another forum (may have been the one you directed me to!), but was unsure if that was what I wanted. One other question. I want to be able to apply this to multiple items. Do I have to run it 1 time for each product, or is there a way I can use the Like...
  19. pscad

    change case of data using UPDATE

    I apologize in advance if this has already been covered. I searched for what I wanted, and did not see the answer I needed. I have a table, products, with a column (name) that I want to update. I have some Names that are spelled in initial caps, and some all caps. My question is: How do I...
  20. pscad

    Parameter field limitations

    Thanks Ken. My next step was to try the Import function. Looks like that's what I will have to do. Any other way around the STATIC limitation? Using VB maybe? Thanks again.

Part and Inventory Search

Back
Top