Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    7

    Unanswered: OutputTo Method ---- Help!

    Hi all! I want to use a Stored Procedure as the object-source of Docmd.OutputTo. The problem is, how do I pass parameters to the stored procedure when I use it this way??? Anytime I try concatenating it to the SPROC name, Access treats it all as being the name of the SPROC.

    Any help would be appreciated.

    Thanks in advance!

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    Could you perhaps create an Access query that returns the results of the stored procedure and then use that in the OutputTo statement?
    Roger Hampson
    XI - ecs (UK) Ltd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •