Search results for query: *

Thanks JPaules Nico

Hi Mnat tahnsk for all your replies: Glenn uk : I ahve to work on RAG scoring (1, = Red Amber = 2 Green = 3) Each RAG on Parameters so Red is over a certain mumber e.g if over 10 or over = RED If between 3 - 9 = Amber If inder 3 = Red Thing is I have about 50 mertisc to rage each with their...

Hi All, How do I write a COUNTIF formula to produce the following results: I have active linked cells that show totals I want the countif in another location to show that if: the cells contents are over a certain number to show 1 the cells contents are under a cettain number to show 3 the...

Hi ALL, I have set up using Data Validation Function wirthin Excel using a list of 25 items taken from a list within same Tab of workbook. I want the List on selection and click to take the user to a certain 25 locations (within same sheet) locations have charts I want uswer to basically...

Many Thanks Geoff

Thanks Goff very kind have opened control tool boc have 5 tabs Size, Protection, Properties, Web and Control Cant find font size any where within these 5 is there an alternative? as control only shows input range Cell link Drop down lines 3d shading I'm I missing something Many thanks...

Hi All, How do I change the size of font within Combo and List boxes within Excel Forms Many thanks in advance Nico

I have designed a custom form in MS Outlook - Task - Would ilke to use this custom form as a template for arnother 50 tasks Have tried to publish facility but does not save after I close and re-open each respective task ,in which I have attempted to save it. Please Help Nico

Hello All please advise I want to have an auto-shape circle in Excel under the Drawing function - to show RED if a cell has a No input and also to show Green when the smae cell has a YES input I can do this with Conditional Formating within a cell but would like to perform the above within an...

Thanks - would you know how to have the calendar pop on the mouse rollover

Hello all, How do I build the active x calader control within combo box as pop up , that allows a user to populate the combo box with a user selected date from calendar?? Thanks all Nico

Hi All, How do I convery clients years of age eg (41.3) into client Date of Birt in a query Thanks Nicos

Hello all, Need help to change UK postcodes which are set out as follow: WA28WA CH451NT That is 6 or 7 in a string I need them to look like this: WA2 8WA CH45 1NT That is with a space after the 3rd figure if 6 figures in string , or after 4th figure if 7 figures in string Please advise

I have set up a datafield on a subform to collect Treatment date(s): When User attempts to complete date ie :01/01/2004 ETC.. A pop up appears with following message: You can't assign a value to an object: Object may be a control on a read only form: Object may be on a form that is in design...

Thanks Lupins & JonoB Much appreciated Nicos

Hello All, I have set up a text box to work out the age of client from their date of birth (Pat_DOB) which is completed in previous text box. I ahve inserted the following expression at Control Source of Unbound Age text box =(Int((Date()-[Pat_DOB])/365)) However when age text box is...

Thanks for tip Stephen Much appreciated Nico

Thanks for replies: Data is sourced to a Table - the table stores data no problem - the problem is that i want the subform to dispaly all inputted data by way of a datasheet - presently it only allows user to input single entry - on close and re-open - single entry no longer visible in subform...

Hi ALL, Problem is that Main Form is linked to a subform - indexes seem to work - but any data inputted is never there when I Close and re-open the Main form/Sub-Form. i.e. it only alllows me to input data once then it deletes data inputted. Your expertise is required Nicos

Thanks Thanks for tip Neil - much appreciated Nicos