R
Riz
Hi,
I've recently upsized a MSAccess2000 database to an access database project.
The ADP links into a SQL2000 backend.
I have a couple of issues still unresolved (bearing
in mind that these were working fine in MSAccess).
1. My forms are made up of several sub-forms - e.g a typical form is as
follows form held as follows:
Address details are held at 'company level', and contact info in a 'contact
level subform', which in turn has the 'call' and 'conversations log' subform.
The 'company' to 'contact' link and 'contact' to 'call' level sub-forms link
and work fine i.e. record navigation and udates/changes are saved. The
'conversations log' however, is also linked in the same way as calls by
ContactID to the contacts form and should only show the 'conversations log'
for the contact I'm on - however this subform returns all the conversations
for all the contacts? Any ideas how I can fix this to show just the
conversations for that contact?
2. This is an issue with unbound forms, in MSAccess I designed a form using
an unbound field source and linked it to a sub-form to display company info
for users. the master and child link were defined as the 'unbound' field and
'company name' field (if both are the same then the relevant company info is
shown). Now when I go and run this form as an ADP form I get the error -
'syntax error or access violation'. Any ideas what this means? and how I fix
this?
Kind regards,
Riz
P.S would like to thank Sylvian for helping with issue two from an earlier
postiong - problem solved, your solution worked a treat.
I've recently upsized a MSAccess2000 database to an access database project.
The ADP links into a SQL2000 backend.
I have a couple of issues still unresolved (bearing
in mind that these were working fine in MSAccess).
1. My forms are made up of several sub-forms - e.g a typical form is as
follows form held as follows:
Address details are held at 'company level', and contact info in a 'contact
level subform', which in turn has the 'call' and 'conversations log' subform.
The 'company' to 'contact' link and 'contact' to 'call' level sub-forms link
and work fine i.e. record navigation and udates/changes are saved. The
'conversations log' however, is also linked in the same way as calls by
ContactID to the contacts form and should only show the 'conversations log'
for the contact I'm on - however this subform returns all the conversations
for all the contacts? Any ideas how I can fix this to show just the
conversations for that contact?
2. This is an issue with unbound forms, in MSAccess I designed a form using
an unbound field source and linked it to a sub-form to display company info
for users. the master and child link were defined as the 'unbound' field and
'company name' field (if both are the same then the relevant company info is
shown). Now when I go and run this form as an ADP form I get the error -
'syntax error or access violation'. Any ideas what this means? and how I fix
this?
Kind regards,
Riz
P.S would like to thank Sylvian for helping with issue two from an earlier
postiong - problem solved, your solution worked a treat.