Solved

MS Access parent form event not received by VB? OCX control

Posted on 2010-09-06
2
600 Views
Last Modified: 2012-05-10
I am recreating an OCX UserControl in VB6 I did many years ago.  It is basically a series of buttons to be used in an MS Access 2003 form.  The UserControl provides standardized functions to navigate the records, add, edit, delete, save and undo.  It is also aware of the application and security context.

As I said, I developped and used such a control many years ago but I don't have the source code anymore.

I created the UserControl and dropped it in the Access Form.  Clicking on the buttons will raise the events and perform the appropriate action.

However, the control does not received the form's events.  

The code snippet from the control below illustrates that I declared a module variable withEvents to hold the form reference.  This variable is initialized in the Show event handler of the userControl.  It is used by the cmdAdd_click event to move the form to a new record (this is working).  The form also received the events raised by the control (such as BeforeAdd and AfterAdd).  However, the m_ParentForm_Current event is never fired (as any other form events I've tried).

I think it may be some configuration on either the VB6 or Access side.

I compiled the userControl in both Apartment and Single threaded modes without difference in the result.


Dim WithEvents m_ParentForm As Access.Form

Dim m_AccessApp As Access.Application





Private Sub UserControl_Show()

    

    If Ambient.UserMode Then

        Set m_ParentForm = Extender.Parent.object

        Set m_AccessApp = m_ParentForm.Application

    end if



end sub





Private Sub cmdAdd_Click()

    Dim wCancel As Boolean

    

    wCancel = False

    RaiseEvent BeforeAdd(wCancel)

    

    If Not wCancel Then

        m_AccessApp.DoCmd.GoToRecord acDataForm, m_ParentForm.Name, acNewRec

        RaiseEvent AfterAdd

    End If



End Sub





Private Sub m_ParentForm_Current()



    MsgBox "Current"

    

End Sub

Open in new window

0
Comment
Question by:ragoran
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 33612939
<<I think it may be some configuration on either the VB6 or Access side. >>
  In Access, unless the property sheet reads "[Event Procedure]", the event won't fire even if sunk.  I have some code here to run through forms and add that if you want.
JimD.
0
 
LVL 14

Author Comment

by:ragoran
ID: 33613224
YES!

I knew it was something simple but could not remember.

Thanks Jim

0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now