ACCESS FEED: Re: [MS_AccessPros] ParseSQL question

Senin, 26 Agustus 2013

Re: [MS_AccessPros] ParseSQL question

Thanks John,
Did locate the code in another DB and have been testing it. Thanks again for all your help.
Rod

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Rod-
>
> Where did you find the code that calls ParseSQL? That bit of code needs to
> be copied from that database (or example) to yours and place in a Standard
> module. If you can't find it, that's why your code won't compile or run.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rodbevill
> Sent: Sunday, August 25, 2013 1:10 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] ParseSQL question
>
> Hi John,
> I tried the search on the Entire Project but do not find it. Is there a
> library that I need to load to get the functionality?
> Rod
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > Rod-
> >
> > Open the VB Editor (Ctrl+G will do it), click anywhere in the code window,
> then open the Find dialogue (binoculars on the toolbar). Search for
> ParseSQL in Entire Project.
> >
> > John Viescas
> >
> > Sent from my iPad
> >
> > On Aug 19, 2013, at 2:39, "rodbevill" <desertscroller@> wrote:
> >
> > I have been trying to redefine the data source for a combobox based on the
> selection from either a checkbox or another combobox. Reading the queryDef
> members of the database makes a lot of sense. However, the examples I have
> found make a call to a subroutine which I can not seem to find. The call is
> to a procedure
> > Call ParseSQL(strSQL, strSELECT, strWhere, strOrderBy, _
> > strGROUPBY, strHAVING)
> > which breaks the SQL statement down into the various segments. I know I
> can development something similar but thought since Microsoft was using it
> in there literature that it might already exist.
> >
> > Does anyone know if it does or should I bite the bullet? Just trying to
> change the WHERE clause for filtering.
> >
> > Rod
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>