Consulting

Results 1 to 12 of 12

Thread: "No Current Record" - Creating Report

  1. #1
    VBAX Tutor phendrena's Avatar
    Joined
    Oct 2008
    Location
    Huddersfield, UK
    Posts
    285
    Location

    "No Current Record" - Creating Report

    Hi There,

    I'm trying to create a report in Access based on a Table (using one of the wizards) , however, when i get to the end and click finish i get a message box thats says "No Current Record" when i then click OK i get a blank message box and then after clicking i get nothing.

    Am i doing something wrong?

    Thanks,
    Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
    Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
    But thats nothing compared to the horrors that lurk beneath The Trap Door.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    I never base Reports on the Table directly. I always create one or more Queries to base them on. In that way you can check what data you are going to get before trying to create the Report.
    What Table/Report are we talking about?

  3. #3
    VBAX Tutor phendrena's Avatar
    Joined
    Oct 2008
    Location
    Huddersfield, UK
    Posts
    285
    Location
    I'm exceedingly new to access so bear with me....
    I'm adding the report based on the table InboundData.
    I do have some queries setup and i can create charts but not reports.

    I have tried to add a report based on a query but alas i have the same problem.
    Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
    Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
    But thats nothing compared to the horrors that lurk beneath The Trap Door.

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    Do the Queries return Values and records?

  5. #5
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    What data do you want to make the report on, the 2 queries or something in the Table?
    I notice that you are using Access 97, I think to create a Report on a Crosstab Query in 97 you have to use a Crosstab Report.

  6. #6
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    I have created 2 reports based on your 2 Queries.

  7. #7
    VBAX Mentor
    Joined
    Aug 2008
    Posts
    323
    Location
    Well as said it is always a better idead to have queries as a record source for the report.. and the two queries that you have created do return values.... so it yuo sholdnt be having any problem..

    are you bounding the textboxes to fileds in query.. if you dont you will get a blank page.. try to upload a report that you have tried to create and that is causing problem.. we might be able to help you with that
    I am a Newbie, soon to be a Guru

  8. #8
    VBAX Tutor phendrena's Avatar
    Joined
    Oct 2008
    Location
    Huddersfield, UK
    Posts
    285
    Location
    Quote Originally Posted by OBP
    I have created 2 reports based on your 2 Queries.
    Intersting, did you create those reports using the wizards or directly through the design view? I appear to be able to create some reports uisng design view, but using the wizards i have no success.

    Thanks,
    Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
    Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
    But thats nothing compared to the horrors that lurk beneath The Trap Door.

  9. #9
    VBAX Tutor phendrena's Avatar
    Joined
    Oct 2008
    Location
    Huddersfield, UK
    Posts
    285
    Location
    Quote Originally Posted by OBP
    What data do you want to make the report on, the 2 queries or something in the Table?
    I notice that you are using Access 97, I think to create a Report on a Crosstab Query in 97 you have to use a Crosstab Report.
    A report that i would specifically need is one that shows the total amount of calls per reason and also one per scheme based on the current week and then the same again as a total for the month. I've been fiddling with designing reports but unsure how i would do this?

    Any suggestions?

    Thanks,
    Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
    Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
    But thats nothing compared to the horrors that lurk beneath The Trap Door.

  10. #10
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    I created the Reports using the Report Wizard, I would suggest that you try "Reparing" MS Office or Access to see if that fixes the wizard.

    The queries can easily handle Calls per Reason or per scheme.
    If you want me to create them for you I am quite happy to.

  11. #11
    VBAX Tutor phendrena's Avatar
    Joined
    Oct 2008
    Location
    Huddersfield, UK
    Posts
    285
    Location
    Quote Originally Posted by OBP
    I created the Reports using the Report Wizard, I would suggest that you try "Reparing" MS Office or Access to see if that fixes the wizard.

    The queries can easily handle Calls per Reason or per scheme.
    If you want me to create them for you I am quite happy to.
    Unfortunetly I don't have the option of repairing the install as i'm on a rather restrictive company setup. If you could create the reports that would be great. Would you also be able to provide pointers on how you set these reports up please, as i wouldn't know where to start producing a reports that breaks data down between specific dates and months.

    Thanks,
    Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
    Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
    But thats nothing compared to the horrors that lurk beneath The Trap Door.

  12. #12
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    Do you have the MS Office Install Disc?
    That is what you use in combination with the Windows Control Panel "Programs".
    I will create you a coupe of queries when I have a little time.

Posting Permissions

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