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

    time management/ time tool software

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

    Director MX 2004 + NT

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

    hmtl limitations when sending email

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

    whilst on a roll with basic questions... - Worksheet size

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

    whilst on a roll with basic questions... - Worksheet size

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

    really dumb cell() question

    cheers Caspar Kennerdale
  7. ckennerdale

    really dumb cell() question

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

    really dumb cell() question

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

    SQL Error - Too Few Parameters

    I have this fixed now ;) Caspar Kennerdale
  10. ckennerdale

    SQL Error - Too Few Parameters

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

    Sorry - very basic VB Question

    Cheers guys Almost there now Caspar Kennerdale
  12. ckennerdale

    Sorry - very basic VB Question

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

    Sorry - very basic VB Question

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

    Sorry - very basic VB Question

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

    Hyperlink to email address?

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

    Sorry - very basic VB Question

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

    Sorry - very basic VB Question

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

    Hyperlink to email address?

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

    Email code works for Outlook 2000 but not 98?

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

    Email code works for Outlook 2000 but not 98?

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

Part and Inventory Search

Back
Top