L
Lee Brown
I have been developing a database for my recruiting business for many
years. I have a subform on a main contact (tabbed) page that is named
MANAGEMENT. I have another subform named DECISION CRITERIA.
On My machine, the subforms appear just as they should - I have a
master/child relationship linking the subforms based on the
candidate's IDNUM.
The problem I am having is that all of a sudden (I have been using /
developing / tweaking this application for 10 years) the subforms on
other recruiter's machines appear blanked (yet mine appear populated
where I can see all the controls and data in the subforms on my
machine). Unfortunately for me, I wasn't smart enough to manage the
configuration control of the machines in my office (with machines
randomly failing), and I have checked for latest versions, etc.
We are using MSOffice 2003 SP2 and Office XP Pro on our machines.
(sidenote - when I upgraded one machine to office 2007, closing a
customer's screen crashed the system every time on the 2 test
machines, so it was uninstalled).
I have tried every method of requery. I even tried (unsuccessfully)
to call the subform's onopen event from the main form. I do
understand that the subform events fire prior to the parent form
(which I didnt learn until today).
The parent is frm_Cand_Detail. The management form is named
subfrm_Cand_MGT and is referenced on the cand detail form as
MANAGEMENT. The decision criteria form is named
subfrm_Cand_Decision_Criteria and it is referenced on the
frm_Cand_Detail as subfrm_Cand_Decision_Criteria. Another subform I
use is named subfrm_Cand_PresentTo, and is referenced as it is named.
I have even tried deleting the subforms on the employees' computers
and adding it again, to no avail.
If you can suggest any solutions, I would be indebted to you. My
employees are growing frustrated.
Thanks,
Lee Brown
years. I have a subform on a main contact (tabbed) page that is named
MANAGEMENT. I have another subform named DECISION CRITERIA.
On My machine, the subforms appear just as they should - I have a
master/child relationship linking the subforms based on the
candidate's IDNUM.
The problem I am having is that all of a sudden (I have been using /
developing / tweaking this application for 10 years) the subforms on
other recruiter's machines appear blanked (yet mine appear populated
where I can see all the controls and data in the subforms on my
machine). Unfortunately for me, I wasn't smart enough to manage the
configuration control of the machines in my office (with machines
randomly failing), and I have checked for latest versions, etc.
We are using MSOffice 2003 SP2 and Office XP Pro on our machines.
(sidenote - when I upgraded one machine to office 2007, closing a
customer's screen crashed the system every time on the 2 test
machines, so it was uninstalled).
I have tried every method of requery. I even tried (unsuccessfully)
to call the subform's onopen event from the main form. I do
understand that the subform events fire prior to the parent form
(which I didnt learn until today).
The parent is frm_Cand_Detail. The management form is named
subfrm_Cand_MGT and is referenced on the cand detail form as
MANAGEMENT. The decision criteria form is named
subfrm_Cand_Decision_Criteria and it is referenced on the
frm_Cand_Detail as subfrm_Cand_Decision_Criteria. Another subform I
use is named subfrm_Cand_PresentTo, and is referenced as it is named.
I have even tried deleting the subforms on the employees' computers
and adding it again, to no avail.
If you can suggest any solutions, I would be indebted to you. My
employees are growing frustrated.
Thanks,
Lee Brown