Insert unbound field values into a table (1 Viewer)

[rhyslewisdavies]

Hi there, I am working on a timesheet application which allows users to insert multiple timesheet entries in a grid style format. the first row is visible and to add another row users click on a command button which makes the next row of fields available and ready to fill in and so on and so forth. I need the fields to be unbound and then when the user clicks on a save button for example then it inserts those values into the relevant table.
Table name is tbltimesheet, field names are id, companyname, project, activitydate, activityhours, activitynotes, username, userid

Thanks!

Rhys

 

[here4real]

Create an SQL string with the INSERT statement and the FIELDS and VALUES. Then execute the SQL statement.

Easiest way.

You can Google the syntax.

 

[rhyslewisdavies]

yeah I got there in the end.

Thanks!