Recent content by Tim L-B

Thanks Paul & Bob Your comments have made me recheck and the reason for the problem now makes sense. The Opps form opens the report when it loads and then confirms no filter and sets the sort order and it is this that closes the report to reopen with the confirmed filter & sort. The options...

Hi All Hope you can help. I have a report controlled by options on a popup form. The report preview can stay open when the form is closed but I don't want the form to stay open when the report is closed. I put code to check if form is open and then close it in the report's close event...

Hi I would like to able to print a single label from a roll on a dot matrix printer and then leave the printer positioned for the next one. Labels are torn off singly to be clipped to items for packing. Problem is suppressing the form feed. I would appreciate any help. Thank you very much

Thanks Maurice As often happens you chase your tail trying to find the answer and as soon as you ask someone the answer appears from another source. Having used Access for a number of years I have somehow missed the wonderful movesize method so the simple solution turned out to be after my...

This is driving me nuts and I am sure there must be a simple solution. I want to create a popup form that just contains a list box that is resized just to the number of entries in the box. No problem resizing box and form detail, but I have not found a way of resizing the form border. Every...

I am so close now thanks to the printer tip. The only small problem is a small gap at the bottom between the vertical line and the base page footer horizontal line. Its very minor but it would be nice to have 100% success. The header & detail format code is as follows: Private Sub...

Thats correct. A two field report (Number & Description) set to print in 2 columns (Down & then Across) using the column option in page set up. What I would then like to do is to divide them with a vertical line. IE: Number Description (VL) Number Description. Using the report.line action will...

Formatting the source query as 2 columns only seems possible if the data runs horizontally. Becomes a problem when you want the data filling column 1 before starting column 2. If MS Works can have a dividing line option when selecting multiple columns why not Access ??

Sorry I didn't explain. The report consists of two fields that are formatted into two columns (Now 4 across) through page set up so that adding a vertical line doubles up on the right hand side. Thanks Appreciate the quick response.

Hi all I would like to divide a 2 column report with a vertical line. Any ideas please TIA Tim L-B