Search results for query: *

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

...seems to be on the SQL statement. I am not sure what this error means so it is difficult to double check. Here is the code strSQL = "SELECT * FROM Distribution_Contacts WHERE Distribution_Contacts.[Distribution_List] = Me!DistributionList" Set rs = dbs.OpenRecordset(strSQL)...

Cheers guys Almost there now Caspar Kennerdale

...our email Dim dbs As Database Dim rs As Recordset Dim strSQL As String Dim MyEmails As String strSQL = "SELECT * FROM Jobs" Set rs = dbs.OpenRecordset("strSQL") Do Until rs.EOF If Len(MyEmails) = 0 Then MyEmails =...

...is my code- Dim dbs As Database Dim rs As Recordset Dim strSQL As String Dim MyEmails As String strSQL = "SELECT * FROM Jobs" Set rs = dbs.OpenRecordset("strSQL") Do Until rs.EOF If rs.BOF = True Then MyEmails = rs.Name...

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

Database.OpenRecordset("Select E-mail from Distribution Contacts") I get variable not defined with 'Database' I presume I need to define my database? I'm using A97 Caspar Kennerdale

Sorry if this is so basic but I keep on returning a string instead of the values of a query. Basically I have a table ("Contact") which has an Email field ("E-Mail"). I want to gett all email addresses as one string and put into an email. My email function is all working by...

There is an Email FAQ which I found useful for doing this myself. Caspar Kennerdale

Thanks It was actually an Office 9.0 library that wasnt loading, and wasnt actually required for anything Caspar Kennerdale

I have some code which generates an email. As it is using DoCmd.SendObject I thought it just fired up your default email client, and didnt need to load up any module or library. It works fine on my Outlook 2000, but when trying on a colleagues Office 98 (it needs to run on both machines) i get...