Hey there! Sign in to join this conversationNew here? Join for free
    Offline

    0
    ReputationRep:
    (Original post by James1992)
    I feel the same as "iRush".

    My thought would be to check that the password is correct with the username would be to use a query and form. As in, create a form that requires the user to enter their username and password. If no results are found then they must have entered either one wrong or no such details exist (this would be where a message would pop up).

    Do people agree with that? Or would you do this another way?

    To check whether they are old enough is easy - just create a validation rule.
    Generate unique username - I know quite a few people have posted links but it's not clear for me.
    A default password - Is this a password to enter the whole database or a password to enter their account?

    I notice it says nothing about the user wanting the change the password, so I guess the query for the password would be "teapot".

    Please someone help!
    Regarding the password, mate I think they mean with each student the password should be teapot. So if anything else is written its wrong. The Validation rule/text is the only way I think we can put out messages to pop up.
    Offline

    0
    ReputationRep:
    Ah why on earth didn't I think of that!

    I've just worked out how to do the unique username but i'm unsure how to link this with the database. Because otherwise we've just created a new form that has no actual link with the database?
    Offline

    0
    ReputationRep:
    Also, in that case, how do we automatically set the password as teapot?

    No worries - Worked it out
    Offline

    0
    ReputationRep:
    OHHHH AND IVE NOW WORKED OUT HOW TO LINK IT! WOOP Irush, wanna know how?
    Offline

    0
    ReputationRep:
    (Original post by James1992)
    OHHHH AND IVE NOW WORKED OUT HOW TO LINK IT! WOOP Irush, wanna know how?
    Please James!
    Offline

    0
    (Original post by bc0607)
    Use DLast instead of DMax
    problem with using DLast() is that this is a possible random aggregate function that will just draw out the last in the physical sequence which depending on how we get the data in the files may not be the highest value. Basically depending on the order of the values in the exam CSV you may get a unexpected value returned. I would recommend using max() its worked for me.

    Ben
    Offline

    0
    ReputationRep:
    (Original post by James1992)
    Ah why on earth didn't I think of that!

    I've just worked out how to do the unique username but i'm unsure how to link this with the database. Because otherwise we've just created a new form that has no actual link with the database?
    Use an append query. Open a query using query design, not wizard, refer to your form in the criteria row. Convert to an append query and then append to the relevant fields. All in my guide, via my blog - see a previous post, guide also explains one way to do a login - of course, there are several ways.
    Offline

    0
    ReputationRep:
    (Original post by James1992)
    Also, in that case, how do we automatically set the password as teapot?

    No worries - Worked it out
    For those of you who have not worked it out, set teapot as the default value for the password field in your table design.
    Offline

    0
    ReputationRep:
    (Original post by cfrench)
    For those of you who have not worked it out, set teapot as the default value for the password field in your table design.
    You will also want to set it as the validation rule.
    Offline

    0
    ReputationRep:
    I have the username working when the person registers. However when I check back at the actual database, it has not be recorded yet the names have. Why?
    Offline

    0
    ReputationRep:
    Send me a copy of your database and I will have a look - PM me for how to. Provided you don't object to my posting a comment on the error if it might be helpful to others
    Offline

    0
    ReputationRep:
    (Original post by cfrench)
    Send me a copy of your database and I will have a look - PM me for how to. Provided you don't object to my posting a comment on the error if it might be helpful to others
    hey can u guys upload it here so that we can download !!
    Offline

    0
    ReputationRep:
    Anyone is having datafiles of this practical??
    Offline

    0
    ReputationRep:
    (Original post by Gorgeous devil)
    Anyone is having datafiles of this practical??
    Won't be out until we get in the exam im afraid!
    Offline

    0
    ReputationRep:
    Anyone else who is struggling with this Unit I highly recommend purchasing cfrench's guide. Fantastic!
    Offline

    0
    ReputationRep:
    Confusing guide is confusing. Thorough I'll give you that dude, but maaan I don't think I'd be able to build that in ten hours even if I had the guide beside me xD I'll just try get as many marks as poss I guess, we're doing it 3-3-4 in terms of hours so I'll try get Activity 1+2 done on monday, then 3 and some of 4 tuesday, then finish it all wednesday. Good luck to everyone anyways! And for those that don't know, our teacher told us the grade boundaries will roughly be:

    •A – 67/90
    •B – 58/90
    •C – 49/90
    •D – 41/90
    •E – 33/90

    Which is fairly reasonable! Although on reflection if it's working with other standard perecentages then it should be really be:

    A - 72/90 = 80%
    B - 63/90 = 70%
    C - 54/90 = 60%
    D - 45/90 = 50%
    E - 36/90 = 40%
    Offline

    2
    ReputationRep:
    Anyone who's felt raped and tortured by the subject is most welcome to join the following Facebook fanpage:

    http://www.facebook.com/pages/Applie...19743658038141

    Please spread the word...this subject has literally tortured us!!
    Offline

    0
    ReputationRep:
    (Original post by tajmahal)
    Anyone who's felt raped and tortured by the subject is most welcome to join the following Facebook fanpage:

    http://www.facebook.com/pages/Applie...19743658038141

    Please spread the word...this subject has literally tortured us!!
    The link is not available =\
    Offline

    2
    ReputationRep:
    (Original post by Gorgeous devil)
    The link is not available =\
    Search for "Applied ICT ruined my life"
    Offline

    0
    ReputationRep:
    (Original post by tajmahal)
    Search for "Applied ICT ruined my life"
    Lol Okayy .. Btw r yw doing this exam in junee???
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Would you rather give up salt or pepper?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Write a reply...
    Reply
    Hide
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.