Search results

  1. G

    Reports problem

    Just to add a little more to that, you may also wish to change the value in the 'keep together' option to whole group. This will mean that if a group begins half way down the page but goes over to the next, the whole group will be forced to the next page. However, if an ID group is small...
  2. G

    linking reports

    A little more information about how your course codes are set up may help but your post suggests that you have a single course code and within that code three levels can be chosen. So long as the level is stored in a table somewhere, it sounds as though you should have a group on course code...
  3. G

    Crystal Reports

    I personally find that there isn't a great deal of difference in the two so far as building reports goes. Although, the formatting can be slightly better in Crystal - oh yes, and the graphs work:rolleyes: Also, crystal reports can be shared without the need for the other user(s) to have ACCESS...
  4. G

    Page Numbers on Reports with Subreports

    Hi, Apologies for dragging this out of the archives, but I have just been attempting to do this on a report to no avail. I have been attempting it on a report WITHOUT a sub report though, so maybe I'm barking up the wrong tree here. I think that the bit that is causing me problems is where...
  5. G

    Updating values when report closes

    I have recently built something similar to this on a form. I did it by creating an update query that alters *ALL* flags in the table back to False. (In a Yes/No field). Then I built a macro that simly ran the update query. On my form I placed the Macro Name in the OnClick event procedure and...
  6. G

    Embarassing

    To print only the record that the user is viewing I generally do the following. As Hayley points out it can be easier to run a report to do this so I would build a query that emulates what you are showing using your form/subforms, then build the report from that query. I would assume that the...
  7. G

    Force a new page in a report

    In sorting and grouping properties for your group alter the Keep Together option to Whole Group. If that group goes over the page, then it will force that section onto the following page.
  8. G

    Avoiding multiple pages in a report

    Using Sorting and Grouping, add a group that identifies your person, and then in the 'details' section include the 'day' fields. Should look something like this: {Group Header} Bloggs {Detail} Sat + Other fields Sun + Other Fields
  9. G

    Is it possible to use Mail Merge inside Access?

    This may not be the ideal way to do this, but I have done the following when wanting to send a standard letter to people in the database. Create a report grouped on Person Code (or whatever you use as the unique identifier) and place the name and address details in the header for the group. In...
  10. G

    Sorting Report Details

    If my understanding of your question is right you wish to make the second sort the primary sort. This can be done by hovering your mouse just to the left of the sort line until the pointer turns into the black arrow. Left click highlights the line, then this can be dragged and dropped to where...
  11. G

    I have a report Question, help appreciated

    I always do it in the following way, although there may be easier ways... Place a text box into the report and type your paragraph thus: ='this is a paragraph of text containing the field'&' '&([fieldname]) That should do it.
Back
Top Bottom