Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: @#$#!! subreports!!!

    What's wrong with these things, my data's fine but I spend hours trying to make the stupid thing visible and say (somehow) that it has no data. There should be a property or method (and hasdata and nodata event do not work) that does this simply!AAAAAAARRRRRRRRGGGGGGHHHHHHHHH!!!!!!!!!!!!! !!!

    Thanks,

    Troy.

  2. #2
    Join Date
    Feb 2004
    Posts
    199
    Take it easy
    things aren't as easy as seems, easy to say, but not to do!
    things that make you angry, make others happy
    Actually access have many bugs but in this case there is no Access problem, believe me there is no Access problem, you just need to find a way out, for example try to use UNION or some other way to get extra line when the rowset has no data
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

  3. #3
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    Chill and Debug it.

    Take a copy of your report and a copy of your tables (table/subtable). Reduce the tables to 1 row each with matching primart->foreign keys, then take a look at your copied report. If the report shows what you expect, it's something in your data, if not, there's something in your report. I'm assuming the table design is there.

    I read your part about your data being fine, and Access will sometimes make unknown errors. I haven't seen it make errors on accessing no data.
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •