Search results for query: *

I have a class Relationships which has various properties. One of which is Person which is a class with various properties. I am trying to bind my ddl to the property PersonLastName which is a property of Person which is a property of Relationship So: ddlPerson.DataTextField =...

My DVD player will happily read DVDs and CDs. However I can't see what is on a disc. If i go through my computer nothing happens. If i go through explore it shows a plus next to the disc but clicking on it nothing happens. NEC DVDRW ND-3520A XP PRO Any suggestions gratefully recieved? Many...

I am replicating from SQL 2000 to SQL 2005 using a transactional replication with a pull subscription set to pull every hour. This will work fine but occasionally one hour it will return the error: Unable to start execution of step 1 (reason: JobOwner DOMAIN1\Administrator doesn't have...

I simply want to have a 5 (single page not facing) document with pages 4 & 5 set up in landscape. Is this possible? Or at least to just rotate the view of the page by 90' so i could work on it without having to turn my head sideways! Many thanks for any help Cheer John

I have a dynamic named range CENTRES defined using the OFFSET function in workbook1 in workbook2 i want to paste a link to that range. However, obviously the CENTRES range is growing. The simple solution is to paste a link to the cells containing the range and all those it will contain during...

I am trying to utilise the sumproduct function and can't seem to get the correct syntax for the date. I am using: =SUMPRODUCT((CENTRE=$A4)*(RDATE>C$1)*(RATE<C$2)*75) I want to add another criteria that looks at the range WITHDRAWN (date). I want it to check that 1 it is null or if not null...

I have a report sheet that looks at data from another sheet. The function is am using is =SUMPRODUCT((DATER<$A26)*(DATATRIALS="Leeds")) Where: DATER is a date on another sheet Column A lists months. DATETRIALS is text This works fine but isn't that tidy. I want to replace the cell refernce...

This may be something stupid but anyway... I have a table that is growing every month. I want to produce a chart that automatically grows as the table grows. I have used the OFFSET function to define a dynamic range. When I enter the name into the chart 'DATA RANGE' all is well. However on...

I am trying to use the sumproduct function to count based on multiple criteria. centre_code, dateR, trials_unit. Basically I want to count the number of records where trials unit = X and DateR falls between 2 dates. Sumproduct... Easy. The problem is that there are multiple records with the...

I'm losing hair fast.... I have 4 querys selecting specific data from 4 tables. I merge them with a union query. All good. I try to use that data as a source in a mail merge in Word. It can't see the union query! Perhaps word doesn't like union queries I think. So I run a query on the union...

I have 2 workbooks. One is internal holding all information. The second is a summary for sending out to external parties. The 'Summary' workbook draws its data via pasted links to cells in the main workbook. The problem being if I email out the summary sheet the doctor opening it at the other...

Hi, As usual my knowledge limit has been reached. I have posted a similar question in the past but it was poorly explained and hence a number of the answers didn't really fit the requirements. 1 have 10ish sheets representing different centres. All similar layout. Each with many columns of...

With great thanks to skip for previous assistance I present a new and to me impossible challenge. I have 2 tables. DATA and RECRUITMENT TOTALS. DATA holds many columns of patient data. It has one table row 1 and 2 are headings. The 2 key columns are (Centre Code) and (Date of Randomisation)...

This seems really easy in Access however in excel it seems a whole world of pain. I have a sheet that is constantly update (CentreOverview). This has a colomn (TrialsUnit) with 4 differnt trials units entered as text. I basically want to have 4 further sheets that show all the same data as...

Perhaps I have stared at this too long and the solution is obvious. I am trying to set up a series of fields within a table at various timepoints related to an initial field entered through a form. Sounds simple but i can't seem to get it to work. Basically I am looking for a simple way of...