B
Brad
Hi
I am in the process of finishing off a database and was wondering whether I
could seek some assistance to problems which are driving me mad.
I have has some very helpful responses from the forum and I am very grateful
for them. I have 2 remaning problems and would be so appreciative of some
help.
Database details:
It is an access 2003 contact database, where I have 3 tables: contact,
company and address.
I have 3 forms, to match the above. The contact form asks for contact
details and has an address subform. The company form asks for company
details and has an address subform and contact subform.
My relationships go from addressID to companyID and from contactID to
companyID (with both arrows going towards companyID at the centre).
The problems remaining are:
1. I am unable to enter new record information in the address subforms.
They are set to allow deletions, additions etc. (and show the correct
information) but when I try and type I get an error saying unable to enter
data as 'control is read only, open in design view or value too large'. The
source is the address table, so it should work okay.
2. I can't seem to get the links working correctly. When I enter a new
contact, I type all the information in, including the company name (which is
in a combo drop down box, getting information from the company table) and
although it all saves fine, the new contact doesn't appear on the company
screen (which has a contacts subform).
Occasionally I get a runtime error 3075 'syntax error (missing operator) in
query expression 'CompanyID' =', am not sure how this relates.
If anyone could help, that would be so great. Am getting very depressed and
frustrated by it all.
Thanks in advance.
Brad
I am in the process of finishing off a database and was wondering whether I
could seek some assistance to problems which are driving me mad.
I have has some very helpful responses from the forum and I am very grateful
for them. I have 2 remaning problems and would be so appreciative of some
help.
Database details:
It is an access 2003 contact database, where I have 3 tables: contact,
company and address.
I have 3 forms, to match the above. The contact form asks for contact
details and has an address subform. The company form asks for company
details and has an address subform and contact subform.
My relationships go from addressID to companyID and from contactID to
companyID (with both arrows going towards companyID at the centre).
The problems remaining are:
1. I am unable to enter new record information in the address subforms.
They are set to allow deletions, additions etc. (and show the correct
information) but when I try and type I get an error saying unable to enter
data as 'control is read only, open in design view or value too large'. The
source is the address table, so it should work okay.
2. I can't seem to get the links working correctly. When I enter a new
contact, I type all the information in, including the company name (which is
in a combo drop down box, getting information from the company table) and
although it all saves fine, the new contact doesn't appear on the company
screen (which has a contacts subform).
Occasionally I get a runtime error 3075 'syntax error (missing operator) in
query expression 'CompanyID' =', am not sure how this relates.
If anyone could help, that would be so great. Am getting very depressed and
frustrated by it all.
Thanks in advance.
Brad