thanks for you help , n8kindt
but , i dont' really quite understand....
in this way, does this filter out everything that was not selected...so , how could user view the month that wasn't selected by the admin
please hlep ..thanks......
lulu123
Last Activity: Jul 2 '08, 12:46 PM
Joined: Jan 31 '08
Location:
-
n8kindt , thanks.
yea, the idea is to let the employee view the past month only , and able to edit current month. However, the purpose of the combo box is for an admin, so, she/he could choose which month to lock/not lock.
thanks.
Re: How to lock specific records based on selection of Month?
--------------------------------------------------------------------------------
...Leave a comment:
-
Thanks for reply, guys.
The combo box is for the admin, and it will be on a different form. So, the admin could select the mont she want to lock/not lock from the combo box.
any suggestions?Leave a comment:
-
How to lock specific records based on selection of Month?
I have a database, which keep track of the hours employee worked.
The employee enter the hours monthly. The table is set to like,
Project/ Month/ Hour/
what i want to do is: I want to lock the record based on the month. if i make a form with a month combo box. ..I want all of the record to be locked except the record that has the month matching the selected month. so, when employee enter their hours, they can... -
Thanks for reply cori.
for the first problem, i find the solution. which the code as following
.RowSource = "select distinct [projectID],[projectDescript ion] " & "from Projects " & " where [projectID]=" & Me![projectID] & " order by projectDescript ion"...Leave a comment:
-
cori, thanks for reply, but this doesn't really solve my problem.
1), my rowsource is part of the a vba code, where there was if condition as well. So, i can't really use the property box with the "..." to make it in oder. if i am writing this in VBA code, Do you have any other suggestions?
2), for the 2nd problem, i dont' really want to close and reopen the form. Because there is a filter on the form, where...Leave a comment:
-
two questions. 1) rowsource 2) refresh combo box list after add a record
here's my problem
1) rowsource
.RowSource = "select distinct [projectID],[projectDescript ion] " & "from Projects " & " where [projectID]=" & Me![projectID]
I have the above code, and it works fine. however, i want to make the combo box in alphabetical order by [projectDescript ion]. I tried to add "order by [project Description] " after "me![projectID]".... -
Thanks for replying...
I still don't understand, can you pls explain more.
What is back end? does that mean i have to split my databse? if so , how should i do that?
If i want use PES, how would i do that?
Thanks a lot....Leave a comment:
-
multiuser .....
I am making a database for around 20 users.Just wondering if i put the database file on a net work drive, will everyone be able to open the database at the same time? If that is possiable, and everyone start to enter data at the same time, Would everything being saved at the same time?
Please give me some advise. Thanks. -
hi, thanks for replying, jaxjagfan..
but, it still didn't solve my problem, i don't think i explained it clear enough...
the problem is that, this mainform has a subfrom. the main form contains employeeID, and the subform is where employee can enter their own hours and monthes....and on the main from footer, i have this textbox, where i want it calculate the total hours for each month. So, if i use " empID=1" , it...Leave a comment:
-
sum or Dsum?
i have a textbox in a form. Where i want it to calculate the total of hours for different employees in different month.
when i use "=sum([hour])" it gives the the total of all employee in all of the monthes.
and when i use Dsum as " = DSum( "[Hour]", "[tablename]", "[MonthID]" =1)", it gives me the total of all employee in January.
my question is, what should... -
combo box problem -> won't display everything in a subform
I am new to access.
i have a subform (datasheet view), which contains 3 combo box(client, project, task), and here 's what i am trying to do:
after selection in client, i want Project and task to show the list that's ONLY associated to the choosen client.
I got this part done ok.
however, when i reopen the form again, Everything i choosed from the last step wasn't showing in the form. However,...
No activity results to display
Leave a comment: