Recent content by Dilly

Sorry no column containing Dept. As stated before this spreadsheet does not belong to me and I would probably redesign it. I can advise changes but they do not need to be accepted. I am going with Xlbo information and modifying the information in the thread he has linked to. The solution to...

Thanks for the help I will use the VBA code

I cannot get the correct sytax for SUMIF for the color. No conditional formatitting, manual intervention. I am trying to keep it simple for the owner

Sorry cannot download any add ons as company network. Basically the spreadsheet is not mine but the logic is that we have two Dept with a similar type of worker. We man work with these workers and it reflect by Green or Yellow which Dept they orginate from. We show these men required against...

I am using excell 2003 and trying to sum a column by background colour. My column has values in with two colour backgounds Green and Yellow. I am trying to create a total sum at the bottom of the column for each colour but cannot get it to work. Any advice please?

Hi, I am trying to create a spreadsheet that will automatically import worksheets from excisting worksheets in differant folders on a network? Can it be done. Basically i want to duplicate date from multiple spreadsheets onto a single spreadsheet.

Please could somebody tell me the criteria to select records from a table with a unique referance number with a letter at the end. Example 544327b. I want to select all records with a letter and ignore those without

Hi, I am trying to create a query that will derive the year from todays date and date of birth. i.e Todays Date - Date of Birth = Years (Single no)

I have a from with a subform within. On the form you can seach for a Part No that can retrieve multiple ammounts on a subform how do i crate a field on the main form that adds up the total stock in the subform and displays.

Can anyone tell me if its possible to force a report to open to full page view insted of only being able to view part of the report.

I am selecting the Filter by Form, it clears all records but sometimes leaves old filter data in some of the fields. I want this data to be cleared, so that the filter starts a fresh each time. The users of the database cannot understand any thing out of the ordinary, which means creating a form...

I have a Form in a datasheet view. The data is presented with the fields across the screen and records continous down the page. I am trying to get the fields to all be cleared when i select the Filter by Form Icon

I have created a form to create new logistics requests. I want the system to prompt when the form is closed to ask whether or not saving is required. I have tried to create a macro but it still does not ask a question.

I am trying to Export an Access report to a folder within my NT network. The problem is that when using the HTML or Rich Text formats all the Formatting on the report is lost. Is there a way of exporting the report so that the layout and formatting within the access report is not lost.

Is it possible to make a Tick larger within a form. It seem a little small and I require it to be more prominent.