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 Mike Lewis 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. Gaudett

    How to make the array work?

    Actually your approach will slow things down. By inserting a formula like this you will be forcing the spreadsheet to evaluate this each time it updates....... With 40k like this it can take quite some time Terry
  2. Gaudett

    Dropdown list does not show all items

    Hi jsgs... Can you provide a bit more detail - for example, how are you populating the list? What is the validation? VBA code or bound source or a list on a spreadsheet? Thanks Terry
  3. Gaudett

    automate import

    I'm not quite sure what it is you are trying to do but if you are importing data to populate a table then try running a query rather than importing. For example, run a query from your Excel spreadsheet to obtain data from your Access data table. Terry Gaudet

Part and Inventory Search

Back
Top