ACCESS FEED: Re: [MS_AccessPros] Use of Table Parameters in Query Builder

Selasa, 27 September 2011

Re: [MS_AccessPros] Use of Table Parameters in Query Builder

Is there a book or website that might have examples of the code used to become parameterizable?
Thanks
terryomsn

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Parameterizable. <g>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> 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 Duane Hookom
> Sent: Monday, September 26, 2011 11:56 PM
> To: Access Professionals Yahoo Group
> Subject: RE: [MS_AccessPros] Use of Table Parameters in Query Builder
>
>
> Table/query names are not parametizable (if that's a word). You would need to
> use some code that would update the sources.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> From: terryomsn@...
>
>
>
>
>
> Hi
> I have a set of queries that remain somewhat constant.
> The tables that use the queries change every two weeks, content only, not in
> format.
> Is it possible to create a parameter for a table name that for a query that will
> use the parameter for in that query?
> Thanks
> Terryomsn
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>