Search results

  1. J

    Printing issue

    Hi, When I print a report from Access, it prints fine. When a colleague does it to the same printer, it misses out lots of letters. Another colleague does it, and it prints fine. The font is standard (Calibri). My IT dept. say it isn't the printers fault. Is it something wrong with my report...
  2. J

    What do i need to change to stop crashing?

    Hi David, That works brilliantly for me, thank you for your time and help. This will also help me with future reports! Thanks again, Jim
  3. J

    What do i need to change to stop crashing?

    Hi Gemma, the error it returns is "Run time error '2501'. The OutputTo Action was cancelled." Hi David, sometimes the user chooses the wrong option from the combobox on the "RegionCode Dialog Box" Form and then cancels the "output to" box, which causes it to crash. So I would choose the...
  4. J

    What do i need to change to stop crashing?

    Hi, The code below is working well, it opens an Excel spreadsheet version of the query I want to run and it saves fine. However, if I click "cancel" instead of choosing to save the spreadsheet, Access crashes out. Any ideas what I need to change please? Thank, Jim (p.s., not sure if you need...
  5. J

    How to run a report while just entering parameters once?

    Hi vbaInet, Thank you very much for this, its nearly complete! Actually, i see what you've done, you've added the parts of the reports not showing to the master report. Out of interest, can i then delete the sub reports or are they still needed? Thanks again. Jim
  6. J

    How to run a report while just entering parameters once?

    Thank you...and sorry for causing frustration. It's just weird it's not showing those reports.
  7. J

    How to run a report while just entering parameters once?

    Hi VbaInet, there is nothing in the Child/Master fields. The reports individually all run fine, as do the queries. For some reason it won't show the 3 reports above in the final doc. Very strange. It doesn't show in the version you did for me yesterday either.
  8. J

    How to run a report while just entering parameters once?

    Hi vbaInet. Thanks for your help again. R.E. "if any of the subreports isn't showing any data it's simply because that ClientID is not returning any records in the query.", if you look at the print preview, its not bringing through the "qry_on-attend" report, the "qry_cancellations" report or...
  9. J

    How to run a report while just entering parameters once?

    Right, I've restarted from the version that you did. Amended the criteria in each query to match what you did. It works again but when I go to print preview, 2 of the subreprots aren't showing. Which was the original problem earlier on.
  10. J

    How to run a report while just entering parameters once?

    Some of the lines/boxes on the subreports were not neatly aligned so I just moved those around. They didn't update on the final report, just in the separate reports. There wasn't anything major done. As to why it has started printing many times again, no idea.
  11. J

    How to run a report while just entering parameters once?

    Nor do I! Odd its repeating the report over and over again.
  12. J

    How to run a report while just entering parameters once?

    and now, when I click print, it sends 2500 pages to the printer (in print preview, it seems to be looping, once it gets to the last page of the report it repeats the report again and again for the same ClientID). It wasn't doing that before! Jaim
  13. J

    How to run a report while just entering parameters once?

    Hello! I've managed to fix this myself. The only problem I'm having now is I've tidied up all the reports that make the subreports in the final report (I ensured boxes are lined up, fonts are correct etc.) However when I run the report, it doesn't show the changes I've made. Is there a way...
  14. J

    How to run a report while just entering parameters once?

    I'll check in the morning and report back. Looking at how the other reports on their have been set up, there is quite a bit of code in the background. I've tried to copy and change the parts that are relevant to the command but no luck yet. Thanks again and for being patient with me. Jim
  15. J

    How to run a report while just entering parameters once?

    The report loads and has data when I run it from the development side. When I upload the database to the server, the split database (the one with just the reports available to the user), the report does not open at all. I don't make any amendments to the split one, it does it automatically once...
  16. J

    How to run a report while just entering parameters once?

    Hi vbaInet, This is all set up and on the development database, works a treat. I've just tested it on the server where the users get the split version of the database and it doesn't show the report when I click preview? This works on my side though. J
  17. J

    Hi VbaInet! Thank you for the work and patience you gave when sorting out that training report...

    Hi VbaInet! Thank you for the work and patience you gave when sorting out that training report. I've uploaded it to our report section and it works a dream! Jim
  18. J

    How to run a report while just entering parameters once?

    The join line that defines relationships between 2 tables...I thought I had issues!
  19. J

    How to run a report while just entering parameters once?

    My colleague said they knew what they were doing! When they asked me "what is that line between the 2 tables in a query" I decided he wasn't much better than me! :)
  20. J

    How to run a report while just entering parameters once?

    Ah ok. my colleague said that would work so that is what they set up. Since my colleague is now off for 9 months the company has agreed I can go on an Access training course, starting next week so I will improve on my pretty weak Access skills.
Top Bottom