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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by thefarg

  1. thefarg

    How to email a shortcut

    Do you have write access to the website? If it is a shortcut to a URL, the websites favicon.ico will display.
  2. thefarg

    Wscript doesn't work in HTML file embedded with VBScript

    Try converting (renaming) to .hta unless you have a specific need for it to run in a browser.
  3. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Oh. Seems I have to work VBA's shortcomings to do interesting things. Thanks. Just a quick question. In the original example from Outlook help, they call the initialisation routine "Initialize_handler" as if its an event. Is it? If not, why the syntax?
  4. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Yes, the only namespace is MAPI so I prefer to use the session syntax myself (code just looks cleaner) but most examples I see use the GetNamespace syntax. Cheers for the help, consider this one resolved ;)
  5. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    OK. But do I only need to intantiate the outlook object and can use the child objects from that? FYI : Rather than loop through every account, I prefer to use SyncObjects.item(1) which is All Accounts Groups anyway. Looping through the accounts means that all accounts get synced, then each...
  6. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Sorry, just reading my latest shot at it, I do instantiate the outlook object. Dim WithEvents mySync As Outlook.SyncObject Private Sub btnTest1_Click() Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application") Set mySync =...
  7. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Cannot use "new" with "withevents" variable. The code you see is taken from MS Outlook 2007 help file. It works if placed in a form module, but no luck running it in a normal class module. So... do I need to instantiate both a outlook.application and a outlook.application.Session.SyncObjects.item ?
  8. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Cant add the outlook project as a reference. I tried opening an outlook.application, but If I try running cOutlook.Initialise_handler it errors 424 and says object required. Dim WithEvents mySync As Outlook.SyncObject Dim objOutlook As Outlook.Application Public Sub Initialize_handler()...
  9. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    I have this code (from Outlook 2007 Help) that does a send receive for all accounts and runs code when the SyncEnd event is triggered. Dim WithEvents mySync As Outlook.SyncObject Public Sub Initialize_handler() MsgBox "init reached" Set mySync = Application.Session.SyncObjects.Item(1)...
  10. thefarg

    How do I? : Run a user defined procedure in Outlook from Access

    Hi. In a Module (or class) in outlook I have written a sub. In Access I am instantiating an outlook object. Dim objOutlook As Object Set objOutlook = CreateObject("Outlook.Application") objOutlook.Module1.Test2 If the user defined sub in outlook is called Test2 ( in...
  11. thefarg

    How do I? : Hide nested classes

    Ah well. At the start of the project I weighed up storage of the various data between registry, table, properties or a file. I usually use registry for settings type storage but I decided to use the DB properties to store company name, phone etc type data as I like to keep that with the...
  12. thefarg

    How do I? : Hide nested classes

    Sounds like a good idea. I use it for storing Company data like Address, phone, etc. Thats in cBDBProps. I like to keep this dat with the database no matter what. cBDBSettings is pretty much all registry. I need to access the registry to turn off Simple MAPI security popup and also to allow Word...
  13. thefarg

    How to re-arrange Project Window and Property Window in VBE?

    Undock them all, then drag to wherever you want em.
  14. thefarg

    How do I? : Hide nested classes

    OK. LET and get for HomeGraphNumber. 'Which Graph No# to show on main form Property Get HomeGraphNumber() As Integer HomeGraphNumber = ReadRegValue("HKCU\Software\Bugs or Us\Bugs or Us Business System\Version 1.0.0\Settings\HomeGraphNumber") End Property Property Let HomeGraphNumber(ByVal...

Part and Inventory Search

Back
Top