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

    Custom images for ribbons in Access 2007/2010 ??

    Thanks for the reply! I have found a program which will create the ribbon with custom icons however I would prefer to know how it works myself so I could do it without using the program. So in answer, yes I am still interested in an answer Thank you! Thanks, Rebecca
  2. RMcCallan

    Help needed on attachments and embedded images (VBA)

    I already have some code which pulls all emails in my inbox into access then moves the emails into new outlook folders. While doing this, any attachments to the emails are saved in a local attachments folder. My problem is that if there is an embedded image in the email, that is seen as an...
  3. RMcCallan

    Saving attachment location to Access table - filepath object?

    I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want to do is when a new email comes in, i want any attachments to be saved into a table (by saving the location and then having the ability to go back in and open it from that...
  4. RMcCallan

    Saving attachment location to Access table using VBA

    Hopefully this is the right forum to post this in... if not please point me in the right direction. I figured it was more of an outlook automation issue rather than a vba issue. I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want...
  5. RMcCallan

    How to setup access to Rank

    Well, I don't know, I was just trying to help explain what he means but he isn't even replying now so can't really do much more... Thanks, Rebecca
  6. RMcCallan

    How to setup access to Rank

    I think CoreyVI simply included those formulas to show exactly what he wanted to accomplish... And I think it would make sense to define highest to lowest as customers with a rating of 5 would be highest and customers with ratings of 0 would be lowest. Thanks, Rebecca
  7. RMcCallan

    How to setup access to Rank

    I think I just did... put them from highest to lowest (in order...) and then put 1, 2, 3, 4, 5 against the ones which are the 5 highest... Thanks, Rebecca
  8. RMcCallan

    GHOST EXCEL

    I'm not too sure what else it could be then... just one thing I can see which you could change but I'm not sure how it could make the application hang but I'll mention it anyway, I believe you don't need to set your 'RSL' and 'DB' to = Nothing. Sorry I can't offer you more help perhaps PHV...
  9. RMcCallan

    GHOST EXCEL

    objActiveWkb.Close SaveChanges:=True XL.Application.Quit You do appear to be closing it but perhaps it will work better with the above code because of the changes? also you set everything but active workbook to be nothing Set objActiveWkb = Nothing Thanks, Rebecca
  10. RMcCallan

    GHOST EXCEL

    As normal, Dim objActiveWkb.Worksheets as Object Thanks, Rebecca
  11. RMcCallan

    GHOST EXCEL

    One more important detail I forgot! Set objActiveWrksheet = objActiveWkb.Worksheets("Sheet1") Thanks, Rebecca
  12. RMcCallan

    GHOST EXCEL

    I have just had a look, this may help. I declared objActiveWrksheet as an object and (obviously) wherever I had activeworksheet i just replaced it with objActiveWrksheet. Good luck! Thanks, Rebecca
  13. RMcCallan

    GHOST EXCEL

    I have had this problem before and I can't find the database where it happened but I seem to remember this it is the 'ActiveSheet' which keeps excel hanging... as I can't find it I'm not sure what I replaced it with but I hope this helps anyway! Thanks, Rebecca
  14. RMcCallan

    Outlook Automation search MAPIfolders

    Hmmm I'm not too sure that this would do what I want it to... I have quite a lot of code so will just post the bit where I want to search for the folder Set rstClient = db.OpenRecordset("Select foldername from tbl001_clientdetails where hostname = '" & strClientHost & "'") If "'" &...
  15. RMcCallan

    How to setup access to Rank

    I believe CoreyVI wants to effectively put them in order and then give the top 5 (with the highest ratings) ranks from 1-5... Thanks, Rebecca
  16. RMcCallan

    How to setup access to Rank

    So let me just make sure I understand, where do you want the rank of that customer to be kept? Is there a rank field? Thanks, Rebecca
  17. RMcCallan

    How to setup access to Rank

    Oh I understand now actually - because the rating is also 0-5 I still thought you meant that. Is this data you want to rank in a form or is it just the table? Thanks, Rebecca
  18. RMcCallan

    How to setup access to Rank

    Why would that not rank them from 0-5 perhaps I'm missing something. You could also use the order by property and order on the rank field... Thanks, Rebecca
  19. RMcCallan

    Outlook Automation search MAPIfolders

    I have some outlook automation code which is working fine there is just one thing which I can't get to work. Part of my code separates emails depending on the domain name of the sender email address, each has it's own folder. When there is a sender with a new domain name a new folder will be...
  20. RMcCallan

    How to setup access to Rank

    right click* Thanks, Rebecca

Part and Inventory Search

Back
Top