Search results for query: *

Hi there, I have this formula: =IF(All!C1="Employees",SUMIF(D2:D25,1,$B$2:$B$25)/(SUMIF(D2:D25,1,$B$2:$B$25)+SUMIF(D2:D25,2,$B$2:$B$25)),SUMIF(D2:D25,1,$C$2:$C$25)/(SUMIF(D2:D25,1,$C$2:$C$25)+SUMIF(D2:D25,2,$C$2:$C$25))) I'd like to drag this accross columns in one sheet, but would like the...

Hi there, I am struggling to come up with a formula to use within Excel 2010. I would like to work out a weighted average based on the content of another cell... so, to try and illustrate, see image below: I would like to know how to calculate: - the % of employees who said yes - the % of...

Hi there, Apologies for this relatively simple request - but i'm not quite sure how to do this. I have a field in my record: dob I'm looking to run a query that will tell me all the birthdays in the next 6 weeks from when i run the query - but i;ve no idea the syntax for this? any help you...

Hi there, I have a spreadsheet which has income and outgoing expenditure - fairly simple. Income has: - Amount (A Column) - Date (B Column) - Description (C Column) - Ringfenced (D Column) The D column is a choice between yes or no - i have a data validation list to get these choices from a...

Hi There, My database window has dissapred when opening up one of my databases (its only this database it does it with). I have tried holding shift and hitting F11 etc - and even clicking the "database window" button. I had thought that it had maybe just been pushed of screen as i switch...

Hi there, Im trying to create a dialogue-style form - but I cant get it to a small size - it goes full screen when viewed as a form, with no controls to resize - Ive tried various options in the form properties, but to no avail. please help! many thanks, Neil

Hi there, I'm trying to get a simple count of records that are displayed in my list box - these records query 3 tables for their data (data displays correctly). I have the following code on the control source property of my text box (participant_count)...

Hi there, I'm about to start developing a database / solution for my local bike club - to keep track of the kids signing in for sessions etc..... one thing I would like to investigate is the use of barcodes. having never worked with barcodes, I've done a little research - and I was just...

Hi There, I have a text box on a form which includes the full name of a person - I would like to ba able to take the first name (any text before a space) and copy this into another field - but im not sure how? Any help would be appreciated, many thanks, Neil

Hi There, I would like to create a macro that will open several reports, and print them to my non default printer (adobe PDF). However, I'm not quite sure how to achieve this - any help would be greatly appreciated, many thanks, (Access 2007) Neil

Hi there, I have a field "link" which contains a full hyper link address. beside this field, I have a button. I want to be able to click this button, and it loads the web page (associated with the hyperlink) in a new window. I've been looking at follow hyperlink method - but it has just...

Hi there, I'm want to highlight all fields on my form that have a null value by changing the colour of the field. i would like this to happen when the user opens the record. Any help is greatly appreciated, regards, Neil

Hi there, I have a table with 2000 records, i want to create a new field called "Name" I want this to be equal to the value from "label" & "artist" So, if: label = 1 artist = Test I want Name = 1 Test I have imported my data, and have added the "Name" field - but i now want to update this...

Hi there, Im creating a database that im going to use to create contracts for a speciic record. my contract is a 3 page word document and when i try and put the text into a report it informs me my text is too big. So, now im thinking, i need a button within my access form, that when pressed...

Hi there, I've recently got a new laptop, with no parallel port and Vista Home premium. I bought a USB to Parallel Cable - and have plugged this in. I have added the printer driver, and have changed the port to USB001 - but, unfortunately it is not printing anything -with no specific error...

Hi there, I have a cable provider who provides me with an ip address, years ago (before wireless was big) i used to access my PC from uni (using software) and my ip address. Now that I have a wireless router between me, and my modem (and therefore a local IP) is there any way of me doing this...

Hi there, I have a cell on my spreadsheet that has the year of birth, and based on the below - I need it to work out the category: Under 10 born in 1999 or later Under 12 born in 1997 or later Youth born 1993 to 1996 Youth - Under 14 born 1995 or 1996 Junior born 1991 or 1992 Senior born 1990...

Hi there, I have a formula in a test condition spreadsheet - which is used to count the number of conditions that are still to be run, with low/medium/high priority. I have the same formula(s) for high priority / low priority etc. This formula works and counts correctly...

Hi there, I have some code on my form which i got from this very helpful topic here: http://www.databasedev.co.uk/open_word_doc.html However, my requirement is now to open different file types. E.g. there may be a word document in one record (which works fine) and a visio document in my next...

Hi there, I have a form, with a subform: Main: document_log Sub Form: sign_off My main form has a tick box (boolean) yes/no. My Subform has various records, and each record has a sign off tick box(boolean) yes/no. What i would liek to happen is the following: If i all the records within...