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 Wanet Telecoms Ltd 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: Pistol
  • Content: Threads
  • Order by date
  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

    I have two date/time fields that I am combining within one formula. Both fields contain both a date, and a time, and I need to combine them and format them. Example The database gives me this: Field 1: 8/24/03 0:00 Field 2: 00/00/00 12:00 Field 3: 00/00/00 13:00 I need to format like the...
  3. 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...
  4. 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...
  5. Pistol

    Need HelpHooking up Tape Drive to Array Controller

    Attempt One: I am trying to kook up two different tape drives to one server, and split the backup load accross the drives. First I had Daisy Chained the two drives together, and could not get ArcServe to operate correctly, it would only see one of the devices. The devices were hooked up, and...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. Pistol

    How to add a link to every page in site

    I need to add a "Feedback" link to every page, about 300 pages. In Front Page you can do it by adding a border to the bottom of every page in the site, and automate the process. Is there anyway in Dreamweaver to automate this process? I have to put it on HTM,& ASP files. Thanks
  11. Pistol

    How To: Format exported data in a text file

    I am tryinng to export one record at a time from a query into a text file that has to be in a certain format in order to be used by another program. Here is the example: When I export I need the column headers to be the row, and the txt file to be in a list format. Instead of having the...
  12. Pistol

    Running Delete Query as page loads

    I know this can be done, but I'm very new at it and having a hard time with it. I have a page that displays the results of an Access database table. When that page loads I want it to run a query to delete expired records before it loads the table. I imagine that I need two ASP files to do...
  13. Pistol

    Checking to see if page has been updated since users last visit.

    I have been looking, with minimal luck, for a java script that will display a message on a page that will notify a user if a page has been updated since their last visit. Here's what I want to do: Browser: IE 5.0 Senerio: Corporate Intranet, has "Global" pages and "Local...
  14. Pistol

    Error - E3406 - For no apparent reason

    Version: ARCserve 2000 Advanced Edition - ARCserve 2000 Standard install, no patches, or upgrades made OS: Win 2000 SP1 Issue: Backing up Fileserver Certain sharded folders on our network are having issues getting backed up (Including my own). I am getting Error - E3406 on all of these...
  15. Pistol

    BATCH file to Automate Upload of web site

    First off, I am not sure where to post this, but here it is: I am trying to get my hands on a batch file that will start explorer, or ftp software, then upload my site to it. I have a schedual program that will start the bat file, but I need the bat file to go to the site log on, and copy the...
  16. Pistol

    IF...Then to Enable and disable controls on a form

    I need help creating an if then statement to disable a control on a subform., and enable others. Here is the logic. If option 1 on subform 1 (on form 1) is checked (or true), I want to disable option 2,3,4, and 5. If option 2 is checked, (or true) I want to disable option 1,3,4, and 5. Thanks...
  17. Pistol

    Looking for Browser based Project Management Solution

    Does anyone have any suggestions on some (Cheap) web enabled project management solutions. We have considered Project Central, but don't need something that extensive,or something requiring a license on all the machines accessing it. Thanks
  18. Pistol

    Copy/Paste from one bound text Box to another

    I have a form containing: Name, address, city, state, et cetera (for "SoldTo" information). If the "ShipTo" information is the same as the "SoldTo" I would like to copy the "SoldTo" fields and paste them into the "ShipTo" fields. This way the...
  19. Pistol

    Hyperlink to Outlook "Meeting Request" form in Outlook 2000

    I have a conference room reservation system on our company intranet. I have a "Send Email" option that prefills an email with the subject and some text. I would like to directly hyperlink to the "Meeting Request" form in Outlook from the webpage as opposed to the email form...
  20. Pistol

    Query to retrieve the most recent Record

    I need to get a "Last Modified: XX/XX/XX" displayed on an ASP file that generates a table containing results from a database. Because this isn't possible in the current version of Active Service Pages I have decided to query the database to display the information I want. Example...

Part and Inventory Search

Back
Top