Dynamically Fill Tables

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

Guest

Does anyone have any information on filling tables via code? I have an exam
database and am writing a program that builds an exam based on a variety of
user input.

As the user input changes each time the program is run, I have a great deal
of information and I need somewhere to place it all until the last step of my
program.

As an example, I may give a test on three different subjects. For each
subject, there is a breakdown of questions into image / non-image,
specification, topic, etc... All of this information is either coming from
the user or calculated during the program's running process, and it all must
be stored until the exam is finally generated.

Can anyone give me any assistance with this problem? What I'm looking for
is some basic information on programming with tables that will enable me to
tailor the information to suit my needs. As always, many thanks in advance.
 
Hi

To start with look up Recordsets in the Access VBA help.

Then look up the AddNew and Update recordset methods. There are very good
code examples in the help file for each of these methods which show how to
add new records to a table, and how to edit existing records in a table.

Also look up .Execute for running action queries, this will be helpful for
when you want to clear out the old records from a table.

Come back with questions from there. If you post the example code and ask
questions about each bit that you are having trouble with the news community
can help you with each part in particular and help tweak it for your
requirements.

Regards
AC

Joe said:
Does anyone have any information on filling tables via code? I have an exam
database and am writing a program that builds an exam based on a variety of
user input.

As the user input changes each time the program is run, I have a great deal
of information and I need somewhere to place it all until the last step of my
program.

As an example, I may give a test on three different subjects. For each
subject, there is a breakdown of questions into image / non-image,
specification, topic, etc... All of this information is either coming from
the user or calculated during the program's running process, and it all must
be stored until the exam is finally generated.

Can anyone give me any assistance with this problem? What I'm looking for
is some basic information on programming with tables that will enable me to
tailor the information to suit my needs. As always, many thanks in
Click to expand...
advance.
 
Back
Top