Passing form parameters to subform in stored procedures

[Lauren Quantrell]

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

[Tom van Stiphout]

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

[Jerry Boone]

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

[Lauren Quantrell]

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