ACCESS FEED: RE: [MS_AccessPros] ParseSQL question

Minggu, 25 Agustus 2013

RE: [MS_AccessPros] ParseSQL question

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