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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ccv

  1. ccv

    Question on how best to parse text

    Programming??? Maybe left to the professionals!
  2. ccv

    Populating drop down boxes from a field on a form

    Maybe you should try the resources in your division before posting? They maybe helpful!!
  3. ccv

    Updating Access Linked Table from Excel

    1: Yes, but if the spreadsheet has been linked to another workbook then no. You must open the workbook and update it (either manually or through vba). 2: If you simply clear the contents of the linked spreadsheet the rows will be empty. You need to delete the rows.
  4. ccv

    Strange (#Deleted) appearing in table

    If you're linked to an oracle table read this: http://support.microsoft.com/kb/248186
  5. ccv

    Error: Operation Must use an updateable query

    Try deleting the linked table and re-linking. Make sure you select a unique record identifier
  6. ccv

    Converting spreadsheet to Access

    I don’t know of a way of doing this in Access but the Edit/Paste Special/Transpose will do it in Excel. The only problem is that you can only do one row (or column) at a time. The following uses two spreadsheets – The source file (wsSrc) and the destination file (wsDest). Here’s an example...
See more

Part and Inventory Search

Back
Top