Recent content by veshand

OK Guys! this one is challenging! :D We've got three connected tables: 1. tblEmployees (Fields: ID, EmployeeName) 2. tblDays (Fields: ID, EmployeeID, Date) 3. tblTimesheet (Fields: ID, DateID, Project, Hour) these tables are one-to-many in regard with the next one. In other words, for each...

Thanks a lot!!! i will definitely read it thoroughly Love!

Post #8 was great! it helped me a lot!!I did as it said!! Thanks!! I wish access guys would go around and ask users how to improve it before issuing the next version! :D

Hello there! Thanks for your reply, I am appreciative. Well, the query Im looking for should not count, but number them, starting from 1. in other words, if an specific employee register an item in a new day, this registration should be numbered from 1. any idea? yours

Many thanks for your time and guidance. Well, such query shall number each record base on these two fields. each time the employee or date change, the numbering shall start from 1. for example if an employee registers an item in a new day, the numbering for this specific employee should start...

Hello all! Here is the question! I have a table as below, named tblRollcall, with two fields (EmployeeName and DateOfRegistry). I need to number each record based on these two different fields. EmployeeName................DateOfRegistry...

Hello Dears! :cool::cool::cool: here is the question! i have some people, working on different projects, for specific amount of time per day. so far, i have a table (tblTimeSheet) just like this: [date]_____[Name]___[Project]__[hours] 1/1/1________x________a________1...

Hello ridders! thanks for your reply as you ordered, i ommited the [] and .text. i also corrected the "employee" DoCmd.OpenForm "frmReg", , , "EmployeeName = '" & Me.EntryEmployee.Text & "' And Bossapprove=True" however, i still get the "Enter Parameter Value-> bossapprove" message! is it...

Hello everyone!! :) I am trying to open a second form ("frmManager") using docmd.OpenForm order in the first form ("frmLogin"), which has got two different criteria: 1-on one hand, i want it to open the form into specific username data ([EntryEmploee]) which is provided by user. this field is...