Sub-forms and "unrecognized database format" message
Hi All,
This one's driving me crazy, can someone help before I pull all my hair out!!! I have a split database which holds information on clients receiving care from a Health service team. The database has a form "New Client Details" which consists of 7 tab pages, 5 of which have sub-forms on them. The main form is bound to a table called "Client details" which has information such as name, address etc.... All of the sub-forms are bound to a table called "Episode of Care" which contains information relating to the teams contact with the client (e.g. assessment, intervention, treatments etc...).
A clients contact with the team might end for different reasons (e.g. treatment completed, client does not attend, client inappropriate for the service etc...). These different bits of information are located on 3 of the current sub-forms called "Initial Screening", "Assessment" & "Intervention" respectively.
The database seems to be working fine except for when the date of discharge is entered. When information is entered via combo boxes that contact has come to an end (e.g. client not suitable for service) a pop-up form is opened which asks for comformation that the referral is to be closed. When confirmation is given the date is automatically entered into a field on the "episode of care" table called "DateReferralClosed". So depending on why the referral is being closed the "DateReferralClosed" field is being filled from any one of a number of different controls on 3 different sub-forms. The date of discharge is then automatically displayed on all seven tab pages. On the first tab it is displayed within the sub-form "Initial Screening", on the remaining six tab-pages it is displayed on the main form.
When the referral is closed through entering data into the 1st sub-form "Initial screening" everything seems to work fine. However when I enter referral closing data through the other two sub-forms problems occur. Initially everything seems okay, the correct data is displayed on the main form and on all the sub-forms, if I directly open the tables the correct data is also displayed in both the "Client Details" and "episode of care" tables. When I close the database things also seem okay. However when I try to reopen it and look at existing records the database seems corrupted. I get the message "Unrecognized database format", followed by the message "Database [name] needs to be repaired or isn't a database". Once the database is repaired it seems that the newly created record has correct data in the main form table "Client details" but the relevant record in the "episode of care" table (holding all the sub-forms data) shows "#ERROR" in all fields.
I hope all of this is not too confusing. I'm just going aroud in circles trying to sort this out. Does anyone have any ideas on what might be happening and how I might resolve it (hopefully before I'm completely bald).
Many Thanks
John
Hi All,
This one's driving me crazy, can someone help before I pull all my hair out!!! I have a split database which holds information on clients receiving care from a Health service team. The database has a form "New Client Details" which consists of 7 tab pages, 5 of which have sub-forms on them. The main form is bound to a table called "Client details" which has information such as name, address etc.... All of the sub-forms are bound to a table called "Episode of Care" which contains information relating to the teams contact with the client (e.g. assessment, intervention, treatments etc...).
A clients contact with the team might end for different reasons (e.g. treatment completed, client does not attend, client inappropriate for the service etc...). These different bits of information are located on 3 of the current sub-forms called "Initial Screening", "Assessment" & "Intervention" respectively.
The database seems to be working fine except for when the date of discharge is entered. When information is entered via combo boxes that contact has come to an end (e.g. client not suitable for service) a pop-up form is opened which asks for comformation that the referral is to be closed. When confirmation is given the date is automatically entered into a field on the "episode of care" table called "DateReferralClosed". So depending on why the referral is being closed the "DateReferralClosed" field is being filled from any one of a number of different controls on 3 different sub-forms. The date of discharge is then automatically displayed on all seven tab pages. On the first tab it is displayed within the sub-form "Initial Screening", on the remaining six tab-pages it is displayed on the main form.
When the referral is closed through entering data into the 1st sub-form "Initial screening" everything seems to work fine. However when I enter referral closing data through the other two sub-forms problems occur. Initially everything seems okay, the correct data is displayed on the main form and on all the sub-forms, if I directly open the tables the correct data is also displayed in both the "Client Details" and "episode of care" tables. When I close the database things also seem okay. However when I try to reopen it and look at existing records the database seems corrupted. I get the message "Unrecognized database format", followed by the message "Database [name] needs to be repaired or isn't a database". Once the database is repaired it seems that the newly created record has correct data in the main form table "Client details" but the relevant record in the "episode of care" table (holding all the sub-forms data) shows "#ERROR" in all fields.
I hope all of this is not too confusing. I'm just going aroud in circles trying to sort this out. Does anyone have any ideas on what might be happening and how I might resolve it (hopefully before I'm completely bald).
Many Thanks
John
Last edited:
