Hyperlinking of the forms with the data and tamper protection

[Guest]

I am facing a problem while working with MS Access 2003. I have to maintain
database of the patients who are participating in my research study. To
accommodate all their details, I had to create multiple forms, each
hyperlinked to the next for continuity. However, the difficulty that i faced
were the fact that each time I open the hyperlinked form, the form invariably
opens with data of the first patient’s information in the alphabetical order
and I have to scroll down to get my present patient’s data ( I have appended
the name of the patient along with his unique ID to all the tables concerned
with the patient).
I don’t know how to set a criterion, where the hyperlinked form of the
patient opens with his data.
Is there any mentioning about it in the help menu or does it requires
specific scripting? I don’t have much idea with the scripts, but if someone
could provide me with the scripts or another method I would be grateful.
My second concern is the chances of unknowingly changing the data previously
entered on the data base. Is there a method to incorporate an alert message
seeking confirmation/password for each further modification of the particular
patients data once the record button has been pressed (preferably in each
form), as complete datas are not obtained at one time, hence necessitating
repeated opening of the forms of the same patient.
I tried looking through the help features in the access but couldn’t find it
(probably I may not be knowing the right terminology to be used for
searching).
Any suggestion or advice in this regard will be immensely appreciated as it
would certainly help towards maintaing the reliability of my database and
also provide better time management.

--
Siva Adarsh
Research Scholar
Dept. of Neurochemistry
NIMHANS
Bangalore
Karnataka
INDIA

 

[Larry Linson]

I'm sorry that I am not familiar with the technique of hyperlinking Access
Forms -- could it be that you are using something other than Microsoft
Access with a Jet database (often called an Access database).

It should be easy to open a Form to a specific record, using standard
approaches:

DoCmd.OpenForm "formname",,,,stLinkCriteria

where strCriteria is a string variable into which you store a "WHERE clause
without the WHERE".

The Command Button wizard will create the button and the basic part of the
VBA code for its Click event. All you will have to do is to add the VBA code
to generate the stLinkCriteria variable's contents.

Larry Linson
Microsoft Access MVP