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

  • Users: angelnthesky
  • Order by date
  1. angelnthesky

    Excel sheet with a batch file using the power of queries in Access

    Pseudocode of TOR 1. Start 2. Open up Access 3. Import excel 4. Read multiple pages 5. Append to a permanent Access table 6. Use qry to show individual archives 7. Produce a pivot table of archives 8. Filter a menu 9. A.import data b. Revise duplicates c. Export pivot table back to excel d...
  2. angelnthesky

    Excel sheet with a batch file using the power of queries in Access

    Using the power of queries in Access 2010 by linking an excel 2010 table gives me the results where exactly. In a query i linked In a table i linked Both. My request is to open it up and print it then, right. Ques. Can i open up the query linked to excel table to find my results? But i want...
  3. angelnthesky

    Excel sheet with a batch file using the power of queries in Access

    Excel 2010 once in Access 2010 has the power of queries, Its modified in Access 2010 to update all queries, what function does it help to also change the queries to Append. Should the excel 2010 file inside Access 2010 be linked before or after. Margarita
  4. angelnthesky

    Access button to import text file

    Hello, I need help programming a command button in Access 2010 to import a text file; (the code should have the (all range) delimiter) and by pressing the button, Access 2010 reading the text file should produce the file. Once inside Access, the text file updates my queries. Thanks, Marjorie
  5. angelnthesky

    Access form with buttons a userend press and out pops out updated queries

    My code does not work behind the button in my form. I wanted to create a button, importing an excel sheet in one step, for an end user. Then i wanted to create Append queries that also update from the modified excel table i imported. Can the combo pulldown list that holds all the Append...

Part and Inventory Search

Back
Top