Décerné

Video Tutorial on sharing data between Subforms

Hi,

I am trying to use Access to carry out a clinical audit. I have very basic knowledge of access and can create basic DB consisting of simple tables and queries and forms etc. But I have hit a snag

1. Most important bit I need help with. Created a form with subforms for the questionnaires. Some of the questions appear on multiple forms. eg. on Form A looking at criteria for a head scan: Question: Is patient 65y or older?

Same question on Form B which looks at criteria for scan of patient's neck.

obviously if the answer on Form A is Yes, then the answer on Form B too Must be Yes as the patient's hasn't changed. There are few such instances of identical questions on different forms.

So I am trying to make the field on Form B automatically pick the response from Form A.

Pls see attached images.

Now I know you can do this pretty easily with VB. But I dont do VB so I need to be able to do that using Access expression builder ONLY.

2. To show me how to display a date as day of the week so that I can create a query to evaluate if a patient more or less likely to have a scan based on day of the week. Similarly I need to be able to display time patient seen as normal working hours (09:00-17:00 Mon-Fri) or not again to see if a patient is more likely to get a scan or not.

3. Calculating age between date of birth and date of attendance.

If required I can provide a copy of the database I have created.

Thanks

Sam

Compétences : Excel, Microsoft Access, Microsoft Office, MySQL, Architecture Logicielle

Voir plus : how to link subform to main form in access, two subforms, access 2010 subform link master fields, ms access multiple subforms example, ms access subform get value from parent form, access link two subform, how to create a subform in access 2013, how to create a subform in access 2010, data structures in c video tutorial, video tutorial effects, commerce video tutorial, video image sharing script, video tutorial installing clipshare, amazon script video tutorial, video tutorial creation

Concernant l'employeur :
( 6 commentaires ) York, United Kingdom

N° du projet : #15643679

Décerné à :

workerbee1974

Hired by the Employer

50 £ GBP en 3 jours
(24 Commentaires)
5.2