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 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: ccv
  • Order by date
  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...

Part and Inventory Search

Back
Top