ACCESS FEED: [MS_AccessPros] Re: Editing a function

Rabu, 30 Januari 2013

[MS_AccessPros] Re: Editing a function

Hi Robin,

Don't worry about seeing blank until you do the search for the name of the Function according to my instructions I gave in an earlier post. If you have the name right and followed my instructions you will find the Function.

If that does not work then perhaps you have the name of the Function wrong. You can then search for the text below which should be in your Function:

intYear = intYear + 1

Kind Regards,
Pat Wood
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers:
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx

--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple wrote:
>
>
> Thanks for your persistence.
>
> The function is working but it gives the year as 2014 and I need it to be 2013.
>
> So the answers to your queries must be 'Yes'.
>
> With the query on the worksapce Alt F11 gives me blank pages.
>
> Cheers,
>
> Robin
>
> At 31/01/2013 03:40 PM, you wrote:
> >Hi Robin,
> >
> >Did you try searching as I laid out?
> >
> >If so, are you sure you saved the Function?
> >
> >And are you using the database in which you created the Function?
> >
> >
> >Kind Regards,
> >Pat Wood
> >Gaining Access Technologies Founder
> >http://gainingaccess.net
> >Microsoft Access and SQL Azure Information Center for Developers:
> >http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
> >
> >
> >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple wrote:
> > >
> > >
> > > Thanks Pat,
> > >
> > > I had tried that and once again all I get is blank pages!
> > >
> > > Cheers,
> > >
> > > Robin
> > >
> > > At 31/01/2013 02:49 PM, you wrote:
> > > >Hi Robin,
> > > >
> > > >That's OK. Try pressing the Alt and F11 keys at the same time.
> > > >
> > > >Kind Regards,
> > > >Pat Wood
> > > >Gaining Access Technologies Founder
> > > >http://gainingaccess.net
> > > >Microsoft Access and SQL Azure Information Center for Developers:
> > > >http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
> > > >
> > > >
> > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple wrote:
> > > > >
> > > > >
> > > > > Thanks Pat,
> > > > >
> > > > > I cannot even find the "" window where you work with the code "".
> > > > >
> > > > > Woe is me! Sackcloth and ashes!!!
> > > > >
> > > > > Cheers,
> > > > >
> > > > > Robin
> > > > >
> > > > >
> > > > > At 31/01/2013 12:37 PM, you wrote:
> > > > > >Hi Robin,
> > > > > >
> > > > > >You can do a search for NextAnniversary was it? In the window where
> > > > > >you work with the code on the Menu click "Edit" and then "Find" and
> > > > > >enter NextAnniversary in the "Find What:" box at the top of the
> > > > > >dialog that opens and then make sure that "Current Project" is
> > > > > >selected and then click "Find Next". Keep clicking "Find Next" until
> > > > > >you see the Function.
> > > > > >
> > > > > >Kind Regards,
> > > > > >Pat Wood
> > > > > >Gaining Access Technologies Founder
> > > > > >http://gainingaccess.net
> > > > > >Microsoft Access and SQL Azure Information Center for Developers:
> > > > > >http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
> > > > > >
> > > > > >
> > > > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple wrote:
> > > > > > >
> > > > > > > My apology for being a 'lame duck'.
> > > > > > >
> > > > > > > John Viescas has taken me step by step through adding a function to
> > > > > > > my database. It works as planned with one exception and I need to
> > > > > > > edit one criteria.
> > > > > > >
> > > > > > > How do I get back to the function to edit it? I have investigated
> > > > > > > everything that looks possible without success. The Microsoft help
> > > > > > > page was no help.
> > > > > > >
> > > > > > > Your advice is welcome.
> > > > > > >
> > > > > > > Robin Chapple
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >------------------------------------
> > > > > >
> > > > > >Yahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >------------------------------------
> > > >
> > > >Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>