AccessAdp.com

the BEST resource for information about Microsoft Access and SQL Server

Stored Procedures


Stored Procedures are great.. I use them for most operations in Access Data Projects.

What is so beautiful about Access Data Projects? It auto-resolves parameters to controls on the form!!! If your sproc has a parameter called @txtStartDate, then if you set the recordSource of the control to the Stored Procedure name, then it will automatically resolve any parameters to the names of controls on the form.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 337 other followers