Search results

Kharwar By way of an update, I managed to integrate the function you had composed within my application. It now works extremely well. As regards my earlier message about Runtime Error. In testing it appears that the xDate field and/or certain validation, does not like the date 02-Mar-09. As...

I have a form called FRM_FlexiEntries. There are two controls on that form called [Staff Name] and [EmpID]. I am trying to get DLookup to compare the [Staff Name] on the form to its counterpart called [Fullname] in [QRY_StaffDetailswithFullname]. Upon matching I want it to return the...

Thanks for the offer Jariamj. I'll post back if needed. Cheers Frank

Kharwar Nearly there. So many thanks for all your support. I've adapted the form to pull from my query containing the relevant data and amended the module code and form code accordingly. When I open up the form it shows the data but at the first record I get an "Runtime Error 3021 - No...

Bump Anyone? Sorry folks but I'm struggling here, as my previous post will show I've been on this for some time. All help greatly appreciated. Thanks Frank

Hi Kharwar No. There are no weekly limits on time unless the user exceeds the 14hr 24 mins max. All subsequent balances continue from the previous entries. On the subform FRM_Flexi Log, you'll see a calculated control in the footer calculating each weeks surplus deficit. I then have a...

Hi all Those close to this board will know I've been working on a Timesheet system recently. I'm self taught in access and know very little VBA so when it gets to doing clever stuff I rely heavy on the support from the good people her - so thanks to all who have helped thus far. Such is my...

Thanks to all of you. I did indeed have some code in my OnCurrent property that was the cause. Now duly removed. Thanks again Frank

Cheers everyone All very helpful. I'll check the form and get back to you. Thanks Frank

Hi Banana Affects both methods. Thanks Frank

Hi all Currently if a user clicks on the Forward record selector it will create a new record. Parent Form has two subforms, some controls have default values. Is it the Default values that are enabling this or something else? More importantly, how would one go about preventing it? Thought...

Hi Kharwar I'm almost there thanks to your invaluable assistance!!! One more thing I'd like your help with. Currently I've got the routine calculating the correct totals but at present after changing the times per day, I've got to exit the form, open the UpdateRunningSum form, click the...

Karwar This look great. Unfortunately I'm at a loss to understand how i integrate it within my application. My users enter their weekly times, day by day. From here I have a few queries which calculate the Fleximins and Fleximax. The times are entered onto a subform within a parent form...

Folks Following up my many posts on this (thanks to all) is there any way of limiting the Running Sum to a max limit - in my case 864? So that upon exceeding 864 it is set at 864. Thereafter reducing accordingly if subsequent weeks are in deficit. See Mick example below. 1160 should be 864...

Afraid not John. Needs to check the total on a week by week basis, capping it at 14 as and when it exceeds that limit. Thanks Fozi

Thanks for the reply missinglinq. In response. I work in the UK, we are not governed by Federal Labour Laws This is not an overtime issue in the purest sense. I may have referred to it as such in posts but this was to ease understanding, which I have obviously failed at in this case. This...

where is the running sum? It's currently created within a query. you have it on a form? I have a control on a form in which I would like it to display the current level of overtime, not exceeding 14hrs. how are you calculating it? in a query? Yes. Calculated by totalling all the...

Is it possible to cap a running sum? I have users entering their working times per week which calculates any surplus/deficit in time. Thing is they cannot accummulate more than 14 hours overtime. So if any users running sum exceeds 14 hours is stays at 14 hours and if the next week they...

sorry I should have been more specific. The form in question is entitled FRM_Activity and Flexi Entries by Week which has a few subforms contained The main query is QRY_FlexiTotHrs which pulls through a total from the other queries per user. Although employees may accrue more than 14hours and...

Bump! Anyone? Would be grateful just for a steer in the right direction. Thanks Fozi