Search results for query: *

Hi, Can anyone help me achieve the following? I want to be able to alter the fill colour of a specific bar (say to Red) depending on the label name which I want to choose from a from a dropdown list. eg. I have a list of wards which have population values attached and are shown in a bar chart...

Hi, Can anyone show me how to disable / enable the 'Protect Workbook' button using VBA, the button is located under the 'Review' menu option on the ribbon bar. I've looked at the official Microsoft Control Names list and I believe the one I'm trying to toggle is the following: Control...

Hi, Can anyone show me how to disable / enable the 'Protect Workbook' button using VBA, the button is located under the 'Review' menu option on the ribbon bar. I've looked at the official Microsoft Control Names list and I believe the one I'm trying to toggle is the following: Control Name...

Hi, I'm using the formula shown below (Excel 2003) to generate some required total figures, but I keep getting the dreaded #VALUE! error even though I can see the correct value being generated in the function arguments box when it is opened. I know it's giving this error because there are text...

Hi, I have written the following little formula which works well except for a known problem which I've now discovered whilst trawling the net: =OFFSET(INDIRECT(CELL("address")),0,1) The above formula always checks the last cell that was processed and not the one I always want it to check, in...

Hi Can anyone tell how to convert / use the value stored in a string field for directly referencing another given field value? I have a grid of textboxes (A1, A2 ... M1 etc) and I want to be able to put an 'X' in the chosen field which is passed via string value (ie. B3) My other thought is...

Hi, I've created a popup subform that contains a couple of my main forms data fields, when i click on a given subform record I am able to store the RecordID chosen, but what I want to do is move my main form record pointer to the same chosen subform record. Basically I'm creating a popup...

Hi, I have an Access 2003 query which generates a set of percentages, it's working nicely and correctly. As a quick check I thought I would total all the generated percentages together to see that they do indeed add up to 100% This is the expression in my query: TotalPcent...

Hi, Can someone explain how I go about printing 'No data available' in place of my subreport when it actuall returns no data? I'm 99.9% sure that I need to use the 'On No Data' event, but what do I need to do? Thanx in advance

Hi, Every time I create a new form textbox (using the Control Toolbox) in my Excel spreadsheet, it automatically resizes itself to just four dots instead of being the size that I want! Does anyone have any ideas as to what is happening? is this a bug! I am using Excel 2003 (with SP2...

Hi, I have a set of 19 questions in my database, each question has a set of 5 choices (5 boolean fields) which are all defined as Check Boxes (True/False): [Ans1], [Ans2], [Ans3], [Ans4] & [Ans5] When I tick one of these [Ans] checkboxes on my form I want to be able to make sure that all the...

Hi, I'm trying to join to queries together into one vertical list, but I seem to be failing miserably! Can some one help and tell me where I'm going wrong? I really need to create one long list from both sets of values Both of my queries have the same fields: [Gend] [PCR Output Description]...

Hi, I'm trying to get my query to show all of my QUAL.[PCR Descriptions] that are contained within a linked table, even if my main [INDIVIDUALS Starter Info] table has no values matched against them. Can someone help me please and tell me where I'm going wrong? Basically, I need to show the...

Can anyone give me an example of how to create a worksheet Dropdown List in Excel VBA which can be attached to a range of worksheet cells. I'm interested in seeing the difference in the file size as compared to creating them using the usual Data / Validation / List method. A simple day list...

Hi, I have 30 outputs which each consist of the following detail, when the tickbox is false I want all of details to be ignored and not printed, I have set the fields to shrink if there is no data. Tickbox & label Text field Date field But I cannot do the same for the tickbox label. I can set...

Hi, I've just updated my Win XP pro to Service Pack 3 and now I'm getting the following popup error message every time it boots up: WScript.exe - Entry point not found I can click on the 'Ok' button and the popup dissappears, but it is very annoying to see everytime, it also appears to have...

Hi, This is small but annoying problem that I just can't seem to get my head around, help! I have the following in my 'PcentNINO' Textbox control source: =Format(Count([NINO])/[TotMisBensRecs],"0.00")+0 This gives me a calculated percentage figure that shows up in the above mentioned...

Hi, I have two subforms placed on a main form (popup / modal), they each allow me to see a given record so that I can compare them side-by-side, I use this to look at possible duplicate records and merge their details into one record before getting rid of the obsolete one. My question is: Is...

I have created the following 'Outputs' table which has a one to Many connection to an 'Evidence' table, the structures are shown below: OutputsID ProjectID OutputReq (T/F) OutputRef (Text) Output (Text) Definition (Memo) EvidenceDesc (Text) DateChecked (Date) EvidenceID Evidence (Text) Checked...

Hi, I have an Excel worksheet which uses various cells and form textboxes to collect certain project information. The worksheet works great on all our computers bar one! On this particular computer the textboxes all dissappear, even though any previous entered data can still be seen in a...