Sub form access problems.....

[ItIsHardToProgram]

I might not be in the right forum section, or asking the right people since my question will seem to you prety stupid, but here goes.

I am presently writting down a simple mdb databse in access and I related a timesheet to that database...

My problem is the following, the timesheet is divised with subform That splits the time spent by projects. in that case, I have no way of coming with with any fonction that relates the subform to the form. I need those for a printable interface that I have made, but I am unable to copy the entered information in the subform to the cells in the form.

2nd(security): every form is divised by time sheet numbers and I would also like them to be divised by employee number, with a password ( not allowing employees to see other employees time sheet, and allowing the admins to see every time sheet).

Of course this is only 2 problems I have out of many.... and I won't give you a headache with my puzzling way of operating so I will stop there. I don't want any one to waste time into this unless you are willing to. I am ready to learn from scrapt(since I only know very very very basic vbase coding[ifs, loops and barely any commands.....], and I don't even know acces fonctions). So if you could at least point me to a tutorial, a free one since I am pratically pennyless, I would be glad to learn.

Thanks in advance for your help.

Julien Roy.

P.s. Sorry for the long thread.... but to me my problems are that complex......

 

[Golom]

I suggest forum702 (Microsoft Access Forms) or forum705 (Microsoft Access Modules (VBA Coding)) as more likely to find the experts.

 

[Pampers]

If interpred this right you want to have a projects form with a timesheet subform. First of all you have to set a relationship between the two tables:

table1: tblProject
ProjectID - Primary Key (PK)
ProjectName

table2
tblTimesheet
TimeSheetID PK
ProjectID Foreing Key (FK)
Time

Set a link between the PK and FK in the relationship view.
Then create the form and subform

Pampers
Just let it go...