Create an electronic form

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

Guest

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.
 
Hazel Haldane said:
We do an annual TNA where Line Managers submit the training required for
Click to expand...
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
Click to expand...
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
 
Back
Top