Search results for query: *

Hi, I have the task of creating an excel formula to spread total value for each contract over 24 month columns....i.e 2010 and 2011. Based on start date. The amount needs to be spread Monthly,quarterly, semi-annually or yearly dependng on the terms of the contract. I am not sure if this can be...

Hi, I have the task of creating an excel formula to spread total value for each contract over 24 month columns....i.e 2010 and 2011. Based on start date. The amount needs to be spread Monthly,quarterly, semi-annually or yearly dependng on the terms of the contract. I am not sure if this can be...

Hi, I am trying to generate a diagram of tables and a relationships of an existing SQL 2000 database. What is the best way to accomplish this ...I would appreciate your help."Diagrams" option in Enterprise Manager shows no items. Thanks Gary

Hi, I am trying to generate a diagram of tables and a relationships of an existing SQL 2000 database. What is the best way to accomplish this ...I would appreciate your help."Diagrams" option in Enterprise Manager shows no items. Thanks Gary

Hi, I am in the process of linking Excel spreadsheet with a SQL database using Connection manger. I have few concerns about this: 1) Is the ODBC connection link a two way connection? 2) If yes, if I update or change any field will it overwrite the information in the SQL databse? Looking...

Hi!! I am looking for an excel fomula to accomplish the following. I have two cloumns with information and if I have matching value in the 2 columns I would like to assign a value to the corresponding cell otherwise it will update the cell with what's in column2. Example: Column1...

Hi, I am trying calculate due date of invoices based on the invoice date. for e.g if the date is 1/13/05. I was wondering if there is formula that will automatically calculate the due date 30 and 45 days from the date of the invoice. Any input in this respect I will appreciate, Thanks in...

Hi, The regular backups just don't inititate, it remains "scheduled" even after the start time. If they do run, they are listed as cancelled due to the service shutdown. I am unable to find an error log or any other indication to show where the problem is originating from.I am using...

Hi, My backup exec 8.6 shows the tapedrive in offline status. The backups were working perfectly for the last few months. Suddenly now the tape doesnt eject and the scheduled job remains on loading tape status for hours. The lights on the drive are illuminated so it not a power supply issue. I...

I'm having a peculiar problem with my backups using Backup exec 8.6 ver, although the byte count is close to normal i.e 10gb approx full and 3gb for differential The job status shows as failed due to the following reasons in the job log printout: Difference encountered in file data The file...

Hi, I am having trouble connecting to terminal services on a Windows 2000 server from client computers (4 workstations) running windows XP. I get the following error from 2 workstations while the other 2 work fine. 'Remote desktop disconnected' The client could not establish a connection to...

Hi, I am looking for method to generate a report from my website. i.e the number of hits, number of links that are frequented, most accessed link etc. How is it possible to do this, do i need a third party software to accomplish this? Please let me know, Thanks, Gary [3eyes]

Hi, I need help with defining User defined queries where the user can simply use a combo box to select his criteria and generate his own report. I have 4 tables Inventory Receipt table, Vendor table, Parts Table and Status Table. i have to design it in such a way that anyone can chose a...

Hi, I would like to know if there is a way to start auto number ID from e.g 5674. Cause the last database had lot numbers that stopped at this number so I have to initiate the new database to begin with 5674. The form i'm making should increment this number everytime the next record is opened...

Hi, I am unable to transfer MS Word Files from my computer, evry time I copy it to another directory I get the error-cannot copy file-path too deep. I also noticed that there are some temp word files open with the corresponding file names. These temp files don't close even when I close the...

Hi! I am having a problem with the HP Tape Drive I have.Its HP6400/2000 tape drive using 4mm DDS tapes.The problem is ,it runs the cleaning tape perfectly meaning the spoolers pick up the tape and move it over the head. But when I insert a normal tape to backup, the spoolers dont pick up the...

Is it possible to enable outlook web access on SBS 4.5 using exchange 5.5 and the Internet Information server?The system is connected to the internet through a T1. Thanks, Gary

Hi , I can import tables from my accounting software into Access 2000. I need to create barcode labels using partID and serial number from these tables. What should i do to convert this data to print it in barcode format on a barcode label. Looking forward to a response, Gary

Hi!, I have an excel spreadsheet that has fomulas and data on one sheet. Its file size is 28MB, from Column GJ to Row 6267.I know that excel works optimally when its less than 15 MB file size. I tried breaking it into sections and pasting the information on seperate sheets. Now my problem is...

Hi, I have this worksheet that imports a file- bom.rpt. Now i want to replace this file with an excel or word document. I made changes to the code accordingly but when it imports it works in the begining but later the data becomes garbelled. I have little practice with VBA and the using series...