Designing a continuous form for entering score data

[Hargo]

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 those wishing to input multiple assessments as they could just select another PatientID (I realize they can just do this but its good to reassure imo)


I probably could have a go at this BUT I don't want to ruin what I already have by slipping duff code in willy nilly!!!

Especially as Baseline doesn't work properly - fsubAssessment doesn't appear so HoNOS is appended with 19 Zeroes for the ratings - it does have the Admission Date right though

Finally, given that Assessmentdate control is NOT used, is it advisable to lock it? - would it interfere with working? Might user entering a date interfere more?

The light at the end of the tunnel has arrived :)

Cheers twinnyfo

[twinnyfo]

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 those wishing to input multiple assessments as they could just select another PatientID (I realize they can just do this but its good to reassure imo)

You can have the close button do whatever you wish.....

Especially as Baseline doesn't work properly - fsubAssessment doesn't appear so HoNOS is appended with 19 Zeroes for the ratings - it does have the Admission Date right though

Explain "doesn't work properly". If it is appending 19 zeroes, then you are either telling it to append 19 zeros (which I don't think our code does that), or the default value for the AssessmentRatin g is 0 (you will have to check the table design).

Finally, given that Assessmentdate control is NOT used, is it advisable to lock it? - would it interfere with working? Might user entering a date interfere more?

Database Desing Rule #217: Allow users to update only the data you want them to change. Corollary: Do not allow users to update any data they don't need to update.

The Assessment Date text box is there so the user can see that this is the date of the assessment they are entering. UNLESS, as mentioned before, there would be the chance that a user would be entering an assessment on a day different than "Today's Date"--which is possible. But, then you would change hte code for the append query to validate that a proper date was entered and use that date in the append query. Options abound.

Hopefully this will bring you closer to the end of the tunnel...

:-)

[Hargo]

You can have the close button do whatever you wish.....

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!!

Explain "doesn't work properly". If it is appending 19 zeroes, then you are either telling it to append 19 zeros (which I don't think our code does that), or the default value for the AssessmentRatin g is 0 (you will have to check the table design).

When Baseline is pressed the message comes up that you are about to append 19 records (Same as Followup) but when you press ok, fsub doesn't appear so ratings can be input - consequently what is appended is just the INSERT INTO String for PatientID, AssessmentDate, and Item - because fsub didn't appear all rating scores are entered as zero

Surely any default value for AssessmentRatin g would apply when Followup button used, thus the problem is why fsub isn't opening the same as it does with Followup


You kinda lost me with your last paragraph - is locking the control a good idea or not? Does locking impact on the data within the control or will the appropriate date still appear?

[Hargo]

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/appearing

[twinnyfo]

I am dumbfounded as to how my forms, queries and VBA works perfectly, but yours does not.

make sure there is no master/Child values in the fsub.

This is driving me nuts; I am sure you too...

[Hargo]

Amazingly I have solved the problem!!!! Bizarre i know :)

I simply moved the

dtAssessment = DLookup

part of the code above

strSQL = "INSERT INTO

and voila!! Obvs had a good teacher ;)

[twinnyfo]

So you got everything working now?

[Hargo]

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?

[Hargo]

Done the save button and it works fine :)

[twinnyfo]

Great! I hope this project will serve to help your employers on a daily basis!

[Hargo]

It certainly will thanks twinnyfo, just need the ranking query to work and then query 3 and its showtime