The challenge

[1jet]

Hi all,

Please have a quick look at the pic below...



in the middle of the pic...u can see "tblHours" as well as on the right in the relationships window...as u can see the form on the left will need to append data only to the ONE table so no joins are required...

my problem is that my sql query skills are limited and i can only come up with a query that will append ONE line into "tblHours"
eg...
INSERT INTO tblHours ( [Project ID], [Employee ID], Date, Hours )
SELECT Forms!frmEmployeeTimesheet!cboSelectProject1, Forms!frmEmployeeTimesheet!cboSelectName, Forms!frmEmployeeTimesheet!txtSunday Forms!frmEmployeeTimesheet!txtProjSun1;

the above code is just for "top left" unbound hours txt box

i was wondering if there was such code possible to append the WHOLE ROW of hours plus the employee and project ID to their respective dates

 

[1jet]

Yes I realised I'll be needing VBA.
Just on a quick crash course now actually

 

[stopher]

Have you considered using a datagrid object (there are many available). Much easier to manipulate than individual text boxes as you can address each "cell" by row/column. Also some can be bound to a datasource. Some are functionally rich (combos, tick boxes etc can be embedded in the grid)

The problem with displaying data in this way is that it is not normalised. I created a forecasting database (months as column headings and a rolling calendar!). My tables were normalised then I used recordsets to feed and save the grid. Took some time to put together and I don't know if it was the best approach but it works fine and I have the comfort of knowing that my tables are still normalised.

You might want to consider doing the front end in VB. There seems to be more information and tools available for using grids in the VB environment from what I could see (although the process is much the same). I used Access

hth
Chris