Ok, I got the 2005 DB Example working as I found out I had one letter
missing in the SQLQuery.
Here is what I had first: SELECT PatientNumber, PatienLastName,
PatientRevNo, PatientRevDate FROM Patients.
It should of been this: SELECT PatientNumber, PatientLastName, PatientRevNo,
PatientRevDate FROM Patients. As you can see I forgot the "t" in the
PatientLastName. After that, it works GREAT! Wow, no error came up at all
so it was a major pain to figure it out.
Ok, now I would like to have the Patient Name be shown in the ListBox like
this: Bevar, Jonathon M.
NOTE: I have the form to enter the First Name, Middle Name and Last Name
seperately, but I want the Listbox to combine all 3 into one entry. Is this
possible in the SQLQuery function?
Currently it is just the Last Name shown in the ListBox. How or what do I
need to do to make it come out like the above as for: LastName comma then
space then FirstName space then MiddleName?
The ListBox has a heading of: Patient Name. Can I do what I want without
breaking up the ListBox column. I want this way as some names are long or
short and it will it look more PRO then having a bunch of columns.
Thanks
Jonathon
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 1/6/2006
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
