Recent content by SmallCraig

alehawk (if that is your real name ... ;-) ) I wanted to do something similar a while ago, and have found that, like you, I can't do it. At first blush, this makes no sense, but a little thought reveals why the observed behaviour is logical. When a control on the form loses the focus...

Hi there SBendBuckeye, Yes, you are correct - the code does go into the application. It's a bit fiddly to control another application from within VB, but it can be done! And thanks for the star! Regards, SmallCraig[upsidedown] ---------------------------------------- "Come see where...

The method I use to get around this is to place the macro code in an external file; load the file contents as a macro at run-time; then execute the macro. This code comes from a VB program that has been doing this for 2 years (so I know it works): Set oExcel = New Excel.Application...

Ryan, Since you clearly know the number of rows in each sheet, add some code to set the print area for each page: With PageSetup .Printarea = "$A$1:$H$" & cstr(intLastRow) ' etc. End With There are a lot of other page setup properties. If you record a macro that does any...

Itron, Is it the Outlook trigger or the running of the Access macro that's your problem? If it's the Outlook trigger, I did it once, but found it so unreliable that I ditched it in favour of processing my mail via a manual button-click. It was a while ago, so I can't remember the details, but...

Andrew, I haven't used Outlook 2003, but I do know that there are a number of properties/objects not exposed by the Oultook object model. For example, I've needed to find the actual e-mail address (as opposed to the display name) of the sender, which is NOT availaible in the Outlook object...

Chris, I don't know if "renaming" an e-mail is possible (does it have a name?), but you certainly can move it to a particular folder based on that name. That's what this bit of code does: Set oProcessed = _...

Chris, In fact what you want to do is not that complicated. It's long, and you need to keep track of where you are, but VBA is very friendly when it comes to its own objects. I've developed a similar system for automating the processing of incoming mail. You can do it so that Outlook...

Neil, To "increment" letters, you need to use the ASCII values of the letters, and increment those, converting them back to letters to use them. The ASCII value of "A" is 65, "a" is 97, etc. So, to get the "number" associated with a letter, use the...

Skip, Thanks for your reply. I tried what I thought you meant, but met with no success. So, a couple of questions: When you say a "range", do you mean a "named range", rather than a range as in Dim aryRange As Range Also, I was attempting an "OpenText" rather...

This is a question I've considered for some time, but the need hasn't been so pressing until now. In Excel, the "opentext" method accepts an array of "fieldinfo", which tells the open method how to treat each column of data imported. I have the potential need to make that...

Denster, Surely if you set the style to "Dropdown list" or "Dropdown Combo", your requirement can be satisfied? Either of these can be "loaded" progammatically. Sure the user can still "enter" something into the text part of a dropdown combo, but if you...

codejockey, "Memo" fields seem to be quite strange beasts - ever tried to open your table, select the memo field and then try to sort the table on it? Access greys out the sort buttons - it can't be done! I've never tried to do a find on such a field, but I'm guessing yur problem...

Greetings to you all, Just thought I'd weigh in (and my weight is not inconsiderable!), not with a solution, but with a further occurrence of the same problem! I have experienced exactly the same problem as you, dj, and have also been perplexed that, when I open the same CSV file via the Excel...

CajunCenturion, Thanks for the extra knowledge. But I can't quite imagine a situation where I'd actually want to do that. Can you give an example of a time when that would be required? Always interested in exploiting someone else's experience! SmallCraig[upsidedown]