Search results

Are you using different printers on the different workstations? I have had this problem where, on printing the report, Access resizes the margins apparently based on information it receives from the printer driver. If this is the case, I think you would have to split the database, whatever the...

The simplest way is to put some code in to the On Format event in the detail section using a static variable which you add values to (?) from a (hidden) control in the report. Obviously there would have to be some way of telling on which records to reset to zero etc. You may also have problems...

In answer to your second question, use a form to input the date(s)and have the query on which the report is based take a runtime parameter from that form eg the Where condition is [Form]![MyForm]![Date]. I'm afraid I cannot think of any easy answer to your first question - if you have four...

I think that you've got in to the wrong section (Reports) but the simplest way is to use a combo box populated either from a table or in the row source and set Autoexpand to Yes

I am sure there is a very simple solution to this but I cannot see how to set the size of the window that opens in preview or design. I thought you could open a report in preview, resize the window and save it but for some reason one particular report reverts every time to an irritatingly tiny...

Thanks for the reply,llkhoutx. However if you had bothered to read my original query, you would see that it is not the New Record button which is the trouble but the fact that I cannot stop the navigation buttons going to the blank record at the end of the table.

I am not sure whether this is a table or a form query so I am posting it under both. I have a form which is used to amend, delete and create new records. However, when a new record is created, information which is not editable by the user is added from a number of different tables, system date...

Can anyone show me how to reference the AbsolutePosition property of the record being formatted at the On Format event in the detail section of a report? Iwould be very grateful for any help or suggestions anyone can offer.

You should be able to use PrtDevMode to change the number of copies/labels - see the example under Access Help

The problem lies in the fact that you procedure runs in the Before Update event - this does not occur when you leave the control - try On Lose Focus

After much experimentation, and a lot of false starts, I have come up with the solution to evenly spacing two reords on a page (and with minor mods it could be extended to more records)as long as the report contains only a detail section. As far as I can see it is pretty watertight - it works...

Mike, you are quite correct about what I am trying to achieve. In your previous message you said you got the report to space evenly by moving all the objects down to the bottom of the detail leaving the blank space at the top. Do you mean that you expanded the objects so that there was no...

No - the page is set to portrait. But I like Ian's idea of printing half the records at a time and then reversing the paper - at least I don't lose half the paper as I do at the moment printing one record per form! I just thought that it should be possible in Microsoft's best selling database...

The problem with printing to A5 is a physical one with the printer - the default paper tray cannot take A5 and the multipurpose / manual tray can only take a very limited number of sheets and even then frequently mis-feeds or jams - the only way round it is to use manual feed and hit <enter> to...

Thanks for your reply. Yes there is vertical space between fields in the report when viewed in design view (it is actually designed to print end-of-term reports which have to be on A5 ie half sheets of A4). When I try stretching the detail section (the only existing section) it prints only one...

Thanks for your help - the header and footer sections are shrunk to nothing, it is only the detail that exists. The detail itself contains a fair amount of blank space between the fields but I am not sure why this should cause a problem

I want to print a report (no headers or footers) with two records per A4 page, so that, when I cut the page exactly in half, horizontally, each record will start exactly the same distance from the top of the new A5 page. The top and bottom margin are the same (minimum) but the second record...

I would like to group records in a report by a predetermined number so after every say 5 or 10 lines the group header (and footer) would be printed but I cannot find a way of doing this without put a number column in the underlying table and printing the report in this number sequence. Can...