[Year 12 IPM] Access Help

[Lel, Ronald A]

You can't do this using a macro unless you set up some structure first.
It is possible to do something like this using VBA. One of the databases
I designed professionally some years ago did something similar.
If memory serves me correctly:
Presumably you have a documents table storing the Names/paths of the
relevant Docs, and also a students table.
You need to create a new table with a joint primary key - studentId and
DocId. You could now create a parameter query if you want to pull up one
student or a normal query which links tblStudent, tblDoc and
tblStudent_Doc.

You can base a form on this query, have students log into the form by
entering their student number and then pull up a sub form or a second
form showing the docs available and the links to those docs.

Whatever all of this is not a trivial exercise and requires reasonably
sophisticated programming and access skills to make it achievable.

Ron Lel
Croydon Secondary College

-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au]
On Behalf Of Attard, Martin P
Sent: Wednesday, 3 August 2005 9:57 AM
To: Year 12 Information Technology Processing and Management
Teachers'MailingList
Subject: [Year 12 IPM] Access Help


Can anyone help me regarding setting up a macro.  I've set up a form
based on all students within the college.  I need to be able to have
students login using their student ID and only see forms relevant to
that ID.  It would mean that they would see between 6 and 10 forms
depending on what year level they are in.

Mr. Martin Attard
ICT Co-od
Kurunjang Secondary College
Kurunjang Drive
PO Box 598
Melton  3337, Victoria, Australia
Ph: (03)97439211 (w)
Fax: (03)97478495 (w)
email: attard.martin.p at edumail.vic.gov.au
Disclaimer 
This message, including any attachments, is provided without
responsibility in law for its accuracy or otherwise and without
assumption of a duty of care by the School. Whilst every attempt has
been made to ensure material in this e-mail message is free from
computer viruses or other defects, the attached files are provided, and
may only be used, on the basis that the user assumes all responsibility
for use of the material transmitted. This e-mail is intended for the use
of the named individual or entity and may contain confidential and
privileged information. Any dissemination, distribution or copying by
anyone other than the intended recipient of this e-mail is strictly
prohibited. If this e-mail has been received in error, then please
notify Kurunjang Secondary College immediately and destroy the original
message.

-----Original Message-----
From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au]
On Behalf Of Keith Richardson
Sent: Tuesday, 2 August 2005 10:39 AM
To: List IS; List Multi-Media; List Tech; ListYr7-10it; List IP&M; List
Moodle; List ATOM
Subject: [Year 12 IPM] Help Request - Dreamweaver utilizing CSS

Hello Everyone.
Is there anyone out there with expertise in using Dreamweaver utilizing
CSS. I am currently working on a project using this combination, and
would appreciate someone to bounce ideas off. With thanks, Keith Keith
Richardson IPM List Moderator Head of ICT, Leibler Yavneh College
Elsternwick
Ph: 03.9528.4911
k.richardson at yavneh.vic.edu.au

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IPM
Mailing List kindly supported by http://www.vcaa.vic.edu.au - Victorian
Curriculum and Assessment Authority and http://www.vitta.org.au  - VITTA
Victorian Information Technology Teachers Association Inc


Important - 
This email and any attachments may be confidential. If received in
error, please contact us and delete all copies. Before opening or using
attachments check them for viruses and defects. Regardless of any loss,
damage or consequence, whether caused by the negligence of the sender or
not, resulting directly or indirectly from the use of any attached files
our liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual
sender, and not necessarily those of the Department of Education &
Training.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IPM
Mailing List kindly supported by http://www.vcaa.vic.edu.au - Victorian
Curriculum and Assessment Authority and http://www.vitta.org.au  - VITTA
Victorian Information Technology Teachers Association Inc


Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.