User Profile

Collapse

Profile Sidebar

Collapse
WayneClements
WayneClements
Last Activity: Jun 25 '11, 11:02 PM
Joined: Aug 7 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • I have to answer my own question.

    The answer is that it DOES have a Nodes property by MS Access 2007 VBA does not show it in intellisense.

    So I was easily fooled.
    See more | Go to post

    Leave a comment:


  • Why does my treeview have no nodes property?

    I have a trivial MS Access 2007 vba blank form to which I have added a MS TreeView Control 6.0 (SP6).

    When I go to Form.Load event try TreeView0.Nodes there is no Nodes property.

    Does anyone know why this might happen?

    Thanks
    Wayne...
    See more | Go to post
    Last edited by WayneClements; Jan 19 '11, 11:01 AM. Reason: Add a picture

  • How to create a MS Outlook Provider using SQL Server?

    I have read various articles over and over again, including http://www.outlookcode .com/article.aspx?ID =25 and I cannot understand how to create a MS Outlook Contacts Provider in VB.NET

    I have a whole lot of Contact information that is stored and maintained in a SQL Server database. I want to be be able to mirror / replicate this information in MS Outlook.

    I acn write MS AddIn to copy the data from SQL Server to MS Outlook...
    See more | Go to post

  • This is not an answer, it is instead some further thoughts.

    My VB.Net DLL has some static data. So after it is instantiated I call an Intialise function and pass it some data which it stores at global level.

    Is it possible that this causes MS Access to restart?
    See more | Go to post

    Leave a comment:


  • Why does MS Access 2007 keep restarting itself?

    I have an old MS Access 2007 project and I have moved some of its procedures to VB.NET using VS 2008. I have compiled the DLL and MS Access can use it successfully.

    But when I exit MS Access it restarts automatically with no database loaded, just a blank MS Access screen, with no ribbon and the status bar at the bottom says Ready.

    Even if I exit from this spurious MS Access it restarts immediately and returns to this...
    See more | Go to post

  • WayneClements
    started a topic SELECT WHERE SettingKey = N'Logon' FAILS

    SELECT WHERE SettingKey = N'Logon' FAILS

    Does anyone know why a simple select like :

    SELECT SettingValue FROM sysCONFIG_SETTI NGS WHERE ModuleName = N'ScheduledTask ' AND SettingKey = N'Logon' should fail in oracle 10g

    It fails with 'no such column'

    It works is I use N'Logonxxx' or 'Logon'

    And it works in SQL+ and SQL/Developer

    But it fails in the live system

    Thanks
    See more | Go to post
No activity results to display
Show More
Working...