By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,939 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,939 IT Pros & Developers. It's quick & easy.

Passing form parameters to subform in stored procedures

P: n/a
I am feeling a little overwhelmed trying to get my MDB-ADP conversion
going.
The first thing I need to figure out (very quickly) is how to use the
values of unbound controls of forms in Stored Procedures.
For example, I have a form with the unbound controls startDate and
endDate.
When users click buttons, the dates change and a subform is populated.
In DAO/MDB I just requery the subform. How can I do this in a Stored
Procedure.
I can't get this project off the ground until I can at least
understand this.
Does anyone have some code that will show me exactly how to do this?
I have been trolling around the groups and come up with a lot of
conflicting concepts and some code I haven't been able to get to work.
I appreciate any help.
lq
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 30 Oct 2003 13:53:58 -0800, la*************@hotmail.com (Lauren
Quantrell) wrote:

I can recommend Access Developer Handbook 2000 by Ken Getz et al. Part
2 has a couple of chapters on ADP. Required reading.

One thing you will find out when you read this, is to use the
InputParameters property. Also see help file.

-Tom.

I am feeling a little overwhelmed trying to get my MDB-ADP conversion
going.
The first thing I need to figure out (very quickly) is how to use the
values of unbound controls of forms in Stored Procedures.
For example, I have a form with the unbound controls startDate and
endDate.
When users click buttons, the dates change and a subform is populated.
In DAO/MDB I just requery the subform. How can I do this in a Stored
Procedure.
I can't get this project off the ground until I can at least
understand this.
Does anyone have some code that will show me exactly how to do this?
I have been trolling around the groups and come up with a lot of
conflicting concepts and some code I haven't been able to get to work.
I appreciate any help.
lq


Nov 12 '05 #2

P: n/a
I highly recommend "Microsoft Access Developers Guide to SQL Server" for ADP
development by Mary Chipman and Andy Baron. It's pretty much entirely about
the multitude of options available for working between Access MDB's and
ADP's with SQL Server.

You are posting a lot of questions and you could have your answers faster,
and more complete with the book. It's the best money you will spend on this
project.

Good Luck!!

Jerry Boone
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...
I am feeling a little overwhelmed trying to get my MDB-ADP conversion
going.
The first thing I need to figure out (very quickly) is how to use the
values of unbound controls of forms in Stored Procedures.
For example, I have a form with the unbound controls startDate and
endDate.
When users click buttons, the dates change and a subform is populated.
In DAO/MDB I just requery the subform. How can I do this in a Stored
Procedure.
I can't get this project off the ground until I can at least
understand this.
Does anyone have some code that will show me exactly how to do this?
I have been trolling around the groups and come up with a lot of
conflicting concepts and some code I haven't been able to get to work.
I appreciate any help.
lq

Nov 12 '05 #3

P: n/a
Tom,
Thanks. I bought it.
lq

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<ia********************************@4ax.com>. ..
On 30 Oct 2003 13:53:58 -0800, la*************@hotmail.com (Lauren
Quantrell) wrote:

I can recommend Access Developer Handbook 2000 by Ken Getz et al. Part
2 has a couple of chapters on ADP. Required reading.

One thing you will find out when you read this, is to use the
InputParameters property. Also see help file.

-Tom.

I am feeling a little overwhelmed trying to get my MDB-ADP conversion
going.
The first thing I need to figure out (very quickly) is how to use the
values of unbound controls of forms in Stored Procedures.
For example, I have a form with the unbound controls startDate and
endDate.
When users click buttons, the dates change and a subform is populated.
In DAO/MDB I just requery the subform. How can I do this in a Stored
Procedure.
I can't get this project off the ground until I can at least
understand this.
Does anyone have some code that will show me exactly how to do this?
I have been trolling around the groups and come up with a lot of
conflicting concepts and some code I haven't been able to get to work.
I appreciate any help.
lq

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.