form difficulty

[Guest]

I am attempting to create a password system in my data base.
I have a table which has a username a password and a link to a picture.
I have created a form where the user enters thier username and password,
then when the password is correct I wish to poke the link to the picture into
a field on a sub form.
I don't know how to poke the link in to the field on the sub form. The form
containing the subform will already be open, initially I intended putting my
password form in as a subform, but it doesn't seem to work if I do!
However I can put a button on to open the password form.
I am not looking for any great security with this procedure. I have looked
at access passwords but I'm not sure they'll do what I want, as I don't want
the user to have to enter a password to open the program.
I just want the user to enter a password to attach a picture of themselves
to a field.
Thanks
Ian

 

[Guest]

Hi

It's not too difficult "if" the picture of the person is saved onto a
commonly available drive (like C:MyDocuments\MyPictures)

The main problem you will have is linking the path to the [txtPicFile] which
is saved onto your table (this is what holds the Path of the picture on the
the form).

Providing that all this is OK (ie the pic "is" on a common drive and it's in
the right format, size, etc) then you should look at loading a new buttonand
OnClick save the path to the [txtPicFile] (or whatever you have called it) on
the source table.

Let me / us know where the pictures are saved and the names of your
Table
Picture path field
The form
The OLE field (if used)

Just a thought
It would be "much" simpler if you had the Access DB holding drive (if on a
server) linked to a scanner where the people could simply scan and save
directly into the table (but lifes never that simple) as they could save the
picture as a number and link this (1 to 1) you client/customer/employee
table. Or (if life was perfect) you could even save the picture as the
Autonumber - (smile if this is possible) - but then you would need to
display this autonumber on the form (bit of a mistake).

Let me / us know the details

 

[Guest]

I only have four users so ther would be no trouble putting the images in a
field and making a link to them.
How do I do that?
Thanks

Hi

It's not too difficult "if" the picture of the person is saved onto a
commonly available drive (like C:MyDocuments\MyPictures)

The main problem you will have is linking the path to the [txtPicFile] which
is saved onto your table (this is what holds the Path of the picture on the
the form).

Providing that all this is OK (ie the pic "is" on a common drive and it's in
the right format, size, etc) then you should look at loading a new buttonand
OnClick save the path to the [txtPicFile] (or whatever you have called it) on
the source table.

Let me / us know where the pictures are saved and the names of your
Table
Picture path field
The form
The OLE field (if used)

Just a thought
It would be "much" simpler if you had the Access DB holding drive (if on a
server) linked to a scanner where the people could simply scan and save
directly into the table (but lifes never that simple) as they could save the
picture as a number and link this (1 to 1) you client/customer/employee
table. Or (if life was perfect) you could even save the picture as the
Autonumber - (smile if this is possible) - but then you would need to
display this autonumber on the form (bit of a mistake).

Let me / us know the details


--
Wayne
Manchester, England.

I am attempting to create a password system in my data base.
I have a table which has a username a password and a link to a picture.
I have created a form where the user enters thier username and password,
then when the password is correct I wish to poke the link to the picture into
a field on a sub form.
I don't know how to poke the link in to the field on the sub form. The form
containing the subform will already be open, initially I intended putting my
password form in as a subform, but it doesn't seem to work if I do!
However I can put a button on to open the password form.
I am not looking for any great security with this procedure. I have looked
at access passwords but I'm not sure they'll do what I want, as I don't want
the user to have to enter a password to open the program.
I just want the user to enter a password to attach a picture of themselves
to a field.
Thanks
Ian