• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

REPORT DISPLAYING SINGLE VALUE (1 Viewer)

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Good morning I have uploaded DB in full it my first real stab at anything but wouldnt be anywhere near with out the amazing help here.. Well aware I perhaps need to review WIKI to help sort tables etc not the best reader though...

My question is my report which is labelled A4CDM when displying a record

1. medication only displays 1 record although have two in table related to this ID
2. this is the same for observations and NEWS2
3. In the care log the last column should be initials but gives a number

They may be simple errors or more undelying complex any help appreciated

1602658256783.png
1602658272011.png
 

Attachments

  • CDM1R211bTAB33111.accdb
    2.3 MB · Views: 6

arnelgp

error reading drive A:
Local time
Today, 15:50
Joined
May 7, 2009
Messages
10,544
you need to create sub-reports for those.
 

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Arh ok suppose I should have relised,,

Would that also sort initials
 

arnelgp

error reading drive A:
Local time
Today, 15:50
Joined
May 7, 2009
Messages
10,544
here is your report with subReports.
 

Attachments

  • CDM1R211bTAB33111.zip
    421.1 KB · Views: 5

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
@arnelgp many thanks for your kind help, I have added meds seems to work.. Would you be able to look at why the forms repeat continuously and why I cannot get initals to work on care log
 

Attachments

  • aCDM1R211bTAB33111.accdb
    3 MB · Views: 4

arnelgp

error reading drive A:
Local time
Today, 15:50
Joined
May 7, 2009
Messages
10,544
check the recordsouce of the report.
i also added a useful function.
 

Attachments

  • aCDM1R211bTAB33111.zip
    397.2 KB · Views: 5

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Good morning very helpful thankyou really taking shape appreciate all the help

Will work on the initial bit it has to be sourcing or something
 

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Urgggg think I messed that up probally should have created a query first as wanted the report to based on surname selected... WHich I have tryed to work out today
 

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
As the main report is basic I assume I need to change one of the fields for example Surname prompt for input,,, would this then reset all the sub forms to that set of records or do I have to reset everything

Many thanks for any help in advance
 

arnelgp

error reading drive A:
Local time
Today, 15:50
Joined
May 7, 2009
Messages
10,544
create a Form that has a combobox where you can select a patient to print.
see A4CDM report.
 

Attachments

  • aCDM1R211bTAB33111.zip
    413.9 KB · Views: 4

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Amazing, thankyou I must be searching the the wrong questions, or just beyond my thought pattern

Its really facinating
 

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Hi I thought all was working but entering a new recored brings up sam in fo even though I have added new record,, Im a creating an error
 

dubiousp

Member
Local time
Today, 08:50
Joined
Mar 6, 2020
Messages
74
Good afternoon I have tried to read through to see why the record does not change,, could you offer any advice many thanks in advance
 

Attachments

  • aCDM1R211bTAB331111.accdb
    2.9 MB · Views: 1

Users who are viewing this thread

Top Bottom