Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page