Phil
Something simple? Yeah, write it in VBA. [s]
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Thursday, May 03, 2012 1:46 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: embedded macros
Hi Bill
No. If I delete the IF, it deletes the whole block of logic that goes with it and that is what I want to retain.
Not to worry - it looks like I'll have to start over - I just thought there may be something simple I was missing
thanks for your help
Phil
________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Wednesday, 2 May 2012, 21:11
Subject: [MS_AccessPros] Re: embedded macros
Phil
Can you delete the bad IF and then add a new ELSEIF?
Bill
--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , Phil Knowles <pdk444444@...> wrote:
>
> Hi Clive
> Â
> I did manage to insert the IF statement on the first line but my problem is with the second IF statement (originally the first IF statement) which I now need to be an ELSEIF.
> Â
> I do intend to look into getting to grips with VBA - thanks for the links.
> Â
> cheers
> Â
> Phil
> Â
>
>
> ________________________________
> From: Clive <zctek@...>
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, 2 May 2012, 19:48
> Subject: [MS_AccessPros] Re: embedded macros
>
>
>
> Â
>
> Hi Phil,
>
> I take it that are not VBA user. VBA is not
> all that difficult to get familiar with if
> you have any programming experience. You will
> be able to get plenty of assistance from the
> group if you need it.
> have a look at Crystal's site,
> https://mvp.support.microsoft.com/profile=E1DA6AF8-CE8E-47E2-B2D4-A45FD93CE59B
> and the link on it,
> Learn VBA
> http://www.AccessMVP.com/strive4peace/VBA
>
> I am not a fan of Macros by the way but
> to add a line at the beginning of your current
> macro, just select the first line and Right_Click
> on Insert a new row and put the new IF statment on
> the first line. Don't forget to move the
> MacroName(if any) from the old first line to
> the new first line.
>
> So you would end up with first two lines having
> If statements. That is assuming the new line is
> independant of what follows.
>
> I will not be able to test your macro structure
> on my machine because I do nat have Access2010
> and I can do all I want with Access2007.
>
> Hope that helps.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , Phil Knowles <pdk444444@> wrote:
> >
> > Hi Clive
> > ÂÂ
> > It is access 2010 and yes it is an embedded macro created in the 'on exit' section of a field on a form.
> > ÂÂ
> > It is quite simply a series of IF THEN ELSEIFs designed to fill in values in other fields based on values in other fields on the same form.
> > ÂÂ
> > eg (in simple form)
> > IF field1 = x1 then field2 = y1
> > ELSEIF field1 = x2 then field2 = y2
> > ELSEIF field1 = x3 then field2 = y3
> > ELSE field2 = y4
> > ENDIF
> > ÂÂ
> > It does what I want it to do so far and all I am trying to do now is add another IF statement at the start which I have managed to do but this requires me to change the current first IF into an ELSEIF which I haven't managed to do!
> > ÂÂ
> > Also, it seems quite difficult - if not impossible - to copy and paste sections of the embedded macro.
> > ÂÂ
> > Any ideas?
> > ÂÂ
> > cheers
> > ÂÂ
> > Phil
> > ÂÂ
> > ÂÂ
> > ÂÂ
> > ÂÂ
> >
> >
> > ________________________________
> > From: Clive <zctek@>
> > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Sent: Wednesday, 2 May 2012, 11:09
> > Subject: [MS_AccessPros] Re: embedded macros
> >
> >
> >
> > ÂÂ
> >
> > Hi Phil,
> >
> > What version of Access are you using?
> >
> > Do you really mean a Macro or is it VBA code?
> > What did you use to create it?
> >
> > Please show us what you have got in your "macro"
> > and what you want the macro to do.
> >
> > Regards, Clive
> >
> > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "pdk444444" <pdk444444@> wrote:
> > >
> > > Hi
> > >
> > > I have created an embedded macro in a form for the first time - basically a series of If / elseif commands.
> > >
> > > I am trying to add an outer if statement to the ones that are already there and then change the current 1st if to an elseif but I am having problems doing this.
> > >
> > > I have been able to add the outer (top) if statement but don't seem to be able to convert the next if to an elseif.
> > >
> > > help please!
> > >
> > > Phil
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar