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

    instrrev function missing

    hello: im trying to use the instrrev function in a select query. i dont see it in the list of available functions. i can use it in a module however. i would like to have this function available by default in all my access dbs. is there any hope? thanks blute
  2. blutimus

    copy cell's formula to another row

    hi i have a sheet that is created populated via a macro, and each time it may contain a different number of rows. in the last row i have 8 cells for which i want to display the contents (updated in real time, as they will change as sheet is modified during use, it is a formula based on the row...
  3. blutimus

    run macro once for each row in a table

    hello i currently use a form with a dropdown list to choose a customer, then hit 'go' on the form to run a macro which opens a make table query then runs a module to export it to excel. the customer comes from a table. i would like to figure out how to run the macro for each customer in the...
  4. blutimus

    loop to run a macro for each value

    hello i hve a macro 'macro1' which i normally call from a form. the form passes a value 'cust_id' from the customer table. the macro runs several queries which use cust_id as a parameter, makes a table with the results, then calls a function which transfers the table to a spreadsheet. then i go...
  5. blutimus

    need to copy/paste query into excel

    hello. first time caller. i need to copy the results (datasheet) of an access query onto the clipboard so i can paste into an excel sheet. i have considered exporting and transferring, and really would like to give THIS method a go. i dont know much so i'm hoping for a 'turnkey' solution to get...

Part and Inventory Search

Back
Top