Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Reports not Populating?

Discussion in 'Information Technology' started by Dennis, Oct 28, 2005.

  1. Dennis

    Dennis
    Expand Collapse
    Guest

    Access 2003

    Database has 200 records. Have compacted and repaired file multiple times.

    The Query "XX" works!
    The report based on "XX" appears to lock up or crash.
    "Formatting Page ....." the blue dots are full right
    The report used to work fine
    Must use Ctrl+Break to get out

    Any thoughts?

    Dennis
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Dennis

    Create a new report based on the query. Does it work?

    If so, throw out the old one... <g>

    --
    Regards

    Jeff Boyce
    <Office/Access MVP>

    "Dennis" <Dennis@discussions.microsoft.com> wrote in message
    news:EE7ECC3E-674A-4B85-A83D-BBC235B433F5@microsoft.com...
    > Access 2003
    >
    > Database has 200 records. Have compacted and repaired file multiple

    times.
    >
    > The Query "XX" works!
    > The report based on "XX" appears to lock up or crash.
    > "Formatting Page ....." the blue dots are full right
    > The report used to work fine
    > Must use Ctrl+Break to get out
    >
    > Any thoughts?
    >
    > Dennis
     
  4. Ofer

    Ofer
    Expand Collapse
    Guest

    I had this few times with forms, I decided that its better to build it again
    then try to figure out what is wrong with it, and it take less time.

    If you can open the report in design view, just copy and paste all the
    fields for the format.

    If you decide to try and figure out what is wrong with report, then check if
    you have code in it, on the open event, if you do, remove all the code to see
    if that is the cause of the problem.
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Dennis" wrote:

    > Access 2003
    >
    > Database has 200 records. Have compacted and repaired file multiple times.
    >
    > The Query "XX" works!
    > The report based on "XX" appears to lock up or crash.
    > "Formatting Page ....." the blue dots are full right
    > The report used to work fine
    > Must use Ctrl+Break to get out
    >
    > Any thoughts?
    >
    > Dennis
     
  5. Dennis

    Dennis
    Expand Collapse
    Guest

    Ofer,

    I really appreciate your thoughts.

    Being the "Why" person that I still attempting to determine what happened.

    That said a new report works.

    Can you be a bit more specific about the the smartest way or point-of-copy
    to start and then end the copy/paste procedure to transfer the greates abount
    of data and attributes?
    Meaning, I can get the fields and lables but not the
    Headers/Footers etc

    Thanks Dennis

    "Ofer" wrote:

    > I had this few times with forms, I decided that its better to build it again
    > then try to figure out what is wrong with it, and it take less time.
    >
    > If you can open the report in design view, just copy and paste all the
    > fields for the format.
    >
    > If you decide to try and figure out what is wrong with report, then check if
    > you have code in it, on the open event, if you do, remove all the code to see
    > if that is the cause of the problem.
    > --
    > If I answered your question, please mark it as an answer. That way, it will
    > stay saved for a longer time, so other can benifit from it.
    >
    > Good luck
    >
    >
    >
    > "Dennis" wrote:
    >
    > > Access 2003
    > >
    > > Database has 200 records. Have compacted and repaired file multiple times.
    > >
    > > The Query "XX" works!
    > > The report based on "XX" appears to lock up or crash.
    > > "Formatting Page ....." the blue dots are full right
    > > The report used to work fine
    > > Must use Ctrl+Break to get out
    > >
    > > Any thoughts?
    > >
    > > Dennis
     
  6. Ofer

    Ofer
    Expand Collapse
    Guest

    The idea is to eliminate parts of the report until you find the cause of the
    problem, can be one or more of four parts
    1. The record source of the report, which you checked by running the query
    seperatly
    2. The code under the form
    3. One or more of the fields, it could be that one of them call a function
    outside the report that cause the problem
    4. The report is curropted, in that case it better to build it again.
    To save time on building a new report. you can do the following
    4.1 Create a new report, empty
    4.2 Bound the report to the query
    4.3 Open the first report, select all the fields, copy and paste in the new
    report
    4.4 Run the new query, to see if you get an error, if you do, check the
    fields, if you don't move to the next stage
    4.5 copy each sub of the code, seperatly and insert into the new report.

    If all the above doesnt work, then use the wizard and build a new report
    based on the query.
    One more thing, check if the ldb still exist when you close the mdb, if it
    does delete it and try and run compact and repair again
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Dennis" wrote:

    > Ofer,
    >
    > I really appreciate your thoughts.
    >
    > Being the "Why" person that I still attempting to determine what happened.
    >
    > That said a new report works.
    >
    > Can you be a bit more specific about the the smartest way or point-of-copy
    > to start and then end the copy/paste procedure to transfer the greates abount
    > of data and attributes?
    > Meaning, I can get the fields and lables but not the
    > Headers/Footers etc
    >
    > Thanks Dennis
    >
    > "Ofer" wrote:
    >
    > > I had this few times with forms, I decided that its better to build it again
    > > then try to figure out what is wrong with it, and it take less time.
    > >
    > > If you can open the report in design view, just copy and paste all the
    > > fields for the format.
    > >
    > > If you decide to try and figure out what is wrong with report, then check if
    > > you have code in it, on the open event, if you do, remove all the code to see
    > > if that is the cause of the problem.
    > > --
    > > If I answered your question, please mark it as an answer. That way, it will
    > > stay saved for a longer time, so other can benifit from it.
    > >
    > > Good luck
    > >
    > >
    > >
    > > "Dennis" wrote:
    > >
    > > > Access 2003
    > > >
    > > > Database has 200 records. Have compacted and repaired file multiple times.
    > > >
    > > > The Query "XX" works!
    > > > The report based on "XX" appears to lock up or crash.
    > > > "Formatting Page ....." the blue dots are full right
    > > > The report used to work fine
    > > > Must use Ctrl+Break to get out
    > > >
    > > > Any thoughts?
    > > >
    > > > Dennis
     
  7. Dennis

    Dennis
    Expand Collapse
    Guest

    Excellent Oger!!

    Thanks

    "Ofer" wrote:

    > The idea is to eliminate parts of the report until you find the cause of the
    > problem, can be one or more of four parts
    > 1. The record source of the report, which you checked by running the query
    > seperatly
    > 2. The code under the form
    > 3. One or more of the fields, it could be that one of them call a function
    > outside the report that cause the problem
    > 4. The report is curropted, in that case it better to build it again.
    > To save time on building a new report. you can do the following
    > 4.1 Create a new report, empty
    > 4.2 Bound the report to the query
    > 4.3 Open the first report, select all the fields, copy and paste in the new
    > report
    > 4.4 Run the new query, to see if you get an error, if you do, check the
    > fields, if you don't move to the next stage
    > 4.5 copy each sub of the code, seperatly and insert into the new report.
    >
    > If all the above doesnt work, then use the wizard and build a new report
    > based on the query.
    > One more thing, check if the ldb still exist when you close the mdb, if it
    > does delete it and try and run compact and repair again
    > --
    > If I answered your question, please mark it as an answer. That way, it will
    > stay saved for a longer time, so other can benifit from it.
    >
    > Good luck
    >
    >
    >
    > "Dennis" wrote:
    >
    > > Ofer,
    > >
    > > I really appreciate your thoughts.
    > >
    > > Being the "Why" person that I still attempting to determine what happened.
    > >
    > > That said a new report works.
    > >
    > > Can you be a bit more specific about the the smartest way or point-of-copy
    > > to start and then end the copy/paste procedure to transfer the greates abount
    > > of data and attributes?
    > > Meaning, I can get the fields and lables but not the
    > > Headers/Footers etc
    > >
    > > Thanks Dennis
    > >
    > > "Ofer" wrote:
    > >
    > > > I had this few times with forms, I decided that its better to build it again
    > > > then try to figure out what is wrong with it, and it take less time.
    > > >
    > > > If you can open the report in design view, just copy and paste all the
    > > > fields for the format.
    > > >
    > > > If you decide to try and figure out what is wrong with report, then check if
    > > > you have code in it, on the open event, if you do, remove all the code to see
    > > > if that is the cause of the problem.
    > > > --
    > > > If I answered your question, please mark it as an answer. That way, it will
    > > > stay saved for a longer time, so other can benifit from it.
    > > >
    > > > Good luck
    > > >
    > > >
    > > >
    > > > "Dennis" wrote:
    > > >
    > > > > Access 2003
    > > > >
    > > > > Database has 200 records. Have compacted and repaired file multiple times.
    > > > >
    > > > > The Query "XX" works!
    > > > > The report based on "XX" appears to lock up or crash.
    > > > > "Formatting Page ....." the blue dots are full right
    > > > > The report used to work fine
    > > > > Must use Ctrl+Break to get out
    > > > >
    > > > > Any thoughts?
    > > > >
    > > > > Dennis
     

Share This Page