Search results for query: *

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.

Is it possible using a Macro to get a Sub-Form field to update a field on the Main form. I have a Finish date field on the main form. on a sub form I have a extention request form with a Extention start date and extention period field. I an trying to get the Extention field to update the Finish...

I have a report that ha a list of "Delivery Days", I am after a way of counting the number that are less than 3, 3 to 7 and 7 upwards can anybody help. I know how to create a count of the total number of records but cannot work out the syntax to seperate count by the three groups. If...

I created this in my query that gives me the correct figures but the headings are <>, 0, 1. Any suggestions, I did not fully understand your solution.

I have a database that contains Items procured for differant projects. I have created a query that works out the delivery time of the items using date recieved - date demanded. I want to group these in a count of items recieved in the following time scales. 1. Less than 3 days 2. greter than 3...

I am planing a form that will show jobs required to be actioned by differant people. I was thinking of using a box with a underlying count query to show job requiring action. The query will use a table that will be linked to another database and be being updated all the time. I require some way...