Search results

Hi all, I have a report with a sub-report in the OrderID footer. The page header is printing on all the pages in the report, however, I need to be able to turn off the page header if the page has the sub-report, as the sub-report has it's own page header with different values. My pseudo code...

Hi Dave, I'm fairly suire the code is OK as I've been using it a long time on a number of databases, I'm just not sure why it's causing one particular PC to crash any time it's called. For manageability, my users are only ever in one active group, 'Users' being a disabled group. Thanks for...

Hi all, Using Access 2007 on Windows 7 machine. Every time I make a call to the following function Access crashes. Does this mean I need to re- register the MS ADO Ext 2.8 for DDL & Security dll on the machine? or is the problem elsewhere? This seems to run fine on other PCs with the same...

Doh!, thanks a lot Bob...must be really losing it.:confused: Regards Melt

Hi Bob, I've tried all three events, Open, Load and Activate, they all return the same error, yet I can see the value on my report. Regards Melt

Hi all, Ona report, I have a column in a query called 'ReportLineNums'. I've dropped the column onto the report and the value is being printed to the report. However, I can't seem to reference the value in the control. I keep getting an "You entered an expression that has no value...

Thanks vbaInet, great explanation, got it sorted based on your instructions, much appreciated. Regards Melt

Hi all, I have a report and there is a grouping on the report called 'Options'. The report prints something like this: Option 1 - Line Item 1 - Line Item 2 - Line Item 3 -(Show number here) Option 2 - Line Item 1 - Line Item 2 - Line Item 3 - Line Item 4 -...

Hi Simon, it's Padding I want. Any ideas? Regards Melt

Hi all, In Access 2007 does anyone know how to use the Padding properties through code? I have two textboxes and I have them "Stacked" on a report, I can add padding through the properties box, but not through code, why is that? Me!Textbox1.BottomPadding = 2 Also, can you reference the...

Hi vbaInet, The example I gave above is just one of dozens that crop up on these reports, so I'm afraid any hard-coded solution in relation to moving controls or altering heights will not work. The details on every report are custom created, every report is unique, so showing one report would...

Hi vbaInet, Thanks, but that won't work as it's just pushing a whole section or group forwards, leaving rivers of white space. Let me give you an example of the problem I'm trying to solve on the sub-report. "The sub has 20 line-items with sub-totals and totals on the page. Even when Keep...

Hi vbaInet, Yes, I've tried changing the visibility of the page-break on the sub-report, Access just ignores it, it only work on a main report. I need to be able to break my sub-report based on my Counter number. The Access properties (Grouping, Keep Together etc ) are not giving me what the...

Using Access 2007 Hi all, I've just found out that page breaks don't work on sub-reports, has anyone ever figured out a work-around solution to this problem? I have a Counter on the details section of a sub-report and I need the page to break at a certain number. Regards Melt

Cheers, thanks folks. Regards Melt

Hi all, What are all the gridlines and padding properties on a command button supposed to do? I've set a number of these and I don't see any effect on the button? Regards Melt

Hi David, It won't be possible for me to give you an explanation that makes any sense, as to where the page is breaking. It's a master-report with three embedded sub-reports with many variables. I've tested my theory by manually altering the font-size on a few reports and it does help as the...

Hi all, I'm having a problem on a complex report where the page is breaking in an inappropriate place. I've tried all the options 'can grow/shrink', 'keep together' etc and the problem is still occuring. I was thinking of giving the user an option to change the font-size of the text on the...

Thanks for posting the solution chrisvt, just dealing with the exact same problem myself.:) Regards Melt

Thanks for the replies guys, problem sorted. Regards Melt