Recent content by GaP42

Even for small orgs a business continuity plan is needed - not just for the IT systems. Fires and floods can affect physical records too! and then who is the back up for performing roles if key personnel are lost without warning? And then you have to maintain the plan, check it is workable and...

Referring to the doc management app you built @BlueSpruce these are some observations that you might want to consider On checking out the application here are a few observations/criticisms and personal recommendations: 1. Schema: the Document table has two fields: DocumentStorageLocation and...

When typing in the notes section it appears you are adding that note to a current record (which has no product identified). Is that what you want to do? (I would expect some validation to prevent that occurring). The record should be saved when moving focus off that record (with validation). As...

Irrespective of expertise in Access, what you have is a problem with the design of the database, as the above statement illuminates the issue. The development of a database requires that analysis is performed to determine how best to store the data to minimize redundancy, remove ambiguity in...

How would "Date of service" relate to some of these doc types? Effective date? Date of document creation, Date registered in application? And how would you want to handle update / replacements eg wills, advanced care directives. Do you wish to be able to enable a master document to have related...

Can documents be categorised as both medical and financial or ... ? Is a medical certificate/ health fund membership a credential? As this is a patient populated record of documents, the categorization is probably best focused on simplicity.

Yep - my misread - I can only blame the hay fever I have atm. The ID in tblContact_categories is superfluous as you suggested, if it is not defined as the PK rather than the existing composite PK.

It is the Contactid in tblcontacts that is superfluous, given your explanation above, not the ContactID in tblcontact_categories. There it is used as FK to resolve the N:N relationship of contacts to categories.

BTW Category type in tblContact_Category appears to be redundant - it should be removed as you have it in tblCategoryTypes. Re the query - think of it as two sets of data - one for bikes and one for cars - and yuo need the intersection of the two sets.

Yes, the sensitivities of personal health information (and consequent regulation), as well as the breadth and depth of health data makes interoperability extremely complex. While your application is simply to provide a (set) of health documents, they remain outside the commercial EHR...

So this is an application that the healthcare patients use - they supply the docs (through scanning, attaching), and review and then may send those to a medical record - is that external? If so the process for accepting such records may/will need stringent verification/validation, which may...

Glad to help you. You should evaluate it carefully and I would expect some questions to be raised as you work with it - as I do :) (case in point: the decision about how you choose to implement txApplied and the associated MedicationDetail, Procedure and VaxGiven tables as these have 1:1...

@FeelCore Having reviewed your database structure, language issues aside (some items I was not able to decipher), I think you need to consider the following for a better more robust structure on which to build your application: Happy to discuss details. Edit: I made a few small changes and...

Commenting upon the database-structure-png: You have made a decision to combine Client and Animal in the one table. That would appear a serious error in design. A client may have multiple animals, at any one time, and the animals a client has and brings to your clinic for a visit does change as...

No. @Claude Parisel It is the wrong command - see post #6. The DoCmd.FindRecord method in Microsoft Access VBA is used to find a specific record based on a search string. It mimics the functionality of the "Find" dialog box in Access. Me.[PN].SetFocus oCmd.FindRecord "Père", , , , , acCurrent...