Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 11th, 2004, 01:25 AM
Registered User
 
Join Date: May 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Stored procedure as the rowsource for Report (ADP)

Hello. Im using Access projects and SQL server, and i was wondering how could i pass the parameters for the stored procedure, which is the rowsource of a report. I dont want access to prompt the user for the parameters if its possible to give them some other way (in VBA).

Cheers,
Tero
 
Old May 12th, 2004, 08:22 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

you can pass the parameter by first declaring it
Create Procedure pass_parameter
@parameter varchar(20)
AS
SELECT MemberID, ClubName
FROM members
WHERE club_location = @parameter
ORDER BY clubname

Then you will have to create a unbound text column in your access project form and create and event procedure to call your store procedure.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Running stored procedure from .adp module mantle51 Access VBA 1 August 13th, 2007 12:17 PM
Crystal Report, Stored Procedure, Dataset clioz Crystal Reports 0 July 19th, 2006 06:28 PM
ADP Update Stored Procedure ashg657 Access 0 June 2nd, 2006 05:29 AM
ADP - Listbox RowSource fm SPROC w/ Input Parms tcarnahan Access 1 May 8th, 2006 01:12 PM
Use of "IF" in a ADP Stored Procedure Mickey123 Access 0 December 5th, 2003 01:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.