Search results

Thanks for your assistance, i think iv got my head around it!!. Does the way it is now set up mean my 'inputting' form is obselete as i have been inputting to weekend date and then each day?. Will i need to create a new input interface?. Thanks again

Hi Thanks I think i have done all the changes although with my very limited knowledge i am unsure if it is correct. Thanks

Hi The 'points per hours' column in the Tools table is not a calculated field (in the table) it is the 'points' per hour that the item of equipment gives out (in terms of vibaration levels-of which no person is allowed to exceed 100 per day-hence the need for the original report stated in the...

Hi Thanks for taking a look. The answers to your questions are: Yes an operator can use more than one tool per time period. Yes multiple operators can use the same tool over a time period, and is the case quite often. and No an operator can only belong to one Depot. Thanks again

Morning, I have two seperate parts to this query, Im sure its possible to do both but im not sure as my access skills are limited. I have attached a file with a report previously written (i have deleted unnecessary reports etc). PART1 On the excisting report i need to show the breakdown of...

Hello all I was wondering if it is possible to create a frontsheet to a workbook with 'buttons' on it to link to different worksheets and back? Regards Nathan

Hello all I was wondering if it is possible to print sections from different sheets within a workbookon the same page without copying and pasting the data into the same sheet?. Regards Nathan

Thanks, is it possible for the hidden sheet to become visible when you click on the hyperlink and then return to hidden when the sheet is closed?. Regards Nathan

Is it possible to set hyperlinks on a 'cell' to link to another tab/worksheet within the same workbook if the tab you are linking it to is hidden?. Thanks Nathan

Thanks for the assistance Greatly appreciated

Hi I was wondering why a 0 appears when copying blank cells into another worksheet?. Also how do you stop this if you are copying a larger block of text and some of the cells within this are blank and they appear as 0 when i would like them to appear as a blank also?. Regards Nathan

Hi Thanks for that, it helped. One of my objectives is to highlight and person who exceeds 100 'points' per day. I have been scratching around with it and i think i need to exclude the 'tool' part of the report to achieve this. I can do this but i am struggling with adding the two...

Hello All. I am trying to create a report from the data in the tables and am struggling!. I have attached a DB with sample data. I am trying to produce a report from this data that only returns certain criteria. From the data in the tables i want to produce a list of all 'Operatives' that...

Morning All, I am just wondering if it is possible to sort of superimpose text over already populated cells?. ie if all 25 cells within range A1:E5 have been populated and formated is it possible to select all 25 cells and write a word (ie N/A) in a shaded text over the top so you can...

Thanks for that, I will download that at home on my personal pc. My only problem is that currently i am having to use this at work and due to network priviledges i am unable to download such files. I was wondering if there is a sort of quick fix i could use in vb etc... Thanks again Nathan

Now with file attached!!! Sorry.. File attached Thanks

Afternoon all, I have attached a sample copy of a database with a report attached. I want the report to list all 'equipment' with the same date on the one page. ie: if an operative has only used one piece of equipment in a particular week then the report is fine as it is but in some cases...

Afternoon all. I have a general Excel question regarding the functionality. My query is: I have several spreadsheets within a workbook and i want to collate them all to printout on 1 A3 page. By copying/Pasting them into one new sheet then the width of Columns/Rows effects the appearance...

Thankyou Khawar Very grateful at how fast you got back to me and it has helped me loads. I only have one query about it. There are 1400+ records in the main table but only 670 for the report, I noticed that A.Spittlehouse has two records for 06/05/07 using two different tools for the same...

Morning all, I am trying to create a report from my tables and it seems a lot more difficult than i hoped it would be. It may be because of the way i have set the tables up initially. I have enclosed a copy of my database and below an idea of how i would like the report to look something...