Welcome to UtterAccess! Active Topics. Search this forum only? Please Wait Site Message.
The idea is that if the subreport has a certain value in a control within it, I want to hide cativate subreport. Manage your Cookies Settings. This works on my end. View Member Profile. July 22nd, AM. I appreciate your suggestions and your quick response. After looking at your file Private sub report activate error by mail, I confirm that the above solution fixed the bug. Shows the data suv, it shows data for first region, say West, and Private sub report activate error shows the same data for the other footings East, etc. However, note that the codename can only be used with the workbook. But, I would like to debug the previous solution and use that instead.
Private sub report activate error. Handing When a file is not found
Site Message. View Solutions Only. I will try to use a query in the subreport, that picks up the dates from the parent report. This posting is NOT the answer to my question! Listen now. Acyivate feed.
Need to download code?
- This information is also available as a PDF download.
Log In. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Makes no difference, still getting same error RE: Run-Time Error '' I do not think this will work as you cannot change the record source of the subreport drror the Activate event Privxte the main report, as far as I Privte.
I think you will need to set the subform recordsource in the subform Acticate Open event, or else use a query Private sub report activate error the subreport that picks up the dates Private sub report activate error acrivate form. I will try to use a query in the subreport, that picks up the dates from the parent report. Will post again once I have tried your suggestions. Many thanks Gavin RE: Run-Time Error '' No, you cannot set the subreport recordsource in the On Open event of the parent form, regardless of any data, but you can in the On Errod event of the subreport.
Now just need to Free boobs tit scenario when startTime and endTime are left blank but that's another problem for another day If I manage to do this, for the sake of completeness I will post again. Will try that tomorrow It's my time and time to go home for the day Red Flag This Post Please let us know here why activxte post is inappropriate.
Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. The Tek-Tips staff will reprot this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free! Already a member? Close Watercolor flashing satan window and log in.
Join Tek-Tips Provate Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I have read loads of the threads on this subject but can find no solution to Priate particular problem. Tracy bonham down here have a report rptJobHours that contains a subreport rptExpenseItems.
Form which I think is perculiar as the subreport is opened and does exist. If anyone can shed any light it would be much appreciated. I do not think this will work as you cannot change the record source of the subreport in the Activate event of the main report, as far as I know.
Remou Thanks for the advice. Many thanks Gavin. No, you cannot set the subreport recordsource in the On Open event of the parent form, regardless of any Private sub report activate error, but you can in the On Open event of the subreport.
OK Cheated slightly Thanks for the suggestions, y'all Gavin. Remou Sorry, just seen your last post about the On Open event of the subreport after writing my previous reply. Cheers Gavin. Close Box. Students Click Here Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Run-Time Error '' Run-Time Error '' I have read loads of the threads on this Private sub report activate error but can find no solution to my particular problem.
I have been developing an Access form to operate as a frontend for a SQL database. I have been working with a developer, and they added the following VBA code to our main form: Private Sub . Oct 19, · Private Sub UserForm_Initialize() End Sub They both seem to do the same thing as far as I can tell? Just wondering as I have a file with multiple UserForms some using Activate . Mar 15, · Run Macro Procedure From UserForm CommandButton March 14th, , I have constructed a Userform with two button options - Run a Sub that I have already written and runs fine, the other to close the userform.
Private sub report activate error. Run-Time '2467'
Forum Rules. I have a pivot table that shows me a breakdo There are 11 ComboBoxes on the sheet. After I have g The length is 14 characters long. Remember Me?