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 Chriss Miller 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. JohnBOA

    Automated file uploading to Livelink folder

    I appreciate all the suggestions and now that I know there is a way to push a report to LiveLink, I fill comfortable to approach our LiveLink Admin with these suggestions and I will post our solution. It is good to know there is a group of professionals out there willing to help, Thanks. John
  2. JohnBOA

    Automated file uploading to Livelink folder

    Thanks Greg. I am new to LiveLink is there any documentation in LiveLink on how to use this PULL function? Thanks, John
  3. 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...
  4. JohnBOA

    How do I allow multiple users access to my db at the same time?

    Thank you Little Smudge!! With SHARED selected this work great. JJO
  5. JohnBOA

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

    Scott; Thank you! Thank You! Thank You! Did I say Thank You? This is exactly what I needed. Also I am adding some information on the "Camera Button" for those like myself that do not have this button. John Excel's Camera tool (i.e., a toolbar button with an image of a camera) is...
  6. JohnBOA

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

    I do not know what the camera button is. Could you explain it or tell me where I can find some information on it?
  7. 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...
  8. JohnBOA

    Why does my formula change?

    Yes. On each update I automatically run the query and update the area. The query can return 2-9 rows. John
  9. JohnBOA

    Why does my formula change?

    By opens I mean start Excel and open the same spreadsheet the next day. I use the same spreadsheet everyday. After a couple of days the #REF! shows up. This area that I am referencing is the area where MS Query returns its results.
  10. 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...
  11. 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?
  12. 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