Recent content by Hazel

Please help I have a main form, which has a tab control page. In the tab control page 1 there are two sub forms. Problem is i would like to be able to tab from 1st tab control page to the 1st sub form then on to the 2nd sub form then on to the next tab control page and so on. I have 11 tabs...

Can anyone help please ! I have a form with various fields, problem is that some fields need to be protected after information has been entered and no changes can be made. Hazel

I have a table & form which has a field called address. I need to create a query that lets me select all addresses which may contain say George Street, this includes lock ups and individual addresses for that address, i hope you will understand and be able to help

You are a star

What exactly to you mean The field that is in my sub reports are in report footer and give me a grand total of another field or do you mean the two fields that are in my main report Please attached file Go to Reports Paint Measurements - Full Report (Q)

I have a main report and two sub reports the two sub reports have a report footers with =Nz(Sum([TOTAL PRICE]),0) my main form has two fields (SUB TOTAL & NARR SUB TOTAL) that refer to sub reports =Nz([PRICES & QTY's (Q) subreport].[Report]![SUB TOTAL],0) =Nz([NARR - PRICES & QTY's (Q)...

I have a form which has a start date field & end date field i have a query that works out how many days from start date to end date that excludes weekends now my boss wants it to exclude any holidays we may have such as bank holidays etc can any help me with this i think i need a module and a...

Hi can anyone help me find the following 452183-ApptDiary.zip i had a look at this before now i seemed to have misplaced it thanks H

Subform go to a new record Thanks John for this. Only problem is that i only want the last service date for the customer that is one screen not all of the other customers do you know if i can do this.

I have one form and one subform form has customer details subform has customer service records i would like to know if when the main form is opened at a certain customer that the subform could display the last service record and a new record subform is in datasheet view. also i have a field...

Thanks for that

I have a date received field and date completed field I have an expression that works out the no of working days it takes to complete Problem is that although the date received will always have a date entered i have to wait until i receive the dates to enter in the date completed field, thus...

Thanks for that but i iam still getting a small problem When i enter at date such as Monday 06/06/05 my due date that counts 5 working days gives me a result of Saturday 11/06/05 is there a way of resolving this so that sat is not included. Also due to this table being linked to another all due...

Hi Sorry about that was a bit confused and trying to do too many things at once. This works but now I have errors comming up on the due date field how can i sort this Hazel

In my queries i have two fields 1st Field is called Termination Date 2nd Field is called Due Date: 3rd Field is called Date Completed: 4th Field is called (+/-): Termination Date = I enter a date such as 20/05/05 Due Date = Automatically fills in using the expression below 17/06/05 The Due...