[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 14: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.RTitleUserPersonal
Name
DateLines
1645.1NSIC00::KLERKThunderbirds are GoThu Mar 27 1997 08:2713
  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