Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Field Names

Field Names

Field Names

Is there a function/routine/prayer to copy the names of fields to memory variables?


 Shane Brennan

RE: Field Names

There is sure is.  If you are talking about the fields of a table, there is a fields collection, which contains field objects.  You can check out the help topics on Field Collection and Field Object.

If you give me a bit more detail I would be happy to help.  Where do you want to do this?  Are you talking about fields in a table or fields on a form?

I am taking a long weekend, though, so I won't be checking my email notification until Tuesday.


RE: Field Names

Hi Kathryn

Thank you for trying to help me with this one.  I'll give you a bit of history about what I'm trying to do and why so you can get a better idea of what I'm getting myself into.

I'm trying to create a "Simple" database to record student assignment grades for a number of courses.  I have created the following main tables:

tblCourses - The courses offered by the college. Primary key (PK) = CourseID
tblUnits - The units that make up the courses. PK=UnitID
tblAssignments - The assignments set for the units/course - each assignment has a unique code.  PK=AssignmentID.
tblStudents - PK StudentID

I have another table called tblResults where I store the grades awarded to the students for assignments:

AssignmentID    StudentID    Grade
AVCE1-1-1        1            P
AVCE1-1-1        2            P
AVCE1-1-1        3            P
AVCE1-1-1        4            M
AVCE1-1-1        5            P
AVCE1-1-2        4            P
AVCE1-1-2        5            P

When a lecturer/admin person comes to enter the data into this table I would like to present the assignments results in a more organised manner.

I lecturer needs to select their course, then course Id then I require a form/table to appear showing all the students down the left hand side and the assignments id's at the column headings.

Using a crosstab query and create table query I can produce a temporary table called tblTemp which I can edit and update:

StudentID    AVCE1-1-1    AVCE1-1-2
1            P            M
2            P            
3            P            
4            M            P
5            P            P

What I need is a way of getting this data back into tblResults correctly.

I am stumped at this stage.  I think I've got it right so far.  However I have a feeling there is a better way of doing this.

Surely there must be a wizard/add-in or routine out there which will do this sort of thing.  I can't beleive that I am the only person who has come up against this problem.

Thank you in advance for any help you can give me on this problem.

Shane Brennan

 Shane Brennan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close