B
Brian Bischof
I have a few questions on Input Parameters in an ADP file that I hope
someone can help me with.
1) The Form and Report each have an Input Parameter property for passing
data to SQL Server. However, the other controls like the drop-down box
doesn't. Is there a way to get the drop down box to pass a parameter to SQL
before its data gets populated? Right now I'm building the SQL statement in
code and assigning it to the recordsource. I would like Access to do this to
make it cleaner.
2) How can I reference the Input Parameters on my Form/Report. For example,
if an input parameter is a date range, then I want that to show up in the
report header. But I get errors when trying to reference the variable name I
created in the Input Parameter string. It seems that these variables are
only passed to SQL and not made part of the reports normal properties. Does
anyone know if there is a way to reference these parameters?
3) When I modify the RecordSource property for a form, Access automatically
clears my Input Parameters property. This is very frustrating b/c not only
do I have to retype this information, but if its a form I'm just doing a
little maintenance on, then I don't even remember what the string is
supposed to be. Is this a bug with Access or am I doing something wrong?
Many thanks,
Brian Bischof
someone can help me with.
1) The Form and Report each have an Input Parameter property for passing
data to SQL Server. However, the other controls like the drop-down box
doesn't. Is there a way to get the drop down box to pass a parameter to SQL
before its data gets populated? Right now I'm building the SQL statement in
code and assigning it to the recordsource. I would like Access to do this to
make it cleaner.
2) How can I reference the Input Parameters on my Form/Report. For example,
if an input parameter is a date range, then I want that to show up in the
report header. But I get errors when trying to reference the variable name I
created in the Input Parameter string. It seems that these variables are
only passed to SQL and not made part of the reports normal properties. Does
anyone know if there is a way to reference these parameters?
3) When I modify the RecordSource property for a form, Access automatically
clears my Input Parameters property. This is very frustrating b/c not only
do I have to retype this information, but if its a form I'm just doing a
little maintenance on, then I don't even remember what the string is
supposed to be. Is this a bug with Access or am I doing something wrong?
Many thanks,
Brian Bischof