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

    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
    Coventry, Warwickshire, UK
    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