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

    Automated file uploading to Livelink folder

    Is there anyway to automatically upload a file into LiveLink? I create a Excel workbook everyday and want to upload the file into LiveLink, I used the GLOBAL Icon to point to a file which works great as long as you have access rights to the server where the file is located but if you do not you...
  2. JohnBOA

    How can I copy a range of cells from one WS to another WS

    I have this worksheet (WS) that has many queries and formulas and it automatically starts everyday at 6AM. I need to email the users a copy of this WS but not all the queries, only the results of the query. I thought if there was a way to copy (not manually copy and paste) the original WS and a...
  3. JohnBOA

    Why does my formula change?

    I am using MS Query to get external data and return it to cells A94 through B100(column A is the return name column B is the return value) My formula in cell A1 starts off like this: = IF(A94="Rutkowski",B94, IF(A95="Rutkowski",B95, IF(A96="Rutkowski",B96...
  4. JohnBOA

    I can only see system tables in OracleDB via MS Access link

    When I set up a link in MS Access to connect to a Oracle DB table I am not able to see the table I need but I can see all the system tables. What do I need to change to prevent the system tables showing?
  5. JohnBOA

    How do you automaticaly set a prompt to display the LAST WEEKDAY

    How can I set a prompt tp automaticaly display the last week day Monday, Tuesday, Wednesday, Thursday, Friday? Not Saturday or Sunday. I need to create reports and the date selection must be yesterday. If today is Monday yesterday was Saturday or Sunday I need it to be Friday.

Part and Inventory Search

Back
Top