Page 1 of 3 123 LastLast
Results 1 to 15 of 31
  1. #1
    Join Date
    Jun 2008
    Posts
    59

    Unanswered: report printing score cards

    i have had trouble logging on to db forums,so hope i am not duplicating thread
    i have 2 tables one contains all members and table 2 has members selected to play.all this is working fine
    i then created a form to place those selected into teams (up to 28 teams playing on 14 rinks my problem is how to go about creating a report to print out score cards for each team.the players each have an individual tag No.I know I should not create more tables for each rink.perhaps someone can steer me in the right direction
    many thanks dennis

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Can we see the structure of your database?

    Sounds like you might need a table design adjustment.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2008
    Posts
    59

    score cards in reports

    Quote Originally Posted by StarTrekker
    Can we see the structure of your database?

    Sounds like you might need a table design adjustment.
    very happy to send structure! how do i do it and in what format
    tks dennis

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Easiest way is to print-screen the complete relationships window, save as jpg and upload the picture.

    You could also just zip and upload your db if you think that's going to be easier.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jun 2008
    Posts
    59
    Quote Originally Posted by StarTrekker
    Easiest way is to print-screen the complete relationships window, save as jpg and upload the picture.

    You could also just zip and upload your db if you think that's going to be easier.

    sorry ST I can print screen the relationship window and save in word but cannot save as in jpg?

    i can upload DB but it is 25mb too big for forum can i email it to you by :yousendit"?

    i know the DB is not written correctly and objects are not named i intend to go back and redo the whole DB as it should be done once i get the reports section done
    tks again for your patience rgds dennis

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    compact and repair the db
    then zip it
    then add it to a post as an attachment
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Jun 2008
    Posts
    59

    score cards in reports

    tks healdem but the zipped file is 13.6mb too big for attachment

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    did you compact and repair it first?

    failing that make a copy of the MDB
    then open tht copy in Access remove all irrelevant objects (ie forms, reports, tables etc which are not germane to the problem)
    then compact and repair it
    then zip it
    then attach it
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Jun 2008
    Posts
    59
    Quote Originally Posted by StarTrekker
    Easiest way is to print-screen the complete relationships window, save as jpg and upload the picture.

    You could also just zip and upload your db if you think that's going to be easier.

    i am uploading relationship window?i hope that will help?

    i will also upload reduced version of the DB in case that also helps
    many thanks dennis

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by dennis 2756
    sorry ST I can print screen the relationship window and save in word but cannot save as in jpg?
    Ok, so do that, save the word document, zip it and then upload the .zip.

    To get it to a JPG, you would just paste it in a graphics editor, like Paint, then save it as a JPG.

    Sorry for any confusion
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Jun 2008
    Posts
    59

    print score cards

    Quote Originally Posted by StarTrekker
    Ok, so do that, save the word document, zip it and then upload the .zip.

    To get it to a JPG, you would just paste it in a graphics editor, like Paint, then save it as a JPG.

    Sorry for any confusion
    tks st i have saved as a jpg,and uploaded it to you.
    i actually send it the other day but i cannot see how you check what has been sent in the forums,am i missing something?
    rgds dennis
    Attached Files Attached Files

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ummm.... sorry Dennis, but I don't know where to start. Your tables are a mess to say the least.

    i know the DB is not written correctly and objects are not named i intend to go back and redo the whole DB as it should be done once i get the reports section done
    That's good... but I think you're going about it the wrong way. FIRST write the database correctly, then you'll find your reporting solution will be simple. As it stands, I have no idea how to produce the reports you want.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    Jun 2008
    Posts
    59
    tks tk i accept yor critisism.i will start again after reading more about access
    appreciate your help to this stage
    regards dennis

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I can offer you tips and I am working on a basic level access trainer that might help... if I ever complete it.

    Here's a tip: you should never need to have tables numbered... like a table called Customer1 and Customer2 etc. Nor should you need fields numbered like NextOfKin1 and NextOfKin2.

    I couldn't even tell what your table names were because the tables in the relationship window were too narrow and the names were hiding. I also couldn't tell by field content because again, the tables in the relationship window were too shallow, hiding the fields.

    If you correct that, I can give you some more tips towards the right design
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  15. #15
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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