SQL connection to Absence request form

[Phil]

I tried this some time ago but failed.
I want to store the absence request data on either an access or SQl database
so that I can use it to total employees time off from sockness holiday etc
over several years.
Has any one managed to do this?

 

[Art]

Actually very easy once you have done it once

Set up your SQL table and then create a new form based on a database
connection.

Make sure your SQL table has a unique primary key.

This will become your "main connection"