Search results

Right ta for the reply. I have the following in a column heading of the query at the minute. Year 11-15: CCur(Nz([Years 11-15],0))+([YR 1-5 Total]="Solid Fuel Fires (State Number)") So I want it to contain any costs already in Years 11-15 but also add the costs for the record Solid Fuel...

Hello I am not sure If I can explain this toowell, but here we go. I have a table with components in and renew years this has a relationship with a schedule of rates (SOR) table. I have created a crosstab query which shows the component name as row, and renew year as column heading. The...

Works a treat!

Hello. I have a crosstab query which produces figures depending on the table. However some of the cells in the columns are blank when zero. Is there a way to show the zeros? However I know I can use Nz([field],0) to get the zeros. But this then will not let me make the fields Currency which is...

Partially resolved. I got help and I have now creating anew crosstab from the existing crosstab creating new columns with the calculations rather than in the report. This works a treat. However to total sum the columns I still have to do this in the report design which again is causing the load...

Hello. is there a way to calculate columns together in a crosstab query. The picture attached will help explain. I need to add the firt five columns to the sums already in the 6th column for example. As this is set for a report and currently I am doing the calculations in the report which is...

Right ok. Yeah it only becomes a problem when I open my database, it is set to hide all access features (runtime) so it looks like a stand-alone programme. Then the main form has commands which open a form within a subform (control source) then this subform has a command which opens the...

Thanks for reply. The front and back end are located togther at the minute as its under development. I am not sure what you mean by keeping backend open when if no bound forms are open. Also when I open the report itself on its own from the navigation panel it loads instantly every time.

Hello. I seem to be having an issue with my reports. When I open them sometimes the data will load straight away and other times it takes 10-30 seconds and other times it wont load at all until I start clicking where data should be. The template loads i.e. labels etc. but no text boes which...

Hello. I want to scale my report when I open it from a command button as a pop up screen. Can I set my pop up screen size but scale the report to fit inside? Thanks

Resolved with Builder using: Nz([Fieldname],0)+Nz([Fieldname2,0)

Hello. I have a report which shows a 30 year forecast budget. It is based on showing the first 5 years indivual then in 5 year increments. These figure are based on life cycles of component. I.e. 20years for a kitchen. Therefore if a kitchen cost is in year 2015 it also needs to be in year...

Resolved. I needed to make the report a popup. Thanks for your help anyhow.

Private Sub cmdKitchenTotalForecast_Click() DoCmd.OpenReport "Rep_Kitchens_CostProfile", acViewReport, , , acWindowNormal End Sub I want the report to open in a new window and not the control source where the subform is currently located. This code is just attached to a command button in...

Resolved - It was 'setwarnings' no Please change thread to resolved admin

Hello I have a macro which runs about 8 queries. But when I run the macro messages appear regaring what the query is about to do etc and requires a repsonse. Can I remove these so the macro just runs and then states finished? Any help much appreciated. Thanks

Hello I am having trouble opening a report from a command within a subform. I have a main form with a control source in which a navigation panel no the main form dictates what opens in the control source i.e. subforms. This all works great but one action I require is within this control source...

Hello I am having trouble with an embedded chart within a subform. I have a main form with a control source in which a navigation panel on the main form dictates what opens in the control source i.e. subforms. However I have a form with an embedded chart which opens in the control source but...

How would this link be incorporated into access? I have just been manually adding all the photographs as attachments. lol works but taking along time. Also when I view the form the photographs load in the controlbox. However only when you click into this box does a small navigation button...

Examples of labelled photographs: 900100032_32_peel_road_front_elevation 900100032_32_peel_road_kitchen 900100054_54_peel_road_front_elevation