Page 2 of 2 FirstFirst 12
Results 16 to 26 of 26
  1. #16
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Put a break at the beginning of the code (in the subreport) and open the main report and see if it stops there, I suspect is doesn't.


    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  2. #17
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    done, i put a break on "report_open" and stops on that part, when i click on F5 the main form opens without that rubreport

  3. #18
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Why put the break on Open when you said you moved the code to the Load event of the subreport (is a subreport and not a subform, right?)? You want to see if the event (of the subreport) fires when you open the main report in Report view. But I would stick with using the Format event of the subreport's Detail section (Corpo).

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #19
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    you're right.
    i'll make some tests but enough of suggestion, thanks!

  5. #20
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    hi vlad, sorry for necroposting but i have brilliantly - thanks to you - solved the first problem.

    now, the problem is that my "ProfiloPB" report works fine both in report than print preview but, when i export it, i have some missing subreport ONLY if i insert the subreport called "Report-Analisi portafoglio trasferibile".

    if i delete this subreport from the report i got no problem.
    I'm struggling form the morning with this problem
    Attached Files Attached Files

  6. #21
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    found the problem, the charts.

  7. #22
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Quote Originally Posted by diegomarino View Post
    found the problem, the charts.
    Hi Diego,
    Glad to hear, I was away from a computer all day and was just going to look at it .
    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #23
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    don't worry, you can still help me!!
    i said i found the problem, not solved the problem

    the charts in subreport "Report-Analisi portafoglio trasferibile" are good in report view and print preview, but screw up everything when i export the main report!

  9. #24
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Diego, looks like you uploaded the older version, I cannot find the subreport with the charts in the file from post #20.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  10. #25
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    maybe i messed up. this is the good one


    i think i found the problem. I can't set chart rowsource through vba, i have to set the rowsource in the property pane of the chart object. weird

    actually, i'm not sure about that too, cause the problem came back once.

    EDIT: i solved changing procedure, now i have 4 query that i change using querydef.sql and setting the rowsource of charts to that queries.

    don't ask me why but now it's working, that's enough for me.
    thanks for the help and ....nice dog
    Attached Files Attached Files
    Last edited by diegomarino; 03-29-2021 at 03:37 AM.

  11. #26
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Hi Diego,

    Glad to hear, sorry I just got home from a short camping trip.
    And thanks for mentioning my puppy, he even had an Italian name (Caro).

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sub report not showing data on pdf export
    By diegomarino in forum Access
    Replies: 4
    Last Post: 09-04-2020, 01:51 AM
  2. Replies: 1
    Last Post: 01-23-2019, 01:55 PM
  3. Replies: 9
    Last Post: 08-08-2016, 02:57 PM
  4. Replies: 1
    Last Post: 07-21-2014, 04:06 PM
  5. Replies: 15
    Last Post: 04-16-2014, 01:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums