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!

Register Log in
  • Congratulations derfloh 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: *

  1. Pistol

    VBA Macro to Program Cell Value based on another cell

    I'm not sure where to get started on this, but this is what I would like: If cell (X3) contains VT, or, NY, or, NJ, or PA,... then Cell (T3) is NE If cell (X3) contains GA, or, FL, or, AL, or PA,... then Cell T3 is SE et cetera. I need to determine a Region based on the value of a state...
  2. Pistol

    Format a date field from within the formula

    Good stuff, thanks for the formula help
  3. Pistol

    Format a date field from within the formula

    ...8/24/03 12:00-13:00" Once I have combined the fields in the formula I cannot format the output. Here is my formula (without any formatting) ************************************************************ {BSACTIVITY_ttx.startdate} & " " & {BSACTIVITY_ttx.starttime} &...
  4. Pistol

    How to quick-erase a tape in a library before a job starts?

    This is from someone else: Batch File to Erase tape before job runs: I wrote a little batch file called taperase.bat which I run manually to erase all our 8 drives prior to backup. You use the TAPETEST utility within the ARCserve directory. Just change to ARCSERVE/ARCSERVEIT and look for...
  5. Pistol

    Browser detection

    Look on the internet for an extension that will detect the language of the client browser, then tell the extension to redirect to your other pages based on what language is detected. Try These: http://www.dmxzone.net/ShowDetail.asp?NewsId=1034 http://www.hotscripts.com/Detailed/8214.html...
  6. Pistol

    Suppress security prompts in Outlook when using Mail Merge

    This isn't anything new, but I can't find the answer... I need to be able to automatically send emails with Outlook via other applications without getting security prompts. Ever since the Outlook e-mail security update, and/or Office SP2, Outlook will prompt you with security prompts everytime...
  7. Pistol

    Recommended NT 5 Reboot Intervals

    I'm having issues with some of our servers crashing (at all the wrong times), i'm guessing that a reboot at regular intervals would help out, and increase system performance. I also have a file server (windows 2000 server) that is low on disk space, and after several weeks is becomming heavily...
  8. Pistol

    Need HelpHooking up Tape Drive to Array Controller

    Thanks, that seems to work
  9. Pistol

    Need HelpHooking up Tape Drive to Array Controller

    ...Array. Windows is detecting, and installing the drives, but ArcServe is having a hard time with it. When I click on the drive I get this response: ***************************************************** This is a shared device on a Distributed server and tapeengine is unable to connect to...
  10. Pistol

    Running Concurrent Backup Jobs

    I have it set up like this (two devices, two jobs, start times slightly apart). I'm still having problems, I'll recheck everything, and recreate the jobs. Thanks
  11. Pistol

    Running Concurrent Backup Jobs

    I have hooked up two tape drives on the same computer (to two different SCSI cards, one on the Array, and one on the mother board). I am trying to run two concurrent backup jobs in Arcserve, one to each tape drive. To date I have been unsuccessful, has anyone ever pulled this off, or is there no...
  12. Pistol

    Automatically Naming a report based on Field Name at save prompt

    I need help naming a report. Currently I am giving the option to run a report based on the current record. The report is based on a query that will select the current record. When the users save the report I would like it to automatically name the report based on values in the current...
  13. Pistol

    Copy Form Field to Subform Field

    It worked, Thanks
  14. Pistol

    Copy Form Field to Subform Field

    ...from "TB_ACTION". There is a "One-To-Many" relationship between the tables, and forms. Here is the code based on your example. *********************************************************** Private Sub InOpSndReplace_Click() Me.ShipToNameAWReplacement =...
  15. Pistol

    Copy Form Field to Subform Field

    I'm trying to copy information from a field in a form to a field in a subform (all within the current record). Here's what I have been using to accomplish the same thing between two fields within the same form. Me.ShipToCustomerName = Me.SoldToCustomerName I know I have to name the form...
  16. Pistol

    Passing value/variable from a form to a report

    Don't know if it helps, but I have a report that is generated based on the current record in a form, then exported. I'm using a macro to pass the current record (the variable) to a report that is based on that parameter. Respond with your email, I'll send it to you. You are more than welcome...
  17. Pistol

    Won't back up image files

    The Job Engine logon. Thanks again.
  18. Pistol

    Won't back up image files

    That seemed to do it, I've been scratching my head for so long Thanks
  19. Pistol

    Won't back up image files

    Thank's I'll let you know how it truns out
  20. Pistol

    Won't back up image files

    I'm running Arcserve 2000 SP3, and I am still having issues backing up image files, has anyone ever had issues backing up images? The error is a "Sharing Violation", but the files are not open, or in use by any other service, or program. I know I can get the open file agent, and that...

Part and Inventory Search

Back
Top