Search results

Bump! Sorry to be a pest. I appreciate that this may be something that takes more time than may be available so even if anyone can point me in the general direction of what to try etc... For example, would it be possible to have a query that gave totals but where a parameter for the maximum...

Bump! Managed to get an extension. Grateful for any assistance folks. I've looked at it so long it has become meaningless!!! Thanks Fozi

Guys Working on a timesheet system where users enter their weekly times based on a 36 hour week. I have a backend query which takes these times and totals each users overtime/deficit. On the form where times are entered I have a control which pulls through the total time accrued for each...

Thanks DCrake. Ideally I'd like it to show positive and negative values so as to perform the calculation of time owed or time taken each week. Is this possible without affecting the time module? Otherwise I guess I can run an if statement reducing the total if time worked is less than time...

Hi DCrake I'm working on the help you offered recently and have hit a snag. Have inserted a couple of calculated controls which capture what individuals are due to work each week against what they've actually worked to identify the difference. Finding that when it is in deficit the minstotime...

Why not have cascading comboboxes where first box identifies the type of business ie. plumbers, electricians etc and the second combo (linked to first choice) lists the companys Fozi

Hi. Got it sorted by placing the code in the On Enter Property of the Two subforms. Thanks for your help. Fozi

Thanks for the reply rainman. i tried searching and found some info on ensuring controls have an entry but little on those where there must be an entry and where it must be filled in first before moving onto the other controls on the form. Tried the code you suggested. It triggers if...

Hi all On a form I have a control called [Week Commencing]. Within this form are two subforms joined by this control. On entering a new record focus is set to [Week Commencing]. I want the form to prevent users moving away from this control if it has no entry. Any clues? Thanks for taking...

Thanks Jan but unfortunately it didn't seem to make a difference. Will try it with the On Change property Thanks Fozi

Hi On my Parent form I have the Control [TotalHrs] which contains a numeric value. A subform called [FRM_Flexi] has a control called [FlexiTot]. What is want is for [FlexiTot] to automatically change according to the change in [TotHrs]. I've tried putting in Me.FlexiTot.Requery in the...

Sorry Brian Didn't explain that too well. The sort order is fine but the values reporting for NextValue are not accurate when compared to the entries within the table. NextValue shoudl show the previous FlexiValue for that member of staff. Fozi

Attached is a query which for the life of me I cannot get to order as it should. It is linked to a master table containing staff timesheet entries by week. I want the query to display in the correct sort order (by StaffName, by Date) showing a running total of overtime accrued by each person...

Thanks Gemma, thanks for perservering with me! lol Not really what I need. I'll try to explain here with this example. [Staff Name] [Week Commencing] [Hours Worked] [PrevOT] [Balance] John 02/03/09 39 17 20 John...

Thanks Gemma but just not getting it to work. My VB skills are pretty limited to say the least. Is there any chance you (anyone) can check out the attachment and get back to me. Cheers Fozi:confused:

Staff complete weekly timesheets each monday for the week before. Their time is then totalled for that week. A calculation is then performed to work out their excess hours for that week. On each record I want a control showing the overtime balance carrying over from the previous week for...

Hi folks Still struggling to get my form to pull the overtime balance from the previous entry for each staff member as they enter a new record. Deadline for submission looming!!! I'm working on a timesheet system and wondered if its possible to bring the following functionality to a form...

Missingling I entered the line you suggested but to no avail. Only on clicking for a new record where the two fields have a default value of zero does the button appear.

Missinglinq Apologies for the abiguities which obviously frustrate. I will try to answer your questions in more detail now. The two total controls on the parent form are both numeric controls, Fixed with 2 decimal places. These consistently add up to the correct totals. The only function...

Hi by way of an update. I've discovered that this works unless the two values ([TotActivity] and [TotTime]) end with ".00"! Strange!