×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sub form access problems.....

Sub form access problems.....

Sub form access problems.....

(OP)
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......

RE: Sub form access problems.....

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

RE: Sub form access problems.....

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 afro
Just let it go...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close