form difficulty

#1 (**permalink**) 28-Jul-2006, 08:42 AM

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!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14025-form-difficulty.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14025
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

#2 (**permalink**) 28-Jul-2006, 08:42 AM

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).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14025

Let me / us know the details

--
Wayne
Manchester, England.

"Accessidiot" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14025
> 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