Recent content by rowardHoark

Once the subreport is opened independently, conditional formatting works great. Correct data lights up in green and false in red. However, when the whole report is opened, subreport included, conditional formatting works only for controls in the main report. In subreport controls, the numbers...

The error is caused by a function which displays the value in a text box. I have tried to change data types, CLng() and Round(..,1) with no success. Also, the error occurs only in some records (displayed as reports). The code of the function: Public Function...

Thank you rodmc, using a query is an elegant solution. Had some trouble summing all the data for a particular report, but this link helped http://www.access-programmers.co.uk/forums/showthread.php?t=204103.

My query "ArrheniusPlot" looks like Report_number...Temperature...Time 1.....................130...............600 1.....................120...............2000 1.....................110...............3200 1.....................100...............4600 2.....................150...............1100...

A good workaround. Thank you, vbaInet!

Problem occurs when: Open "report" in design view. Create a subreport, based on "t_grandparents" within a subreport.

Tried to create a new database on a different computer. Again, as I click the finish button on the nested subreport wizard - the software crashes. Update: Tried it on several co-worker machines. All have 2003 version and all crash when a nested subreport is created.

If I drop a control on the report and click the save button, nothing happens - Access doesn't crash. I have also tried to create a brand new database: 3 tables, all linked with one to many. I can create a report, a subreport, but once I finish the nested subreport wizard, Access crashes...

The problem only occurs with reports. Nested subforms, using information from the same tables work fine. Other people have reported identical problems online, but no solutions were found. The only resource with some information was: However the suggestion doesn't help. I still receive the...

Thank you DCrake! CanShrink property seems to be the thing I was looking for.

Ok, let's say I filter out a particular empty test (toggle off) from the record source. How do I then display the tests conducted (toggle on)? Write a VBA to create text boxes for results of those tests?

My report needs to display test results. Different reports have different tests conducted. Initially I was thinking of using text boxes with visibility based on/off test selected. XXXXXXXXXXXXXX (test 1 selected) XXXXXXXXXXXXXX (test 2 selected) XXXXXXXXXXXXXX (test 3 selected)...

I open the tab form "f_manage_tests" after having made a selection in "f_select_tests" and closing it. When both forms are open, the code does work. forms("f_test_management").Controls("testManagemen tTab").Pages("waterAbsor btionTab").visible =...

When I execute the code I get: Since the tabs are in a form (f_test_management) different to that where buttons are located (f_select_tests), shouldn't I focus on f_select_tests first?

I have a form f_select_tests, where I select tests to be conducted using toggle buttons. Each test has a corresponding tab in a form called f_manage_tests. All tabs are default hidden. Depending on the tests selected I want corresponding tabs to become visible. Currently this code for...