Hargo
Last Activity: Oct 3 '14, 12:17 PM
Joined: Sep 12 '14
Location: Cheshire, England
-
If Windows was defaulting to UK style why would tbl_HoNOS_Asses sments have a US style date for today's date - is it significant it's just on the FollowUp (i.e. today's date taken from your code?) -
Format and input mask on all tables
Just added another set of 19 using frmAddAssessmen t and the dates have all come up as 10/3/14 again in tbl_HoNOS_Asses sments!! What is overriding the formatting of this field?!!?!?Leave a comment:
-
All my date fields in tables are formatted dd/mm/yy so not sure how tbl-HoNOS_Assessmen ts is taking today's date 3/10/14 (which is visible in the Assessment Date control in frmAddAssessmen t) and turning it into 10/3/14 (Yankee style!!)
Is it just the tables that need amending then?Leave a comment:
-
Been adding and deleting HoNOS all morning and I think I have a discovery!! I think it's a US v UK date system issue
I have entered all the admission dates as UK dates i.e. 5/2/14 = 5th February rather than May 2nd so baseline readings are picking these dates
When it comes to the Follow up, I noticed as they all go in with today's date that 3rd October is showing as 10/3/14 where I would use 3/10/14
...Leave a comment:
-
I do have 190 records in HoNOS Assessments, Yes
Problem with script appears to be with the use of Parameter which I think is being viewed as a field name (? guessing here)
I removed the parameters and ran the script with each of the Patient Indexes and it returned all the right answers
I then thought I'd see what the script does with different dates in HoNOS (Attached) - interestingly more of them...Leave a comment:
-
Here's the impact upon the Order Query if it helps...Leave a comment:
-
I got the index I think
Here's screen shot attached for you to check
Does this mean my query is right?...Leave a comment:
-
It certainly will thanks twinnyfo, just need the ranking query to work and then query 3 and its showtimeLeave a comment:
-
All good stuff to know, even if I only get it basically from what we have done earlier
I assumed using the Open Args would remove this problem - The NHS Number MUST be entered manually once in frm_patient_Inf ormation but that's it
Had I known what I now know I would probably have Used an Index and a lookup as with PatientID but alas time is running out
As NHSNumber not involved in HoNOS Assessments...Leave a comment:
-
Done the save button and it works fine :)Leave a comment:
-
Apart from the Save button which clears the form (cosmetic I know, but I think it will help users a lot) is this a single line of code or huge amounts?Leave a comment:
-
Can it not be entered manually and an index? My reason for not adding an additional index for this table is that I have an OpenArgs which populates the NHSNumber control in frmAdmissions from frmPatient_Info rmation and I didn't want to lose it
Spotted this and changed it...Leave a comment:
-
Amazingly I have solved the problem!!!! Bizarre i know :)
I simply moved the
part of the code aboveCode:dtAssessment = DLookup
and voila!! Obvs had a good teacher ;)Code:strSQL = "INSERT INTO
Leave a comment:
-
Assessment rating did have a default = 0 which I have removed and now the records are appended without any value in Assessment Rating due to fsub not opening/appearingLeave a comment:
-
Here you go, hope it has what you need :)...Leave a comment:
-
I realise this but I think I'd prefer a Save button that 'reset' (for want of a better word) the subform to its 'blank' state and set focus to PatientID - although I could add the button to set the focus, I'm not sure how to 'blank' the form particularly as I don't want to to ruin what I have already!!
When Baseline is pressed the message comes up that you are about to append 19 records (Same as Followup) but when you...Leave a comment:
-
Looks amazing....how do you come up with this stuff?!?!?!
Bit of a problem with query 2 so I have gone no further - it doesn't appear to rank properly
I had some data in already which it didn't deal with properly e.g.
PatientID SG00141 had 3 assessments that it ranked 0,1,3
PatientID SG00142 had 2 assessments that it ranked 0,2
I thought maybe its a problem with how I have...Leave a comment:
-
I think we're nearly there thanks to all your efforts (can't thank you enough)
Follow up works fine, although not sure just closing form afterwards will sit too well with users as I had to open table to check something had occurred!! - can a faux save button be implemented? - as well as offering some reassurance it could return focus to Patient ID and clear the form to give impression that 'something has happened' - this would also benefit...Leave a comment:
-
Immediate window contents too wide for screen so did a copy and paste and included in attached
I'm leaving for the day but will pop on Bytes tonight at home (hopefully I can get the DB open on my laptop!!)
Did you get a look at previous thread (Crosstab query once this form works!! haha) ?...Leave a comment:
-
I selected Patient and pressed Baseline - back came the Parameter box but with the selected PatientID within it - I tried just pressing ok and adding a date (only parameter i thought could be missing) but the same occurred each time - see attached
Soooo close now!!...Leave a comment:
No activity results to display
Leave a comment: