Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

form difficulty

Discussion in 'Information Technology' started by Accessidiot, Jul 28, 2006.

  1. Accessidiot

    Accessidiot
    Expand Collapse
    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
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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


    --
    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
    > 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
     

Share This Page