copy table to a:

[Jean-Paul De Winter]

Hi,

I have created a project for our school so teacher can easily give points to
students.
Now they ask to change it so they can enter points at home, bring a diskette
to school where I will try to merge all data into one table for printing out
results.
The project of course has about 7 different tables.
Finally I only want one table to be copied to a: (the "points" table)
What is the code to automatically pick out only the points-table and copy
this to the a diskette?
Thanks
JP

 

[Rob Oldfield]

It depends on how you want the teachers to access the data at home. If you
want them to do it via an access table then you could use the
TransferDatabase command....

DoCmd.TransferDatabase acExport, "Microsoft Access", "a:\export.mdb",
acTable, "SourceTable", "DestTable"

This will copy a table off to an existing export.mdb on a floppy disc so you
may be best keeping a blank 'template' db and copying that first.....

FileCopy "c:\whatever\template.mdb" "a:\export.mdb"
DoCmd.TransferDatabase acExport, "Microsoft Access", "a:\export.mdb",
acTable, "SourceTable", "DestTable"

The template db could be set to automatically open DestTable when opened
(using a form if you want to run any kind of validation code)

....though you may well be better off giving them the data in Excel as
they're going to understand that better... see the TransferSpreadsheet
action for info on that one.

 

[John Vinson]

Hi,

I have created a project for our school so teacher can easily give points to
students.
Now they ask to change it so they can enter points at home, bring a diskette
to school where I will try to merge all data into one table for printing out
results.
The project of course has about 7 different tables.
Finally I only want one table to be copied to a: (the "points" table)
What is the code to automatically pick out only the points-table and copy
this to the a diskette?
Thanks
JP

A Table has no independent existance outside an Access database.
Unless all your teachers are comfortable with Access, or if you have a
scrupulously clean, user-friendly, secured frontend, I'd suggest
following Rob's advice and exporting the points table to Excel, and
manually linking the spreadsheets you get back and appending the data.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps