Search results

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

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

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

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...

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...

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...

Morning all I was wondering if it is possible to count the number of (different on occasions) coloured cells within a spreadsheet. ie... Our company has a spreadsheet with a calendar and operatives colour cells 'red' if on annual leave, 'yellow' if on Training etc..... I was wondering if...

Afternoon I have set up a table with the fields set as Long Integer and 2 decimal places. I have created a form to input into this field but for some reason the form will not allow me to input a decimal figure ie 1.50 etc..... When i input 0.50 it rounds it down to 0. WHen going into the...

Morning. I was wondering if anyone could possibly assist me. I am trying to upload data from Excel into Access tables. I have successfully uploaded all the data apart from the Yes/No field. I have tried putting Y/N and Yes/No and neither is correct. Is this possible to do and if so what...

Hi I have created a form using the data from a table. When creating the form i have not used all the fields from the table. I have gone and amended the table by deleting a field i no longer require and now when i launch the form it asks me for a 'parameter value' for this field that no...

Afternoon I have a problem that i am unable to resolve and asking for some assistance. I have attached a database whcih has my problem. If you click on the form 'Input HAVS Information' and when inputting a new record you will notice that the first 3 input boxes are carried through to the...

Afternoon I was wondering if it is possible to maintain the detail of some of the fields within a form (When inputting data) when you select to move onto the next record. i.e. If you have four fields. (all fields are selections from a combo box. ie Days of the week) Field A: Monday Field B...

Morning all. Hopefully this is pretty straight forward. When entering information in a form i want data to automatically appear when i enter details in a certain field. i.e Table_1 Name Age Height etc J.Bloggs 30 6'5" Form_1 Name:(When selecting this field from a combo...

Morning all, I am having problems trying to create a query/report from the tables i have set up (which may not be set up the best way). The objective: I am trying to write a report that represents the total weekly number of 'points' usage of a vibration tool by 'operative'. An 'operative' can...

Does anybody know if it is possible to have a yes/no tick box cell in excel? Cheers

Hello I am new to Access and am unsure as to how i acheive my aim. I have attached a copy of my example database. Query: I have a table (tbltoolsCategory) that i want to be a parent link to other tables (tblChainsaws, tblStrimmers, etc) within the FORM (Date and times). for example if i...