[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference bump::msaccess

Title:	MSACCESS

Moderator:	BUMP::HONER

Created:	Tue Dec 01 1992
Last Modified:	Mon Jun 02 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1661
Total number of notes:	6339

1645.0. "pass through queries / problems w. parameters" by ATZIS2::SCHERB () Wed Mar 26 1997 11:33

    hello,
    
    i've tried a lot to get ms access use parameters / input prompts
    in pass through sql queries. the ones that really get executed on the
    server :-)
    however all my efforts failed miserably ...
    questions:
    1) is it possible to create pass through queries with parameters
       or input fields at all ??
    2) anybody out there having an example handy for me ?
    
    thanx for you help
    ulrich

T.R Title User Personal
Name Date Lines

1645.1 NSIC00::KLERK Thunderbirds are Go Thu Mar 27 1997 05:27 13

T.R	Title	User	Personal Name	Date	Lines
1645.1		NSIC00::KLERK	Thunderbirds are Go	`Thu Mar 27 1997 05:27`	13
	It is possible to use parameters if you compose your query in VBA using qdf.Connect = "some_connect_string" qdf.SQL = "Select " & this & " FROM " & that & " WHERE " & we_agree & ";" qdf.Execute I'm not sure of you can do it with parameters on a ready made query in the query tab of the database. Theo

  It is possible to use parameters if you compose your query in VBA using

  qdf.Connect = "some_connect_string"
  qdf.SQL = "Select " & this & " FROM " & that & " WHERE " & we_agree & ";"
  qdf.Execute


  I'm not sure of you can do it with parameters on a ready made query in
  the query tab of the database.


  Theo