Recent content by adamf

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...

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

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...

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

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

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...

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...

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...

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...

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...

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

Any ideas, people? Adam F Solaris System Administrator

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...

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

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