Search results

there is no time element in my date field, but I can put one right? using now () ?? I can put the shift start field in the tblEmployees as well, but as for now I don't have the field :s

two shifts! first shift from 5:45am to 3:45pm second shift from 3:45pm to 1:45am 4 employees for each shift

okay!! here's a situation John is a night shift employee! he comes in at 4:00pm and works till 1:45am!! He will be using this application to enter data for his shift. After 12:00am, the date text box will show a new date on the subform where John will be entering data. That means any data...

hahaha! i mean somehow prevent the next date to come till 1:45am :O - i sound so weird lol. first I wanted to go back in time and now I want to stop time! their shift ends at 1:45am. I want the same date to show up from 5:45am to 1:45am!! as that is considered to be 1 day when it comes to...

wow! that worked. thank you so much :) they won't let me add to your reputation as they say I should add to someone else's first now lol p.s 1 less important issue :P is there anyway I can set the time for date() function. I know it's from 12:00am to 12:00am. Some of the employees work till...

Yes the subform is linked via EmployeeID! the fields in the subform are text boxes!! these text boxes belong to a table called Activities with primary key of ActivitiesID now this where I screwed up royally! my subform table is not normalized! I realized it way after. hence my subform is...

the user only enters the data for himself!! I have placed a code that recognized the users windows name and then I have assigned an EmployeeID to it. So when a user logs in the machine and then the database, he can only enter data for himself using his own EmployeeID user enters his data...

thanks!! but EmployeeID is on the main form and date() is on the subform. does that matter?

this is a requirement. that is what I want the application to do. Right now what's happening is that everytime the user opens the application, they see a blank record because it assumes a new record is to be entered what I want is the application to do is to find if data has been entered for...

hey vbaInet! Here is the situation: the user may enter the data on multiple times during a day. For example, he opens the database first at 9:00am, he enters data - Now if he comes back at 11:00am on the same day, he should see what he had entered and should be able to make changes as well...

hi, I want to create a home page where the user can view the Pivot form chart and reports together: There are 2 types of Employees: Day and night time. Each type of employee has their reports. Weekly reports are actually Pivot charts made on a form. Quarterly reports are simple reports and...

Hi guys, I have a form where which is bound on an Employee table with the following fields: EmployeeID first name Last name On this form, I have a subform where there is a date text box with a default value of date(). Employee of a specific ID enters information in the subform (filling in...

I hope soo too :D would lovee to help others!

got it! thanks again. I cannot believe how much I have learnt in 3 months solely because of you guys and this forum. Cheers

HAVING (((CInt(DatePart("ww",[dte],7,1)))>=CInt([forms]![filter]![weekfrom]) And (CInt(DatePart("ww",[dte],7,1)))<=CInt([forms]![filter]![weekto]))); this worked! thank you :))

same thing! I think it's taking weeks as: 1 10 11 12 13 14 15 16 17 18 19 2 21 that's why when I enter "1" and "2", I get from weeks 1 to 19!

Hi guys! I got the Pivot chart working, but I had to include =datepart("ww", [dte], 7, 1) in another column for the 2011 data to be on top of 2010 data. Here is my SQL: SELECT tblActivities.dte, DatePart("ww",[dte],7,1) AS Week, Sum(tblActivities.[High Cube Available]) AS [SumOfHigh Cube...

got it working! thanks a bunch everyone :)

okay! i think I am not following you properly. Sorry about that. I am attaching the screeshot of my SQL design view window - this was before my made any changes whatsoever. result for this query is as follows: Week 1 10 11 12 thanks!

sorting on [dte] doesn't sort on "weeks of a specific year" though, right? I have data from 1st Jan 2010 to current. I want to compare any current week with the same week from last year. For example Week 39 2011 vs Week 39 2010! I assumed Pivot chart would be ideal. How should I approach...