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: *

  1. newbiewonkinobie

    Date-sequence primary key

    I am in the process of moving our RFC/ECR (Request for Change/Engineering Change Request) data from Excel to Access. The problem I am having is creating the primary key. Our RFC/ECR number is a combination of YearMonthSequence, meaning the current year, the current month, and the sequence of...
  2. newbiewonkinobie

    Excel to Access without linking

    I want to import Excel into Access without linking the 2 together. I followed the directions on: http://office.microsoft.com/en-us/assistance/HA010546501033.aspx "Creating a new Access database from an Excel spreadsheet" After opening the Excel file in Access with the import wizard (I can't...
  3. newbiewonkinobie

    Macros not working anymore

    For some reason, macros are no longer working on one of our computers. We are running Solidworks 2006 SP1.0, Windows XP Pro, and Microsoft Office 2003, and McAfee Viruscan. I am not sure if a Windows automatic update changed some security settings, or if it is a McAfee changed script settings...
  4. newbiewonkinobie

    Table replacement

    After reading several posts here, I noticed that tables are not recommended anymore; typically "divs" or something else is recommended instead. I know how to layout a web page with tables using a header, and 2 columns below it. For example the left column being 30% of the screen, and the right...
  5. newbiewonkinobie

    Retrieve rows in Excel

    On sheet 2 there are 7 columns: A1 is Job # B1 is Client Name C1 is Product Ordered etc. On Sheet 1, in cell A1 I want to enter a job #, then it will copy all rows with the matching job #'s from Sheet 2 to Sheet 1. Any suggestions? Flores
  6. newbiewonkinobie

    Convert letter value to number

    I have an item number, for example: in cell A1, which is 1224-A25, and I have a cell next to it that strips the last numbers after the first 4 digits. In column B, I have tried this 2 ways: LEFT(A1,4) and also: =LEFT(A2,FIND("-",A2)-1) I'm using conditional formatting to highlight the...
  7. newbiewonkinobie

    Automatic inventory

    I have to make a somewhat simple "automatic" inventory in Excel, but am having trouble getting this accomplished. Basically I have the following: Date Description In Stock Shipped Balance 8/15/03 8'Units 650 450 200 8/17/03 4'Units 850 500...
  8. newbiewonkinobie

    Spanish spellchecker for Word 2000...

    Does anyone know how or where to get a Spanish spellchecker for Word 2000? I am in need of writing documents in Spanish from time to time. I can speak it and write somewhat in Spanish, but I would like a way to double check it. Thanks in advance.
  9. newbiewonkinobie

    Search specific folder in XP Pro...

    I am having trouble searching only in a specific folder in Windows XP Profesional edition. In Win98, I could search for a word in any specific folder. In WinXP, I can only search either drive A, C, D, or My Computer. For example, if I want to look in a folder named "Drawings" for a...

Part and Inventory Search

Back
Top