Search results

I can but you won't have access to data in the tables since they are all link sql. Will that work?

Yes, that's were the code is in the on Format event of both the header and footer. See code but not working:confused: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.SPH_MEDTrustee.Value = 1 Then...

I did not set the visibility of the section but of the page break and subreport which was in fact your suggestion. But, I also changed the viability of the sections, page header and footer since they don't belong on the sub report. I used the code, I mentioned before but its not working. Do you...

Hi All, I took a completely different approach that worked. I added a page break and then a subreport. Then, I added logic to the on Format section to suppress the report if it was not one of our super donors. Works nice. But, a new issue has come out of it. Logically, the page header and...

While the value of the gift is part of the data there are many such flags and this is just one of them. So, while, I can just say something like GiftAmt >= 1,000,000, I just use the flag. Here is the case statement that selects the report to use for the current row: Case "Pledge"...

Hi Report Masters, I have a print button that works just fine when selected. It uses a case statement to select one of many reports that are appropriate. But, in some instances, I also want to print a second report that meets specific criteria like this person gives a gift for a million...

Hi CJ_London, I will be more descriptive the next time. Thanks!:)

Hi Report Masters, I have a case statement that selects a report to use based on a value in the table. This works fine but the DoCmd.OpenReport filter is not. The case statement in triggered by the on click event of the print button, I'm trying to filter on the current record on the form by...

Hi Mark, Just one follow-up on this matter. Can a similar filter be put on a form? In the case of the form a case statement will filter a set of reports based on the value in a column. So, for example if a row has a giftType = 'pledge' the pledge report would be used. See below: Select Case...

Hi Mark, I discovered what went wrong. I simple copied the code from the on load section which included Refresh code. So, as you know the detail band was redrawing it self over and over. Thanks for your assistance!:)

Hi Mark, This makes perfect sense. I also, put the same code into the on Current section and it did nothing. I did what you said and it worked fine with the exception that it is not changing for all the payment methods. I checking for spelling errors. But, there is another curious issue it now...

Hi Report Experts, I have a payment section(not a band) in the detail section that shows pay by Check, Cash, Wire, ect. Since, payment can be made by any of these methods and others, I have placed all the payment methods under a text box that reads "Payment Information". I have set the...

Here is the table structure and the code that opens the forms. There is nothing special about opening the form for editing. The form is just opened to a blank row for data entry. Private Sub btnTest_Click() Select Case [CboGiftType] Case "Pledge" Me.btnTest.Caption = Me.CboGiftType.Value...

Q - How are they launched? Answer - I have a combo box that has a VBA case statement to activate a button that in turn launches the form to collect the information needed. The fields on the pop-up form are simple columns from the same table that is the data source for the main form. As, I...

Pat, I added this code to the on click event of the button that launches the form: Forms!Donor_Intake_Form.Requery. It caused the cursor to move into the first field on the main form. So, I had to navigate back to where, I was but I still got another record inserted.:banghead:

Hi Pat, What exactly do, I do to as you said "to refresh the main form immediately"?

Hi Form experts, I have a relatively complex form based on one table. It organizes and collects data on the main form and on several forms that are launched from a combobox. The forms that are launched from the combobox have the same record source as the main form but simple focus on the...

Sorry, I was not clear but this is what, I had in mind. When a selection is made right before making any subform visable code is run to change the viability for whatever the current subform may be to false. So, in the case statement below where the case is "Check" something like ...

Hi Paul, Is there code like CurrentSubform Set Visable = False ? This way whatever is currently visable will be hidden before the case statement changes the selected subform to visable?

Hi All, I have a form that has a combobox to select many subforms below it. The on load event sets their visibility to False so they are hidden when the main form opens. But after selecting the first one with the code: Select Case [CboHowPay]...