Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Pocedure from Access

Status
Not open for further replies.
LanieT

LanieT

Programmer
Mar 26, 2004
1
US
I am trying to execute a stored procedure in Access that has multiple parameters. The parameter results are coming from text boxes on a form in Access. The procedure is being run via a macro. I cannot seem to get it to work when trying to pass the parameters. Where and how can I run this?

example:
exec pUpdateBalances(@pFundID=[vAllocatedBalances2]![ID])
 
Sort by date Sort by votes
Have you tried this?

"exec pUpdateBalances " & Forms![vAllocatedBalances2]![ID]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

scamquist58
  • Locked
  • Question
VB Change Default Printer - Access
Replies
1
Views
342
combo
combo
breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
383
breezett93
breezett93
dw134
  • Locked
  • Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
342
dw134
dw134
LittleNick
  • Locked
  • Question
Can Quick Access Toolbar be disabled in Access 2010?
Replies
0
Views
354
LittleNick
LittleNick
batteam
  • Locked
  • Question
MS Access 2013 and Stored Procedures
Replies
1
Views
200
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top