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 SkipVought 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: adamf
  • Order by date
  1. adamf

    EXCEL - Selct a list of names with radio button, then email them

    I am trying to create a fault reporting form in excel, that depending on the nature of the fault needs to be emailed to any number of people. I have a list of all the people who may need to be mailed the report, but wonder if anyone can help me to: 1) Add a tick-box or radio button to each...
  2. adamf

    EXCEL - Selct a list of names with radio button, then email them

    Glenn - I'm not really sure what you mean by embedded objects, sorry. The form will be completed using a mix of drop-down field and freeform text. Ideally the report will then email itself, ideally as a PDF file to the selected users. Adam F Solaris System Administrator
  3. adamf

    EXCEL - Selct a list of names with radio button, then email them

    I am trying to create a fault reporting form in excel, that depending on the nature of the fault needs to be emailed to any number of people. I have a list of all the people who may need to be mailed the report, but wonder if anyone can help me to: 1) Add a tick-box or radio button to each...
  4. adamf

    Merging data from similar fields

    Text to columns would indeed just give me "Yeovil". How would I then concatenate the data so that I only had one line entry for yeovil with the sum of the data for each entry? Adam F Solaris System Administrator
  5. adamf

    Merging data from similar fields

    I've already done a sort, so I can see all the "Yeovil" entries together. The data needs to go to the Board in as compact a format as possible, so I still need to clear it up further..... Adam F Solaris System Administrator
  6. adamf

    Merging data from similar fields

    Hi, I have a spreadsheet that lists a number of locations that containers have been imported to or exported from. The problem is that the people who supplied the data have enterend numerous rows for similar locations, for example: Yeovil 1 3 4 Yeovil, Somerset...
  7. adamf

    Date format in pivot table

    I am trying to create a simple pivot table that will produce some monthly reports. The main excel worksheet is used by some users with only basic excel skills, so I want to keep things simple for them. To this end, they enter a date in dd/mm/yyyy format. I have then added a column that...
  8. adamf

    Copy a line dependant on identifier in new workbook

    This doesn't seem to get around the problem of getting the data from another named workbook If it worked, what i'd want the formula in the cell where the data is to be imported would read: =Sheet1!A(COLUMN NUMBER DEFINED BY INTEGER IN THIS WORKBOOK) Any more ideas? Adam F Solaris System...
  9. adamf

    Copy a line dependant on identifier in new workbook

    I am trying to create a spreadsheet that pulls data into a form (actually another workbook). Which row of data is imported is dependant on a single integer input on the new workbook. For example, I want cell Book2!A2 to display the data shown in Book1!A4 so the formula needs to read the...
  10. adamf

    getpeername: Transport endpoint is not connected

    When the page is called now (with authentication off), the following error message is diplayed at the top of the served page: [Thu Jan 9 17:50:09 2003] [error] Cannot resolve host name ops --- ignoring! HTTP/1.1 200 OK Date: Thu, 09 Jan 2003 17:50:09 GMT Server: Apache/1.3.12 (Unix) Keep-Alive...
  11. adamf

    getpeername: Transport endpoint is not connected

    Using .htaccess and .htpasswd. Incidentally, I have just removed all authentication & got the same results! Adam F Solaris System Administrator
  12. adamf

    getpeername: Transport endpoint is not connected

    Any ideas, people? Adam F Solaris System Administrator
  13. adamf

    getpeername: Transport endpoint is not connected

    I have a problem with an intranet site, that is basically denying access to MSIE 6 and Mozilla. The site is password protected - MSIE 5.5 and below ask for authentication ok, but 6+ and Mozilla just bomb out and serve a 401 error page. The only entry in the error log is getpeername: Transport...
  14. adamf

    su without password for non root user

    Pete - See my FAQ on configuring sudo.... faq80-1623 Adam F Solaris System Administrator
  15. adamf

    CA Unicenter reporting of SAP R/3 batch

    Hi, I am invesigating the possibility of using a SAP agent to monitor & report on SAP R/3 batch failures. Does anyone have any ideas on the best way to proceed. I have zero SAP savvy, so please, no mega-technical answers!! Best Regards, Adam Forrest Adam F Solaris System Administrator
  16. adamf

    Mounting an iomega zip drive - SUSE Linux

    Chris - It is USB Adam F Solaris System Administrator
  17. adamf

    Mounting an iomega zip drive - SUSE Linux

    fluid11 - No trace of the zip drive or dev/sda4 in dmesg... Any other ideas?? Adam F Solaris System Administrator
  18. adamf

    Tracing an IP address

    You can use VisualRoute at http://visualroute.visualware.co.uk to do a tracert. This app traces the destination IP address from the Visualroute server in Richmond, so it is untraceable back to you. Quite a neat little app, I think!! Adam F Solaris System Administrator
  19. adamf

    Rescticting user access

    olded - Magic! Just the job. Many thanks. Adam F Solaris System Administrator
  20. adamf

    Rescticting user access

    mrjazz - I'm with you!! It wasn't the use of sudo that confused me.... I tried to su to fred from another non priveledged account, but that crapped out. So obviously this solution will work using sudo. So... What would you do if sudo was not installed on the box?? Adam F Solaris System...

Part and Inventory Search

Back
Top