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 TouchToneTommy 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: AP186
  • Content: Threads
  • Order by date
  1. AP186

    Excel Locking cells on save/autosave

    Hi I need to be able to stop my users amending historical data once the workbook is saved. Is there a way of locking the cells on an 'autosave' or 'save' function? Many Thanks in advance
  2. AP186

    Conditional Formatting based on conditional formatting

    I have a spreadsheet with 5 columns, all data in these cells are dependant on conditional formatting to create a traffic light scenario. However I need the 6th column to 'count' the number of red cells in the row and if there is more than one instance, then format the 6th column cell as red. I...
  3. AP186

    date/time range across two days

    Currently using Crystal Reports 8.5 If have two fields within a database (date) and (time)which are populated by wifi scanners. As a working shift covers from 21:00 to 05:00 the following day. I need to be able to produce a date/time range so I can analyse the number of scans across shifts. Any...
  4. AP186

    Sorting by Date and Time fields

    The working day here is 05:00 to 05:00 How do I select daily data based on this format. 05:00 hrs Monday to to 12:00 hrs Saturday?
  5. AP186

    Two date ranges

    Tech User... thats a laugh Probably a really basic solution but can anyone help...... I need to show a series of amounts by two date ranges for comparison... . Date 1 Date 2 Dept 1 Qty Qty I have created {@1st date range} in Date (2003, 10, 01) to...
  6. AP186

    Autonumber Problem

    I am not an Access user but I have created a basic database with an autonumber primary key within the table. Due to testing etc the autonumber has obviously incremented accordingly. Is there a simple way of resetting this value to zero/01
  7. AP186

    exhange 2000 server - email tracking

    Is it possible to send copies of e-mails sent/received from multiple system e-mail adresses to one particular individual without them being 'tracked' by outlook when the e-mails are opened or read.

Part and Inventory Search

Back
Top