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 Shaun E 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: IanThomas
  • Content: Threads
  • Order by date
  1. IanThomas

    'TransferDatabase' macro to import table from a p'word protected db

    Hi All, I'm simply trying to import a table from a password protected database into another database. I've used the 'TransferDatabase' macro command, which runs and prompts the user to enter the password. I type in the password, but nothing happens! No table has been imported & it's driving me...
  2. IanThomas

    Excel changes my text to a number because of an 'E'

    Hi Folks, I'm at that point in Excel again where I can't seem to find an answer anywhere! I'm dealing with a set of alphanumeric codes that I'm exporting from a seperate database into Excel as a CSV file. The problem occurs with some codes that begin with a number & contain an E. For...
  3. IanThomas

    Processing Autofiltered Data with an Excel Macro

    Hi Folks, My problem at the moment is that I need to put values into filtered cells using a macro, but leave those that are not shown alone. I am doing this at the moment by using a macro to auto-filter the data for a specific criteria, & then looping through each record (row) and getting...
  4. IanThomas

    Importing fields with more than one decimal from Excel

    I am stuck! I need to import data from Excel into Access. The problem that I have is that one of the fields is a number that contains more than one decimal. i.e. "6.1.1.2". I have tried changing the fromat to 'text'in both Excel & Access, but Access insists on importing it as a...

Part and Inventory Search

Back
Top