Problems creating subform
- From: "BruceM" <bamoob@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2005 13:14:23 -0400
I have an existing training records database. These are the three tables:
tblEmployees
EmployeeID (PK)
FirstName
LastName
etc.
tblTrainingSession
SessionID (PK)
Topic
Instructor
etc.
tblAttendance (junction table)
AttendanceID (PK)
EmployeeID (FK)
SessionID (FK)
SessionDate
There is a main form (frmSession) based on tblTrainingSession, and subform
(fsubAttendance) based on tblAttendance. fsubAttendance has a combo box
with tblEmployees as its row source, bound to EmployeeID.
All is well with this, but perhaps background will help with my question.
I am trying to expand this database's scope to include employment summaries,
which include Employer, StartDate, and EndDate for current and former
employers. I have created a table (tblSummary) to include this information.
tblSummary
SummaryID (PK)
EmployeeID (FK)
Employer
StartDate
EndDate
I have built a form (frmEmployee) based on tblEmployees, and a subform
(fsubSummary) based on tblSummary. I have established relationships between
PK fields and their namesake FK fields, including EmployeeID in tblEmployees
and in tblSummary. After I inserted the subform into frmEmployee, when I
attempt to start a subform record I receive the error message that there was
a problem communicating with the OLE server or ActiveX control. After doing
some research and learning that corruption could be a problem, I went to
another copy of the database and tried again. This time I had no
difficulties, and so far everything is behaving -- I have employment summary
records associated with each employee. It's the "so far" part that has me
worried. Is this a problem waiting to crop up again? Is there anything I
am doing that is increasing the risk of corruption? By the way, I don't
have Norton antivirus (I understand the error message can result from
conflicts with Norton).
.
- Prev by Date: re:Why don't control tips show?
- Next by Date: Re: Add mode Form feature
- Previous by thread: Re: Subforms
- Next by thread: Re: Problems creating subform
- Index(es):
Relevant Pages
|
