Create an electronic form

[Hazel Haldane]

We do an annual TNA where Line Managers submit the training required for the forthcoming year, can I create an electronic form from which the information could be directly inserted into a database created in office97.

At the moment the forms are sent electronically although the data contained still has to be manually entered into the database.

 

[Arvin Meyer]

We do an annual TNA where Line Managers submit the training required for

the forthcoming year, can I create an electronic form from which the
information could be directly inserted into a database created in office97.

At the moment the forms are sent electronically although the data

contained still has to be manually entered into the database.

Yes, there are several ways (in order of complexity):

1. You can build an asp front-end and use the Internet to directly update
the database.
2. You can use Terminal Services to update an Access form.
3. You can have separate databases and replicate the data on a regular
basis.
4. You can email the database and import the data.
5. You can output to a spreadsheet or text file and import the data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access