S
Sullivan
Hey all
Because of certain systems in our building, users need to
be able to find out how many records a member has, without
necessarily knowing what the records are for. So, I
thought I would create a simple form in access, using
DCount, to find out how many records there are (This goes
into another form, but that's not important). However,
what's happening is that when trying to run the function,
Access gives me the following error: "The expression you
entered as a query parameter produced this error: 'The
object doesn't contain the Automation object 'S." The
input is 127171-S. I'm guessing it has something to do
with the "-S" but since that's part of member's ID
(signifying one of 12 or so different types of members,
all of the form "-Letter"), that's a necessary part of the
input.
The following is the line of code that produced the error
with the above input: Count = DCount("RetID", "Death
Benefit Retirees", "RetID = " & Text0.Value)
Text0 is the input box the user uses.
Does anyone have any ideas on how to get around this?
Because of certain systems in our building, users need to
be able to find out how many records a member has, without
necessarily knowing what the records are for. So, I
thought I would create a simple form in access, using
DCount, to find out how many records there are (This goes
into another form, but that's not important). However,
what's happening is that when trying to run the function,
Access gives me the following error: "The expression you
entered as a query parameter produced this error: 'The
object doesn't contain the Automation object 'S." The
input is 127171-S. I'm guessing it has something to do
with the "-S" but since that's part of member's ID
(signifying one of 12 or so different types of members,
all of the form "-Letter"), that's a necessary part of the
input.
The following is the line of code that produced the error
with the above input: Count = DCount("RetID", "Death
Benefit Retirees", "RetID = " & Text0.Value)
Text0 is the input box the user uses.
Does anyone have any ideas on how to get around this?