Pls see the more detailed description below - everything must work from within Word 2000 +
I've attached files you can look at - I've put lots of comments in the code where things are stuffing up (there are an awful lot of comments).
Here's the deal: We type for medical specialists - medical specialists in Australia see patients who are referred to them by general practitioners. Each medical specialist has his/her own list of referring GPs. The list of referring GPs contains title, surname, firstname, address1, address2, suburb and postcode. This is a fixed length file. Each list is named [url removed, login to view] where xxxxx=the author's ID. The author's ID is stored in [url removed, login to view] and is written there by the calling macro - the calling macro is in Normal.dot. The user will have a menu, under that will be a list of authors she works for - when she chooses, for example, John Smith, a macro will run which will write SmitJ to the authorID section of the [url removed, login to view] file. It will then create a new document based on the SmitJ template.
The DoctorTable [url removed, login to view] contains code which I want to do the following:
Present a list of GPs, presented as surname, firstname in a listbox. When the user clicks on an item from the list, I want the textboxes populated with all the fields from that doctor's record. (That's because some GPs work from multiple locations - e.g., Dr Fred Nurk might have rooms at Burpengary, Woolloongabba and Tumbulgum - we need to be able to select the correct details for Dr Nurk.) I've done this, and it works fine. It writes the info I need to variables, and they will be used to populate a letter.
I need to be able to delete doctors from the list - when the user selects a doctor and clicks delete, a msgbox should confirm the user's choice (showing the doctor's name who will be deleted). I've done up to there. When the user clicks the Yes to confirm button, the listbox should be repopulated with the list minus the doctor who's been deleted, so that the user can perform another operation.
I need to have the user type new doctor details into the text boxes. When she clicks the Add button, the new record should be written to a file (I had problems there) and then the new list should be sorted alphabetically, and put back into the listbox.
The user should be able to change the text in the textboxes, and then click Save changes to doctor - a msgbox to confirm. When confirmed the new text should replace the old text in the textfile.
This is simply in case the user isn't creating a new letter (using the Select this doctor button) but is simply doing some maintenance, adding, deleting and editing. I can do this bit (I think!) I hope this clarifies my needs. Everything must be run from within Word 2000 and up. Thanks & regards Cath
Windows 2000 and up, Word 2000 and up