How to copy a value from one table to another

  • Thread starter Thread starter Telesphore
  • Start date Start date
T

Telesphore

In a table tblPassword, there is a list of passwords. Instead of opening
the table of the passwords, select a password, use the function copy, open
the table tblStudents and paste the password in the field, how to automate
the task of the secretaries each time they register a new student in the
table tblStudents?

Thank you in advance
 
Telesphore said:
In a table tblPassword, there is a list of passwords. Instead of
opening the table of the passwords, select a password, use the
function copy, open the table tblStudents and paste the password in
the field, how to automate the task of the secretaries each time they
register a new student in the table tblStudents?

Thank you in advance
Click to expand...

Assuming I understand your question, there is no reason to be copying
the data. Rather than copy you just link the tables. I assume there is a
unique field for each student in each table.
 
Thank you,

I created a relation between the field StudentID of the table tblStudents
and the PasswordID of the table tblPasswords. When I try to insert a
password with a form, 8 passwords appear in the drop-down list. That I
choose the first or the 7 others one after the other, no one remains posted
in the control.
 
Telesphore said:
Thank you,

I created a relation between the field StudentID of the table
tblStudents and the PasswordID of the table tblPasswords. When I try
to insert a password with a form, 8 passwords appear in the drop-down
list. That I choose the first or the 7 others one after the other, no
one remains posted in the control.
Click to expand...

I am not at all sure what you really want to accomplish.

What exactly is being done when a secretary "registers" a new student?
Please explain both from the perspective of Access and the business process.
 
In the table [tblStudents], we have the fields [LastName], [FirstName],
[Street]. and [Password].

In the field [Password], a secretary needs to enter a password to give
access to our web site, so that the student could read his or her school
marks.

Now the secretary is doing this by copying a password from a table of
passwords [tblPassword] already generated by VBA code (there are 50,000) and
by pasting the password in the field [Password] of the table [tblStudents].

It seems it could be easier with a form. Is it? Or by any other means?

Thank you.
 
Telesphore said:
In the table [tblStudents], we have the fields [LastName],
[FirstName], [Street]. and [Password].

In the field [Password], a secretary needs to enter a password to give
access to our web site, so that the student could read his or her
school marks.

Now the secretary is doing this by copying a password from a table of
passwords [tblPassword] already generated by VBA code (there are
50,000) and by pasting the password in the field [Password] of the
table [tblStudents].
It seems it could be easier with a form. Is it? Or by any other means?

Thank you.
Click to expand...

Now I see what is happening. That makes sense.

I am sure it can be done, but it involves several steps I have not used
so I fear I am not the best one to offer advice. Hopefully someone who has
written a routine like this may read this and offer a suggestion or sample
code.
 
Back
Top