V
viddom
Dear community, I have a form "COMPANY" where I fill in information about a
company, within it there is a sub-form "CLIENT" with fields inquiring
information from company's people. Moreover, the tables are linked through
the field COMPANY-ID.
My problem is when I try to fill in the information in the fields of the
CLIENT's table; first, a Message tells me that there is a communication
problem with the OLE-SERVER or with the ACTIVEX element;second, if I try to
let something written down in one of the field a meesage appear telling me
that the field COMPANY-ID cannot be NULL because its property is setup to
TRUE and I must fill in the value; third, the COMPANY-ID field is
auto-generated and its property is not set up, therefore the second message
seems strange to me;fourth, when I go to the source table CLIENT and do
nothing but to safe, then I closed, then I open the form again and type in
the information, everything work properly, but if I try to do it with another
company I have to go through all steps written above.
What can be wrong?
What can be wrong with my connection?
Am I missing something?
-The form is in my PC
-The data come from a table in the back-end and it is located in another PC
-The back-end is a .MDE file
-The front-end is a .MDB filer
-I am using ACCESS 2000]
company, within it there is a sub-form "CLIENT" with fields inquiring
information from company's people. Moreover, the tables are linked through
the field COMPANY-ID.
My problem is when I try to fill in the information in the fields of the
CLIENT's table; first, a Message tells me that there is a communication
problem with the OLE-SERVER or with the ACTIVEX element;second, if I try to
let something written down in one of the field a meesage appear telling me
that the field COMPANY-ID cannot be NULL because its property is setup to
TRUE and I must fill in the value; third, the COMPANY-ID field is
auto-generated and its property is not set up, therefore the second message
seems strange to me;fourth, when I go to the source table CLIENT and do
nothing but to safe, then I closed, then I open the form again and type in
the information, everything work properly, but if I try to do it with another
company I have to go through all steps written above.
What can be wrong?
What can be wrong with my connection?
Am I missing something?
-The form is in my PC
-The data come from a table in the back-end and it is located in another PC
-The back-end is a .MDE file
-The front-end is a .MDB filer
-I am using ACCESS 2000]