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 Andrzejek 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. rossmcauslan

    Marking of Cache Hit Traffic on 3845 with CE

    Hi, We have a network deployed with a Cisco 3845 Router with the NM-80GB Content Engine installed. We also have a device on the network that will be doing traffic shaping. The issue we are seeing is that the total level of download traffic exceeds the link by as much as 2Mbps due to the CE...
  2. rossmcauslan

    Only retrieve last history item

    I have two tables in my db called case and history. There is a one to many relationship between the caseid field in both tables. The case table holds details on each case within the database and the history table holds details on the history of the case. History contains the following fields...
  3. rossmcauslan

    Terminal Services and Printer Redirection

    We have a Windows 2000 Server which is running Terminal Servics. Printer re-direction is working fine with the clients exception of one printer. The printer is a Canon MPC600F which is a fax, scanner and printer all in one effort. I have installed the latest drivers off the web and installed...
  4. rossmcauslan

    Linking data from an excel spreadsheet

    I tried that and even tried 2 new smaller files ( the spreadsheet I'm working on contains 3500 rows). But obtained the same result.<br><br>This is getting quite frustrating - I know I can just keep importing the tables but it is very not useful for the users when they want a report on the...
  5. rossmcauslan

    Linking data from an excel spreadsheet

    I tried that and even tried 2 new smaller files ( the spreadsheet I'm working on contains 3500 rows). But obtained the same result.<br><br>This is getting quite frustrating - I know I can just keep importing the tables but it is not useful for the users when they want a report on the...
  6. rossmcauslan

    Linking data from an excel spreadsheet

    I have changes all of the formating in excel to text but in Access when the table is linked it is still shown as #Num!<br><br>Any other ideas??<br>Cheers<br>-------------<br>Ross McAuslan<br>IT Consultant<br>CIA Ltd<br><A HREF="mailto:ross@c-i-a.co.uk">ross@c-i-a.co.uk</A>
  7. rossmcauslan

    Linking data from an excel spreadsheet

    Hi,<br><br>I am trying to import some data from an Excel spreadsheet into an Acess database but am having some problems. If I user the import function when creating the new table the data appears fine. However as the spreadsheet is constantly being changed I would like to set up the table as a...
  8. rossmcauslan

    Simple Query 2 tables - Am I missing the point completly??

    I have a training database which I maintain. Within this there are two tables that I am having problems with. One holds information on all of the possibles training courses that staff can take and the other holds the data on which members of staff have been on these courses. I need to construct...
  9. rossmcauslan

    Excel 97 comments

    We have an excel document with about 2000 rows in it. We add comments to the second column. However, sometimes when the documnbet is reopened, all of the comments appear way out of place and have to be manually returned to the right place. This obviously takes ages when you have 1500 comments to...
  10. rossmcauslan

    Modem volume control

    I have recently installed an older internal modem in our NT server. It all works fine apart from the fact that it is too loud! In the modem properties the volume control is grayed out. Is there standard commands which you can set in the initialisation stage to set the volume control.<br> <br>...
  11. rossmcauslan

    Advanced Calendar Controls

    I have to convert our Delphi 2 database to Access 97 so that it is in the same format as the rest of the company databases. <br> <br> The database poses no problems in terms of the relationships between the various tables etc. However my problem is that the Delphi uses a grid to represent the...
  12. rossmcauslan

    NT modem sharing

    I need to share the modem in our NT 4 Server with three other people on the network. What is the best way to do this and what software do you recommend?<br> <br> Thanks <br> Ross
  13. rossmcauslan

    Excel 97 - graphing subtotals

    Cheers for you help, I'm slowly getting there. The right data is now being plotted but only every second catagory on the x-axis is being shown. If you make the graph small so that the text is unreadable, the missing catagories appear.<br> <br> Any ideas??<br> <br> Ross
  14. rossmcauslan

    Excel 97 - graphing subtotals

    I need to be able to graph the number of occurances of the various reasons for a lost enquiry spreadsheet.<br> <br> I used the subtotal function to count the number of reasons. eg. too expensive, late ordered. This all worked fine. I now want to create a bar graph to show the information...
  15. rossmcauslan

    Content Index Service won't start in NT 4 Server

    When ever our server is booted, the following service does not start. The following is from the event log:<br> <br> The Content Index service failed to start due to the following error: <br> The specified service does not exist as an installed service.<br> <br> <br> What is the content index...
  16. rossmcauslan

    Access security

    Thats what I thought, Do you know if there is any way of preventing the database window appearing if you hold right shift down when loading for users without admin privelages in the database workgroup??<br> <br> Cheers for your help<br> Rosco
  17. rossmcauslan

    Access security

    I need to secure an Access 97 database from being copied over to an other computer. I have applied user level security settings but my boss would like to know of there is a way of preventing the access file being copied under Windows 95<br> <br> Any suggestions??<br> <br> Cheers<br> Ross...
  18. rossmcauslan

    Secondary x-axis in excel

    One of our users is trying to create a graph in MS Excel 97. His graph is a scatter type and would like to display 2 x-axis which depicts the data in two formats. eg. 1/t and degrees. It an Arrhenius graph.<br> <br> How is this done?<br> <br> Ross McAuslan<br>

Part and Inventory Search

Back
Top