Search results

I have the sub reports in the detail band should they be moved into a different band of the report that can resolve this?

The sub report only has a detail band so what would be suppressed?

The main report should always have the page header and footer. When the page break starts a new page and the sub report prints it should not have either page/footer that appear on the main report.

Just to make sure that I'm not making a stupid blunder, the code to suppress goes in the main report's header and footer on format section and not in the same section of the sub report correct? :eek:

Just tried it with no change.

Hi Report Masters, I have a report that appropriately prints its headers and footers for the main report. But, I also have Page Breaks controls in this report with sub reports that I don't want to have the page header or footer of the main report printed on. To suppress the header/footers, I...

I'm changing to a char field as you suggested. I have changed description to EpistleDescription and EpistleStatus which should not be reserve words. And as they indicate show whether a letter is complete or not. So, EpistleDescription has two rows Complete, Incomplete. EpistleStatus has 1. This...

I can't implement 'All' in a combo box control. I set up a field in my table called 'complete' its data type is bit and my database is mssql 2008 R2. I set the default value to zero (0). On the Access side, I made a table called tblComplete with three columns. The first is Description {All...

I tried this but it gave me an error msg: Me.FrameGiftAlloc = Me.OptionGA What do, I have to change?

Form Masters, This may be simple but can't find solution. What, I want to do is not only select a radio button from a set but also have the dot that is in the center of the radio button display that I have selected it. So, my code is: Me.OptionGA.SetFocus This works fine the object shows a...

Uncle Gizmo, Nice video UG but what if you have dozens of controls of all sorts on a form how do you loop through a set of 10?

Yes, Moke's code has resolved it.

Uncle Gizmo, To answer your questions, I want the 'check' in the textbox to turn off if the corresponding textbox above it is empty. So the code Nz(Len(Me.txtWriter.Value)) > 1 checks to see if the string is greater than one and if it is the check is turned on otherwise it stays off. As, I...

Hi Form Masters, I have several unbound text boxes that I have placed underneath several other textboxes. The ones underneath have the code ChrW("&H2714") which is the symbol for a check Mark as there Default Value. They all have there Visible method set to False (so they are invisible). The...

I should also mention that the new record button on the record selector is grayed out.

Here is the script for both tables. SELECTTOP (1000) [StrategyID] ,[UpNumFK] ,[StrategyAssignment] ,[StrategyNote] ,[StrategyDate] ,[StrategyStatus] FROM [Med].[dbo].[CPM_Assignments] ----------------------------------- USE [Med] GO SETANSI_NULLSON GO SETQUOTED_IDENTIFIERON GO CREATETABLE...

Hi Form Masters, I have a form that I inherited that has repeating columns in the tables. I was asked to add three (3) more repeating columns called Assignments 1 to 3 and now the additions 4 to 6. This should clearly go into a separate table where the user can add as many as needed. On the...

Super everything is now working!:D

.Execute dbFailOnError is the line that caused the error and I did update the connection string.

Error is now gone but have new one. Run-Time error 3420 Object invalid or no longer set.