Search results

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

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

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...

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...

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...

In my queries i have two fields 1st Field is called Termination Date 2nd Field is called Termination Notice-Due Date: The Termination Notice-Due Date has an expression builder i.e. Termination Notice - Due Date: [Termination Date]+28 This then gives me a Termination Notice - Due Date...

Can anyone help I have one field that you enter a start date the next field is the start date that adds 28 days to give a due date but this includes saturdays and sundays which i dont want i only want the working week/day. Please help

I have a field named Admin Charge which is the sub total multiplied by 12.5% (sub total*0.125) now if this is equal to or over £50.00 i want it to equal no more than £ 50.00 going nuts on how to calculate it (Access 2002) someone please help