| View previous topic :: View next topic |
| Author |
Message |
|
mccannpa
|
| Joined: 13 Dec 2005 |
| Posts: 1 |
| Location: Darlington |
|
|
Posted: Wed Dec 14, 2005 10:53 am Post subject: Patient Postcodes
|
|
|
When you enter a patients postcode in the individual Patient Record details it looks OK i.e. letters are capitals e.g. TS21 1HY but when you look at the details in list form under Patients, it appears as Ts21 1hy. This is the format it appears in when I export it to mail merge to produce address labels for correspondence.
_________________
Dr Pete
|
|
| Back to top |
|
|
|
support
Site Admin
|
| Joined: 25 Aug 2005 |
| Posts: 89 |
|
|
|
Posted: Wed Dec 14, 2005 4:59 pm Post subject:
|
|
|
Hi Peter,
Not sure how lowercase postcodes would have got in there - the user interface only allows you to enter uppercase ones! It could possibly have been from a patient data import.
Anyway, here's how to fix it...
- Start CO2005 and logon
- Click Tools | Advanced DB Operation
- Copy and paste the following bit of code into the "Advanced Database Operation" window...
| Code: |
| UPDATE Per SET Postcode=UPPER(Postcode) |
- Now click the Execute button
This will update all your postcodes to upper case in your database. You may need to log off and then log back on again to make sure any cached records are updated.
_________________
ClinicOffice Support Team
|
|
| Back to top |
|
|
|
clairetucker
|
| Joined: 25 Oct 2005 |
| Posts: 21 |
| Location: Belfast |
|
|
Posted: Fri Dec 16, 2005 7:48 am Post subject: Postcode Format
|
|
|
This does occur when entering new records. They appear in lower case if you don't have the caps lock on but hold the shift key down on while entering. If you either put caps lock on or let the database automatically capitilise the postcode it appears in upper case (ie don't hold the shift key down). It doesn't appear as lower case when you are in the patient record, only when you export the list or when you are in the patient grid.
Regards
Claire
|
|
| Back to top |
|
|
|
James Garstin
|
| Joined: 10 Mar 2006 |
| Posts: 4 |
| Location: Leamington Spa |
|
|
Posted: Fri Mar 10, 2006 1:13 pm Post subject:
|
|
|
Hello,
I've had this problem too. If you enter a postcode then move to the next cell to enter data, it automatically changes what you type to lower case.
The only way I've found to get it to stay as I enter it is to save the file before moving away from the cell.
The same is true with other fields eg surnames like McFergus, which unless you save whilst still in the field, will change to Mcfergus when saved.
Is there a setting we should be changing or is this the way the programme is written?
Many thanks,
James
|
|
| Back to top |
|
|
|
support
Site Admin
|
| Joined: 25 Aug 2005 |
| Posts: 89 |
|
|
|
Posted: Fri Mar 10, 2006 5:12 pm Post subject:
|
|
|
We've identified the problem now and it has been fixed for the next update. In the meantime, please use the database code (posted above) to fix the problem.
_________________
ClinicOffice Support Team
|
|
| Back to top |
|
|
|
James Garstin
|
| Joined: 10 Mar 2006 |
| Posts: 4 |
| Location: Leamington Spa |
|
|
Posted: Fri Mar 10, 2006 5:27 pm Post subject:
|
|
|
Great. Thanks!
James
|
|
| Back to top |
|
|
|
backman
|
| Joined: 02 Sep 2005 |
| Posts: 32 |
| Location: Maidstone |
|
|
Posted: Wed Mar 15, 2006 11:30 pm Post subject: Post code stuff!!
|
|
|
Now that was very Cool!!!
|
|
| Back to top |
|
|
|
|