Open a specific record after login (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:33
Joined
May 7, 2009
Messages
19,248
Ok we'll have a look.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:33
Joined
May 7, 2009
Messages
19,248
you may try it.
on your user table there user student id,
does this mean that each staff on usertable
has their own number of students assigned?

i see only 1 student per staff.
 

Attachments

  • aym access DB.zip
    57.2 KB · Views: 84

aym

Registered User.
Local time
Today, 08:33
Joined
Aug 20, 2017
Messages
40
you may try it.
on your user table there user student id,
does this mean that each staff on usertable
has their own number of students assigned?

i see only 1 student per staff.


Waoo good morning my mentor sir, i tried it and it works fine. you have no idea how happy i am sir.

I have been trying this for months. Thanks for helping me out sir.

But sir based on the above questions can i administers like 20 students per staff?

Really i have achieved my aim sir but this could be an additional knowledge.

Plenty of thanks sir.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:33
Joined
May 7, 2009
Messages
19,248
on navigation table i added StaffID field (long numeric).
you should see the table

then you can manually put the ID (autonumber from tblUser) of the staffs to
StaffID in table navigation.
 

Attachments

  • aym access DB.zip
    79.8 KB · Views: 101

aym

Registered User.
Local time
Today, 08:33
Joined
Aug 20, 2017
Messages
40
on navigation table i added StaffID field (long numeric).
you should see the table

then you can manually put the ID (autonumber from tblUser) of the staffs to
StaffID in table navigation.


Thanks for your response i will always be grateful sir

It work fine. I now understand sir

Thanks very very much sir

With all due respect sir, if i still have more questions i will ask you sir.
 
Last edited:

aym

Registered User.
Local time
Today, 08:33
Joined
Aug 20, 2017
Messages
40
Thanks for your response i will always be grateful sir

It work fine. I now understand sir

Thanks very very much sir

With all due respect sir, if i still have more questions i will ask you sir.


Sorry for disturbing you sir. I just taught of the following:
1. can one create username and password. i.e. creating an account from the login form?
2. can one change his or her password from login form?
3. can i share ms access db between two or more computers computers?

Thanks for your usual assistant
 

aym

Registered User.
Local time
Today, 08:33
Joined
Aug 20, 2017
Messages
40
Pls us there anyway i can make my ms access 2007 be alive i.e. animation
 

aym

Registered User.
Local time
Today, 08:33
Joined
Aug 20, 2017
Messages
40
Hello I design CBT using Ms Access. My question now is can I put it online so that people can have access to it any where? and secondly will my Ms Access code work when published online?

I really need help on how to go about it.

Thanks
 

Users who are viewing this thread

Top Bottom