G
Guest
I am missing something very basic that I need so I apologize for my inability
to grasp the obvious (because I'm sure it is) in advance.
I had an .mdb that I have converted to .adp. There are many forms that
provide the criteria for either the underlying queries or recordsets such
as...
PARAMETERS [Forms]![CallList_Frm].[BegState] Text ( 255 ),
[Forms]![CallList_Frm].[BegState] Text ( 255 ),
[Forms]![CallList_Frm].[BegDate] DateTime, [Forms]![CallList_Frm].[BegDate]
DateTime, [Forms]![CallList_Frm].[BegSkill] Text ( 255 ),
[Forms]![CallList_Frm].[EndSkill] Text ( 255 );
SELECT HRRM.HRRef, HRRM.LastContactDate, HRRM.State
FROM HRRM
WHERE (((HRRM.LastContactDate) Between [Forms]![CallList_Frm]![BegDate] And
[Forms]![CallList_Frm]![EndDate]) AND ((HRRM.State) Like
(([HRRM].[State])=[Forms]![CallList_Frm]![BegState] Or
[Forms]![CallList_Frm]![BegState] Is Null)));
Now, I understand that in .adp there are no queries and you should use
stored procedures and try as I might, I am not grasping the concept of how to
get the values from the combo boxes and use them as criteria for the sp
parameters. I have read a lot of documentation discussing declaring global
variables first from the form information and passing that to the sp. I
think what I'm missing is specifically how to declare those global variables
to use elsewhere. Somehow, I think that I've gotten to an advanced stage in
what I'm doing with Access, so the documentation explaining this in reference
to what I'm doing simply skips it because it assumes that you already know
this basic concept. Either that, or I am SO familiar with .mdb concepts that
I cannot see beyond it to accomplish this new task. Anyone want to take a
stab at guiding the blind? .............please...............
to grasp the obvious (because I'm sure it is) in advance.
I had an .mdb that I have converted to .adp. There are many forms that
provide the criteria for either the underlying queries or recordsets such
as...
PARAMETERS [Forms]![CallList_Frm].[BegState] Text ( 255 ),
[Forms]![CallList_Frm].[BegState] Text ( 255 ),
[Forms]![CallList_Frm].[BegDate] DateTime, [Forms]![CallList_Frm].[BegDate]
DateTime, [Forms]![CallList_Frm].[BegSkill] Text ( 255 ),
[Forms]![CallList_Frm].[EndSkill] Text ( 255 );
SELECT HRRM.HRRef, HRRM.LastContactDate, HRRM.State
FROM HRRM
WHERE (((HRRM.LastContactDate) Between [Forms]![CallList_Frm]![BegDate] And
[Forms]![CallList_Frm]![EndDate]) AND ((HRRM.State) Like
(([HRRM].[State])=[Forms]![CallList_Frm]![BegState] Or
[Forms]![CallList_Frm]![BegState] Is Null)));
Now, I understand that in .adp there are no queries and you should use
stored procedures and try as I might, I am not grasping the concept of how to
get the values from the combo boxes and use them as criteria for the sp
parameters. I have read a lot of documentation discussing declaring global
variables first from the form information and passing that to the sp. I
think what I'm missing is specifically how to declare those global variables
to use elsewhere. Somehow, I think that I've gotten to an advanced stage in
what I'm doing with Access, so the documentation explaining this in reference
to what I'm doing simply skips it because it assumes that you already know
this basic concept. Either that, or I am SO familiar with .mdb concepts that
I cannot see beyond it to accomplish this new task. Anyone want to take a
stab at guiding the blind? .............please...............