Dear Graham, thank you very much explaining John's message. I got it. English is not my native language and sometimes I make mistakes. Actually my e-mail address includes my name and surname so I didn't write my name:))Best wishes and thank you for your understanding.
Ruhi Kulez
--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> Hi rkulez
>
> (Please sign off your messages with your name – it's much friendlier that
> way :-)
>
> What John meant was not to add another `On Error line, but to modify the
> existing line and insert an apostrophe at the beginning:
>
> 'On Error GoTo Err_Handler
>
> Also, you cannot run an event procedure from the VB window. You must open
> the form and trigger the event by updating the record on the form.
>
> Best wishes,
> Graham
>
> > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rkulez
> > Sent: Sunday, 2 October 2011 05:48
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: Re: [MS_AccessPros] error 13 type mismatch
> >
> >
> > John, I am not good with vb, must I write the code like?:
> >
> > Private Sub Form_AfterUpdate()
> > 'On Error
> > On Error GoTo Err_Handler
> > 'Purpose: Requery the combo that may have called this in its DblClick
> > Dim cbo As ComboBox
> > Dim iErrCount As Integer
> > Const strcCallingForm = "frm_CaseRecord"
> > .......
> > .........
> > endsub
> >
> > I wrote this and tried to run it in vb window, but a form named "macros"
> opens. In this case I tried to save and open my pop up form but again I get
> the type mismatch error. I think I need more explanation.Thanks again.
>
Tidak ada komentar:
Posting Komentar