Create record from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which allows user to input data to evaluate personnel.
However, there are times when the user needs to print out the evaluation form
to use rather than using the computer. Also, the user can print many copies
of this same report. If the user creates a record with students name then it
saves the record in the appropriate table. What I am attempting to do is if
the students name is blank then create the record in a separate table. The
reason behind this is when the user comes back to input the data rather then
typing all of the scenario criteria just use a pulldown to find the id of
that particular blank record. Also, since this same blank record can be used
for several poeple I don't want to save it in the same table as the rest.
Once the user selects the id I then want it to populate the form with the
initial criteria.

Sorry for that long reasoning, but here is my question. Is there a shorter
way of writing to save the record into another table rather than the original
table? For instance do I need to write rst![name]= me.name etc. Not every
field on the form is written to just one table, but I think I might need this
in one table when they select the id number.

Any thoughts would be helpful.
 
Why create a blank record at all? Especially in a separate table.

Add a button to your form that says "print worksheet". When the button is
clicked, have it print a blank worksheet out. The 'worksheet' should be a
report, not a form. Access Forms are for data entry and manipulation, not
for printing. Access Reports are for printing.

In order to print a blank page, you would really not want the report tied to
anything, basically just a bunch of labels and lines. Seems like printing
the worksheet from Word or Excell would work as well (or better). Why not
just make ten or twenty blank copies and keep them onhand. Seems kinda
silly to go the computer everytime you need a worksheet.

Rick B
 
Rick thanks for the response. I must have mispoken. I meant it would print
a report. However, the reason I would save a blank form (report) and assign
an ID to it is because there are several controls on the form and after the
instructor graded the sheets this information needs to be inserted in to
these tables. So I think to make things easier have the the blank form
(report) saved with the ID, have the instructor pick from a dropdown the ID
number on the blank form (report). Once they select the ID have it populate
all the items (combo boxes) on the form. Now if say the instructor has 20
people he needs to insert, wouldn't it be easier to select one item versus
say 12 or 15 for each person? They can also have this blank form (report)
saved so if they choose to use it again later.

Rick B said:
Why create a blank record at all? Especially in a separate table.

Add a button to your form that says "print worksheet". When the button is
clicked, have it print a blank worksheet out. The 'worksheet' should be a
report, not a form. Access Forms are for data entry and manipulation, not
for printing. Access Reports are for printing.

In order to print a blank page, you would really not want the report tied to
anything, basically just a bunch of labels and lines. Seems like printing
the worksheet from Word or Excell would work as well (or better). Why not
just make ten or twenty blank copies and keep them onhand. Seems kinda
silly to go the computer everytime you need a worksheet.

Rick B



Fysh said:
I have a form which allows user to input data to evaluate personnel.
However, there are times when the user needs to print out the evaluation form
to use rather than using the computer. Also, the user can print many copies
of this same report. If the user creates a record with students name then it
saves the record in the appropriate table. What I am attempting to do is if
the students name is blank then create the record in a separate table. The
reason behind this is when the user comes back to input the data rather then
typing all of the scenario criteria just use a pulldown to find the id of
that particular blank record. Also, since this same blank record can be used
for several poeple I don't want to save it in the same table as the rest.
Once the user selects the id I then want it to populate the form with the
initial criteria.

Sorry for that long reasoning, but here is my question. Is there a shorter
way of writing to save the record into another table rather than the original
table? For instance do I need to write rst![name]= me.name etc. Not every
field on the form is written to just one table, but I think I might need this
in one table when they select the id number.

Any thoughts would be helpful.
Click to expand...
Click to expand...
 
Back
Top