J
Jeff
Hi,
I have two forms, in access 2002. First form is the data entry, which
allows end user to add a new record, which comprises name, age, gender,
education,phone
Second form, allows user to modfy data already entered - ie, change
name, age, gender, education, phone
First form, when user is doing data entry, they click on a button on
the form "notes", which opens up MS Word. They enter whatever data they
want, save the word file, and quit word, dropping them back to access
My problem is, in the second form, when they open it to modify a
persons education or phone or whatever, they may want to click on the
"notes" button, and have it open the word file, in case they want to
view/modify that. In the first form, when they click on "notes", as I
say, word opens, they type in their data, saving the file in
c:\accessfiles, with the name of the person - eg, fredy smith, or mary
jones
What I'm needing help on is this......in the database, I have 2
test/dummy patients - freddy smith, and mary jones. The user may come
along, open up the second form, and bring up Mary Jones record, to
modify. How do I get access to say "ah, okay, you have Mary Jones
record open - lets open the file mary jones.doc" ?, or "ah, okay, you
have Freddy Jones record open - lets open the freddy jones.doc file " ?
The *.doc files are ALL stored in c:\accessfiles, and once the data
entry person has entered, even 10 records, they can, within access,
open, to modify, any of the 10 people. The key field in the form is a
field entitled "name", so I need some way to have access, when you
click on "notes" button, to "capture" the name of the person (mary
jones, or freddy smith) and tell access that that is the name of the
*.doc file, in c:\accessfiles, to open
Thanking you hugely in advance,
Jeff
I have two forms, in access 2002. First form is the data entry, which
allows end user to add a new record, which comprises name, age, gender,
education,phone
Second form, allows user to modfy data already entered - ie, change
name, age, gender, education, phone
First form, when user is doing data entry, they click on a button on
the form "notes", which opens up MS Word. They enter whatever data they
want, save the word file, and quit word, dropping them back to access
My problem is, in the second form, when they open it to modify a
persons education or phone or whatever, they may want to click on the
"notes" button, and have it open the word file, in case they want to
view/modify that. In the first form, when they click on "notes", as I
say, word opens, they type in their data, saving the file in
c:\accessfiles, with the name of the person - eg, fredy smith, or mary
jones
What I'm needing help on is this......in the database, I have 2
test/dummy patients - freddy smith, and mary jones. The user may come
along, open up the second form, and bring up Mary Jones record, to
modify. How do I get access to say "ah, okay, you have Mary Jones
record open - lets open the file mary jones.doc" ?, or "ah, okay, you
have Freddy Jones record open - lets open the freddy jones.doc file " ?
The *.doc files are ALL stored in c:\accessfiles, and once the data
entry person has entered, even 10 records, they can, within access,
open, to modify, any of the 10 people. The key field in the form is a
field entitled "name", so I need some way to have access, when you
click on "notes" button, to "capture" the name of the person (mary
jones, or freddy smith) and tell access that that is the name of the
*.doc file, in c:\accessfiles, to open
Thanking you hugely in advance,
Jeff