Results 1 to 3 of 3
  1. #1
    YMakinta is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1

    how can a student edit his profile and save it in a University management system

    Please how can i make a student view and edit his profile only and save in my University database. Please help me guys

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,344
    Are they not logging into your system already? If not then add that and then base your forms on that person's ID only. Probably need more info on this, how do students access this management system right now and what security is built in already?

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,117
    Foremost, you need user identification, be that logging in with a password form or just getting the user's Windows login name. If anyone can use the pc without logging in, then you need the db password type of identification. If not, you can research fOsUserName and see if that would be useful. Regardless, your db needs a user table. The easiest way to know who has logged in throughout a session is to open a hidden form that contains a field that contains their user id.

    When they open the form to edit a record, you present a single record that is based on the fact that the record belongs to the user id value on the hidden form. If they are going to log out of the db and the db will remain open, you must close the hidden form and return things to the login screen. If they must close the db, you don't have to worry about closing the hidden form.

    That's the basics of one approach.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Student Information System Design
    By ghoughton in forum Database Design
    Replies: 3
    Last Post: 07-16-2014, 01:51 PM
  2. Student Management System ERD.
    By Altaful Haq in forum Database Design
    Replies: 1
    Last Post: 04-17-2014, 02:18 PM
  3. Student Sign in/out system
    By torpid in forum Programming
    Replies: 12
    Last Post: 08-25-2012, 08:04 AM
  4. Student Management Systems - problem
    By LauraL in forum Access
    Replies: 3
    Last Post: 07-01-2012, 06:49 PM
  5. Student warning system
    By spqr in forum Database Design
    Replies: 1
    Last Post: 03-17-2010, 10:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums