Search results

Thanks JHB, it's quite a large database so I'll have to extract a 'lite' version that i can post for you - it may take some time. i had another look at the chart properties and saw one called 'size mode', so i will also experiment with this. Maybe it has something to do with scaling that is...

I have inserted a 2d column chart into a report and it looks fine, however when it loads into 'print preview' or layout view only 12 of the 14 columns are visible (2 columns do not 'fit' into the chart). I adjusted the column gap but it just makes all the columns wider and the gap between them...

using Excel 2013, I’m trying to use conditional formatting to display data bars inside cells linked to percentage values, so a cell with a value of 10 % is easy to differentiate from a cell with 80 % etc. When I copy the format to multiple cells (1,000 rows) it automatically sets the range (in...

thanks Rx, for your reply, it seems to work for formatting cell content (fill/font color) but I'm not sure it can be applied to data bars?

Thank-you for your replies. FYI. A data bar is a bar chart inside a cell to provide a graphic display of the value of that cell only (vs a chart that displays a series of values). attached is a screenshot example with the options (see dialog box) that are available.

Is there a way to format a data bar (inside a cell) with more than two colors? I can get the bars to appear green for positive values and red for negative values, but is it possible to show colors for other value ranges? Eg Value below 0 = Red Value between 0 – 20 = Orange Value...

Thank-you for your reply. I guess the answer to my question is that my design and what I’m asking it to do both need to change... I understand your point that you can’t change the data in a totals query, but I’m not trying to change that data – the data I need to change is in a separate...

I have a table (TbAttendees) for recording numbers of training course participants from different organisations (different rates may be charged to each organisation) and another table (TbGroups) to allocate facilitators and other resources for each group. I have a one to many relationship from...

thanks jdraw, it seems to work Ok, but for some reason not all records (ProdCode) are being returned in the query result... ie; some ProdCodes are missing from the results, even though they have data in the table...

I have a list of product sales for various regions. How do I write a query to only retrieve the record with the highest value in a region, but include the region and product code in the results? For example, If I run an aggregate query using the max function I still get the record for region...

I'm trying to run an sql update query (in VBA) to update values in a table, from calculated field values in a subform (using a query as a record source). Is this possible , and if so, can I call the subroutine from the parent form, and what would be the correct syntax for the VBA sql string...

i have a report with one grouping level that has subtotals for a field. is it possible to sort by the subtotals for the grouping level - so the group with the highest subtotal will be first, then the the group with the next highest subtotal, etc

My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3. When I open these reports they see the A4 'default' printer. If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change...

i have a problem with the datedif function in Excel 2007, (it displays #NUM! when i try to use it). I know this isn't an Excel forum - can someone recommend one? Thanks.

I have a table with more than 60 fields and need to update it with records from another Access file with a table with an identical data structure. Is it better to run an update query or an append query (i would have to delete the original records in the target table first) or a union query...

Thanks Gina, I followed the access-diva link but not sure which of the items you are referring me to? I still need to open and display/print the report to show that no records were returned...

A have a report that is based on a query that works fine when the query returns records. However if the query (legitimately) returns no records then the report fields (numeric) are blank. How can i get the query or report to show either "0" or "no data" when no records are returned? I have...

i have a crosstab query to summarise the counted string values form another query: eg; TRANSFORM Count(Table1.Viable) AS CountOfViable SELECT QryTable01.productName FROM QryTable01 GROUP BY QryTable01.productName PIVOT Table1.Viable; as there are some null values returned (ie blank...

Thanks namliam - i should have googled more! I found the following code that returns the size of tables... would still be interested if there is any way to find out the relative size of other objects (forms/reports)...

Is it possible (using the menu or VBA code) to find out the size of the objects in an Access database file? For example if the .accdb file is 300Mb, is there any way of comparing the size of the numerous tables/forms/reports/queries etc, that make up the database? (I know that if I created a...