Recent content by ckennerdale

Does anyone know of a good off the shelf time management package where multiple employees input time spent on multiple projects. Reporting is required on time spent per project and either comparable with predicted/ estimated time or downloadable to excel. Cheers Caspar Kennerdale

Has anyone experienced problems with MX 2004 and NT. I know the program itself doesnt run on it, but thought tat perhaps the .exe projector would still run. Unfortunalely I keep on getting the message 'entry point not found....' has anyone had any experience of this or know of away round it...

We are looking to send email newletters with html pages and was wondering what limitations there were with the html. Things we are assuming- - no scripting - absolute links to all external files - text only version of the emails Is it a case of if the email client can view and has HTML turned...

The thing is when I hide 10 rows or coloumn, then 10 more appear-it is almost like I create them automatically. The only 'known' formatting was a select all and designate a background colour when I started. But it seems the that select all counts for all cells created after the select all...

One thing I cant seem to solve is the ability to limit the size of a worksheet to the amount of data there is. For example all my data fits with an a4 sheet, but whenI go to prit preview it says the worksheet is 4 pages long (3 pages of white space) How can I get rid of this? It is anoying to...

cheers Caspar Kennerdale

This doesnt to work G6 has the value "March" My new cell has the value "=G6" as opposed to "March which is what I want. I there perhaps an options setting that is incorrect or a cell format. I have set the frmat to 'Text' Caspar Kennerdale

sorry but this is a really silly question bt I cant find the answer what I want to do is have a text contents frm one cell be the contents of another. I assumed I would use cell() e.g =CELL("contents",g6) - where g6 contains the text that I want in my new cell. But the new cell only shows...

I have this fixed now ;) Caspar Kennerdale

I am sending an email directly from a form. So far I have been able to extractall email address from a database and send. What I want to do is allocate a particular distribution list to each record in the database, and then select hich list to send to via a pull down form. However I get the...

Cheers guys Almost there now Caspar Kennerdale

Thanks guys. Unfortunately none of the changes prevented access from crashing. Below is the entire code from my button. Essentially the variable MyEmails is building up a cellection of emails addresses which will be placed the the 'To' box on an email. This side of things works (if you comment...

Thanks for your help. As I understand my code the variable MyEmails should be a string containing all values of the field NAME in the table JOBS, each separated by a semi colon, however Access now just crashes. Here is my code- Dim dbs As Database Dim rs As Recordset Dim strSQL As...

I fixed that, but now I get this error "Method or data memebr not found" on this line MyEmails = rs.Email any ideas? Caspar Kennerdale

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=4509 Caspar Kennerdale