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!

Register Log in
  • Congratulations Chriss Miller 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. mcgettge

    Copy/Export from Access 2002 to Excel 2000

    Everytime I export to Excel, or even when I copy and paste into Excel, all of the fields come in as text. If I have a numeric field in Access, it comes into Excel in a general or text format. On my other computer, everything works normally, Excel recognized date and numeric and currency...
  2. mcgettge

    Store Transaction Logs

    I need to delete duplicate transactions from a 3.5 million row table. The transactions appear with a different transaction number, but have the same store #, account #, transaction $ amount, transaction type, date, and are within 60 seconds of the original. I don't know where to go. I know...
  3. mcgettge

    Excel Conditional Format

    That does what I need. Thanks for all the help.
  4. mcgettge

    Excel Conditional Format

    All of the formulas yield the same result, a bold format. I start with 13 columns with category locations, I add 4 more, I need to identify if any of the 4 new locations match any of the 13 existing. So I used the conditional formatting and used: Cell Value is equal +$B2 Cell Value is equal...
  5. mcgettge

    Excel Conditional Format

    I have a grid that I am using which is laid out in the following way: Store# - Bud - Coors - Miller 111 - A - B - C 112 - D - B - X 113 - A - R - G I currently have 13 categories and the location within the store. I need to add 4 more. If the new category replaces...
  6. mcgettge

    Excel Conditional Format

    The format I used was a simple bold, is there a way to copy everything into another sheet, keep the bold format and lose the conditional formatting so that I can then do the 4th? I will only be changing the values one time, so once they are identified by the conditional format, they can stay in...
  7. mcgettge

    Excel Conditional Format

    I am using an Excel file with conditional formatting, I would like to be able to use a 4th condition. Is there a way?
  8. mcgettge

    Tool Bars

    F11 was a simple answer which solved my problem. Thanks.
  9. mcgettge

    Tool Bars

    Whenever I open My Computer on Windows 2000 Professional, the toolbars are now missing. I have no File Menu or any of the others. How do I retrieve these?
  10. mcgettge

    Query Using Time/Date

    Exactly what I needed, thanks.
  11. mcgettge

    Query Using Time/Date

    I am working with a database for a trucking operation. I need to create a query that will find late deliveries. The problem that I am having is the information is being transmitted in the following format "2/9/2004 8:07:29 AM" and I am not sure how to write the query. I need to...
  12. mcgettge

    Multiple Values for a Field

    The problem with the default value is that it might change every 10 entries when there could be 1000 in a day. Instead of making the full 1000 entries, I would like to be able to enter 100 records with one of the fields being able to accept the 10 values for my package ID thus creating 1000...
  13. mcgettge

    Multiple Values for a Field

    Right now the table structure is very simple, there is only one. Everything is keyed in, line by line. There is a lot of repetition in the data entry which is what I am trying to eliminate. Could you explain the subform to me? I am not very familiar with its uses or creation.
  14. mcgettge

    Multiple Values for a Field

    I am trying to create a form that will allow multiple values for one field. There are 10 fields that will be entered, but 9 of the remain the same for a multipe (but varying numbers) entries in a row. I am maintaining records in a table for retail deliveries. The driver, date, vehicle all...
  15. mcgettge

    IE History

    I am trying to find a way running 2000 Professional to disable the ability to clear the IE history for certain users or even groups. I have a user who has a problem with clearing the history constantly on other users machines. Any help would be greatly appreciated.
  16. mcgettge

    Reports with Columns

    Is there anyone out there who can help?
  17. mcgettge

    Reports with Columns

    Can anyone help me?
  18. mcgettge

    Reports with Columns

    I am trying to create a report with columns. It works fine when I go "Down, Then Across" but when I choose "Across, then Down" it becomes a mess. Any suggestions onhow to keep the entire group together?
  19. mcgettge

    Query: Display Part of Field

    Thank you for the help....works perfect.
  20. mcgettge

    Query: Display Part of Field

    I am looking to write a query that takes part of a field and displays it. The problem is that the length is not constant. I have a table full of addresses with City, State ZIP in the same field. Using the left and right functions I am able to separate and create a field for State and ZIP...

Part and Inventory Search

Back
Top