J
Jim K via AccessMonster.com
I've been reading through postings pertaining to the error "The object
doesn't contain the Automation object 'tblTablename.'., and have not been
able to get my situation resolved, so I was hoping that someone may have a
solution for me. Thank in advance for any assistance.
I have a DB used to track people coming and going with several tables using 1:
many relationships. Because of the large number of people that will be
tracked, I've created a form containing a subform listing a portion (last
name starting with A and B) of the people. The user selects a checkbox (or a
button that runs a macro - I've tried it both ways) in the subform to choose
either an arrival or a departure and the date and time should be recorded in
the BuidlingAccess table. However when I try to select the checkbox, I get
the above Automation Object error. The specifics of my setup are:
- tblBuildingAccess table with accessindex field as primary key
- tblMembers table with memberindex as the primary key
- frmCheckinMemberChoice-ABlisting form with a query named qryAllMembers as
the control source (based on fields from tblMembers)
- frmMembersAB is the subform (known as Child36 on frmCheckinMemberChoice-
ABlisting) with qryMembersAB as the control source (based on fields from
tblMembers and tblBuildingAccess)
The LinkMasterFields and Link ChildFields are the MemberIndex fields from the
respective querys.
On frmMembersAB, the checkbox has the following code in the On Click event:
"=IIf(tblMembers!MemPresent=No,[mcrRecordPresentMember],
[mcrRecordDepartingMember])"
The two macros listed in this IIf statement use the Set Value function to
record the current date and time (using the Left and Right functions combined
with Now). I have tested this macro outside the form and it works properly.
There may be an easier way to accomplish what I'm trying to do and, of course,
I welcome suggestions. But basically when I click the check box I get the
"The object doesn't contain the Automation object 'tblTablename.'." error.
Ultimately, I hope to have buttons on the main form so that the users can
selct a group of people to check in based on their last name (i.e. an AB
button, a CD button, etc.). Each button will refresh the subform with the
names produced by the query that is run when the button is clicked.
Thanks again for any assistance you can provide.
doesn't contain the Automation object 'tblTablename.'., and have not been
able to get my situation resolved, so I was hoping that someone may have a
solution for me. Thank in advance for any assistance.
I have a DB used to track people coming and going with several tables using 1:
many relationships. Because of the large number of people that will be
tracked, I've created a form containing a subform listing a portion (last
name starting with A and B) of the people. The user selects a checkbox (or a
button that runs a macro - I've tried it both ways) in the subform to choose
either an arrival or a departure and the date and time should be recorded in
the BuidlingAccess table. However when I try to select the checkbox, I get
the above Automation Object error. The specifics of my setup are:
- tblBuildingAccess table with accessindex field as primary key
- tblMembers table with memberindex as the primary key
- frmCheckinMemberChoice-ABlisting form with a query named qryAllMembers as
the control source (based on fields from tblMembers)
- frmMembersAB is the subform (known as Child36 on frmCheckinMemberChoice-
ABlisting) with qryMembersAB as the control source (based on fields from
tblMembers and tblBuildingAccess)
The LinkMasterFields and Link ChildFields are the MemberIndex fields from the
respective querys.
On frmMembersAB, the checkbox has the following code in the On Click event:
"=IIf(tblMembers!MemPresent=No,[mcrRecordPresentMember],
[mcrRecordDepartingMember])"
The two macros listed in this IIf statement use the Set Value function to
record the current date and time (using the Left and Right functions combined
with Now). I have tested this macro outside the form and it works properly.
There may be an easier way to accomplish what I'm trying to do and, of course,
I welcome suggestions. But basically when I click the check box I get the
"The object doesn't contain the Automation object 'tblTablename.'." error.
Ultimately, I hope to have buttons on the main form so that the users can
selct a group of people to check in based on their last name (i.e. an AB
button, a CD button, etc.). Each button will refresh the subform with the
names produced by the query that is run when the button is clicked.
Thanks again for any assistance you can provide.