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

    Excel 2003 PivotTable Calculated Item

    Hello ... I create a pivot table from a data spreadsheet no problem. When I add a calculated item I start running into problems. My Data basically looks like this ... PLAN LOCATION DESCRIPTION QTY 401 A1-A2 Dig 5 402 A2-A3 Place 7 And so on ... when I...
  2. BellKev

    Excel Data Manipulation

    Hello, need some help/guidance... I have a spreadsheet, that spreadsheet basically summarizes work operations on a construction drawing. The idea is that I have someone go through a workplan, and populating this spreadsheet based on the drawings. My columns are somthing like "PLAN DESCRIPTION...
  3. BellKev

    Comparing Lists in Excel

    Good Afternoon ... I have two columns ... what I want to do is compare the two columns, for every entry in column A that isn't in column B I would like to copy that data to a third column ... Anyone help?
  4. BellKev

    Excel 2002 - Make a List

    Ok ... here's the situation ... I have a column1 with several repeating names, what I want to do is create another, column2, with every distinct name listed (Kind of like the dropdown menu for the AutoFilter. Any suggestions??
  5. BellKev

    Form Displaying Wrong Column

    Hello ... I have a lookup field with 3 columns. The correct column is getting stored on the base table, However the field on the form is displaying the ID number ... not the actual field data ... I know this is really easy to fix, I'm just having a mental block this afternoon ... Kevin
  6. BellKev

    Highlighting NEW Information on a Form

    Hello ... I track many projects for my client using Microsoft access. Every friday I export my tables into a Microsoft excel file for their use (As that is what they are familar with). Traditionally they used to get new updates (I.E. Updated dates and comments) bolded for anything added...
  7. BellKev

    Outlook - Copying Messages to HD

    Hello ... Not sure if I'm doing something wrong ... looking for some help. When I "Find" an e-mail in my inbox is there any way that I can then copy that to one of my local folders? When I try with the search results I get an error message saying "Can't move the item." Any idea why this is...
  8. BellKev

    Check Box In Excel 2002

    Good Afternoon Folks ... I have a "Check Box" control in Excel 2002. Is there a way I can change the check mark to an "X" ... or maybe somehow cause the fact that the box is checked become more apparent? I only ask because I have had people complain that the check mark is hard to see when a...
  9. BellKev

    Excel 2002 - Auto Populate?

    Good Morning, I am trying to auto populate some cells based the value chosen in a drop down control. Is this possible in Excel ??
  10. BellKev

    Calculated Date Fields

    Hello, I'm putting a database together for some people at my office. I want to populate some fields with calculated dates based on a date that is input. How would I do this? Is there anyway to only let it count business days (I.e not include weekends or holidays)? Any help is great.
  11. BellKev

    Specifying a Runtime Query

    Hello, If I wanted to search a date field in my database but ask the user to specify the month at runtime, how would I do that?
  12. BellKev

    Access Security

    Hello, I have an access database in Access 2000. I have used the security wizard to secure this database. Now when other people go to try and use the database they are told they don't have the proper permissions. Any suggestions on how to fix this? They don't even get asked to enter a...
  13. BellKev

    SQL Statement Help

    Good Day, I want a query to look at another query. What I want to do is count the number of records with a given year attached to them an them display the number of records for those years. The output I'm looking for is below ... 2002 5 2003 10 2004 3 Can anyone help me with this?
  14. BellKev

    User Control in Access

    Hello, I am using Microsoft Access 2002. I want to be able to have others access a database I have put togther. Now I want to allow others to View the tables and information in this database but not add or edit any information. I have tried using the wizard but when I start up the database...
  15. BellKev

    Printing Multiple Sized Pages from One File

    Good Day, I currently have 8.5" X 11" pages in the same PDF file as 11" X 17" pages. I would like these pages to print to the correct size automatically. How do I do this?
  16. BellKev

    Linksys Wireless B Network

    Hello, I have a wireless-B Linksys Router and PCI card. I find that the wireless connection is active for like 5mins then I lose the connection and have to reconnect again. Anyone know why ?? If I upgrade to Wireless - G would this continue ??
  17. BellKev

    Memo Field Data Entry

    Hello, I have set up a very basic database to replace a series of Excel logs that my work group uses. I have information that I want to enter in a memo type of field. Is there anyway to start a new paragraph in that field (Like pressing "Alt-Enter" in Excel) ?? Any help is appreciated ...

Part and Inventory Search

Back
Top