Minggu, 18 Agustus 2013

Re: [MS_AccessPros] ParseSQL question

 

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@cox.net> 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

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar