Earlier this year I was helped by UA converting cash amounts to words..this has worked really well.

Some background....this charity organisation has cheques to distribute every month and we wanted to automate the process.

We can now run a query that picks out 3 pieces of information
Name, Amount and Date.

We went to the bank and they have issued A4 (British) cheques which have 3 blank cheques per page and perferated for easy splitting.

What seemed like an easy job has had me buried in a sea of waste paper as I try to line up the cheques.

I can get the top two to line up but the third apperas on the second page so I would miss one cheque each page.

On the report I have no header and footer and have 9.5 cm of report with the 3 fields. I have messed about with spacing but cannot get the 3 to fit on one page and in the correct positions.

Am I going about it correctly or should I try hand writing them as before.

Regards

Alexander

In report design view should I only concentrate on one cheque and get the spacing correct and how then can I get the other two to print on the same page.

A typical cheque run is around 100 cheques per month.

Thanks

Alexander

You should be able to get it to work.

If the page is formatted "computer friendly" with each cheque the same height then hopefully you can set the detail section to the height of a check and set the page header to be the size of the distance from to the top of the first cheque. I start by measuring the distance between the perforations for the middle cheque.It make take soe textng to get it.

When I have had to deal with preprinted forms with multiples per page that we not very "computer friendly" (not evenly spaced) , I would use a temp table that, in your case, would have fields to hold to hold data for three cheques in a single record. Then I can format the detail sectio0n to be the size of a page and layout all the fields for a single record that will be for three cheques at a time.

Hope this helps ...


Edited by: HiTechCoach on Fri Jun 6 10:09:35 EDT 2008.

Thanks Boyd....the blanks are user friendly because they are exactly 98mm each cheque...3 to a page.

I see...set the Detail to 98mm and then the page header to zero?

I have set the detail correctly and can print the first 3 correctly but cannot print the third.

Do I need to set some property?

Distance from top of cheque to first printing line (to pay Name) is 44mm.

Regards and thanks

Alexander

I have set the detail correctly and can print the first 2 correctly but cannot print the third.

Sorry Boyd...first 2 ok and not the third.

I reset all margins to zero.

Regards

Alexander

Hi Alexander.

Looks like a trip to WH Smith's then.

Boyd was suggesting having the header take up some of the report.

Maybe this might help.

I liked his other approach, which I used once, where I could not get the allignment right for a fourth page. So I only printed 3 and marked these, and then printined another three.

However, for you you have not managed to get three on a page yet.

I would think 98 cm is too much, but think you should be able to crack this.

Jim

Hi Jim...you have had some rain...we ...for a pleasent change... have had a dry week.

I think a whole forest of paper has been used trying to work this out.

Each cheque is 98mm in height...3 together makes an A4 page.

At this setting it simply will not print 3 to a page.

If I reduce of course (say 94mm) it will print 3 but second and third out of position for payee and amounts.

I have tried many settings...very frustrating. seems such an easy task?????

I let Viking do the walking for the paper....all of which I recycle !!!!!!!!!!!

Thanks for you help

Alexander

Rain? 4 months worth in a week.

I wonder if this is where you need a header and footer?

Keep the detail to a minimum and use up the "excess" with the header and footer. It might keep you details aligned enough to get away with being "okay" for a page and then adopt a print one page many times approach with print confirmation between to clear the record.

Just a thought.

Jim

Excellent Jim....yes use the header and footer....mess with them and not the detail....keep this to a minimum

Ok just had another 5 boxes of paper arrive today....plus the cartridges.

Ok ...cutting grass now at my sons....they know when it needs cut but I always seem to visit when its just ready for it....as you know nothing beats a perfect grass strip.

One of the hihlights of my playing days was the test grounds...when practicing at 9 am on new cut grass....simply fantastic....can still smell it !!!

Thanks for your help. I will let you know tomorrow....hope you manage a game.

"adopt a print one page many times approach with print confirmation between to clear the record" ...not quite sure what this means????

Alexander

I used to work in a lab where we had gas chromatographs and a continuous paper. I had a colleague who would put these on too fast and forget about them. Miles of paper everywhere. My call was "Up the Canadian Pine Forest" as another pile of paper ended up in the bin. When I had the chance we used this paper four times by feeding it in each way.

Sounds like me using the wife's car with your boys and their grass. I get to use it "oh and it just needs topping up with petrol"

Never really been allowed on "hallowed turf" but my first time at Lords was a gasp moment, seeing grass in such superb condition, and the smell of new cut grass, unbeatable - well, a decent pint of Suffolk bitter is pretty good as well.

My comment on printing one page and then another page is that, sometimes you can get there with the alignment, except it start to slip slightly, so by printing as individual pages, then the slippage was negated.

So you might have to adopt something like this.

Have a good one Alexander.

Jim

Hi Jim...still battling...such a basic thing but simply cannot get all 3 lined up even when blank cheques are spaced out and look user computer friendly.

I can get the first two but not the third....I can get second and third but not the first....tried headers/footers/detail, page margins etc.

Maybe I need a different approach.

We were told yesterday that I could print signatures as well....I have scanned them to add to the detail.

What do you suggest as the best format and how to add to cheque?

In the end we can write them but you cannot beat an access problem.

Regards

Alexander

Hi Boyd...just re-read your comments and having measured again the cheques are 3 to a page and each one 98 mm in height, 3 making making an A4 page.

When I try to move the detail to 98cm it will only show per page...the only time it shows3 per page is when I drop the detail to 94 mm but this will not print the third one in line.

I have no header or footer.

I have looked at Page set Up but cannot seem to hold the margins at zero to give me full height.

All the data is pulled from one query.

I need to find another way around this issue.

Any comments on page set up appreciated.

Alexander

Alexander

Can you copy, strip out sensitive data, C&R, zip and post.

Might be able to crack it - then again might not.

We won yesterday, after two losses on the bounce, the first time for 4 years, so the mood at the club was a bit more convivial last night.

Jim

Well done...nothing like a victory to set up a Saturday night !!!

Since I last made contact I have googled the page set up to find there is an issue with Margins...Whatever you set is ignored, or so it would seem.

You would need the blank cheques page so let me first work on this page margin issue to see if I can extend the page.

I tried to set Top and Bottom margins at 0 but it just defaults to default settings.

Let me read up on this and come back to your offer of zipping the program.

Thanks

Alexander

Yeah, it was a good Saturday night. In fact, finishing early was even more fun.

You know where we are Alexander.

Jim

Hi Jim..still no joy...must be an access 20000 issue ...I have SP3 and I have tried all the advice when I google Page settings and Page Margins...it will always default and will not let me hold 0 for top and bottom margin.

Thanks for trying to help...hand writing is an easy escape but you know what these problems do to you !!!!!

Regards

Alexander

H Alexander.

Can you post the base with just some mickey mouse data?

I just want to be certain we can not help, coz I am sure we can.

Jimbo

Hi Jim...Database is 12Mb and I cannot strip out the bits required without problems.

I know you want to help...much appreciated ...I just wanted to keep you posted.

It is so frustrating having a simple problem like this and unable to solve. I have tried thinking in different ways...printing one per sheet and then using remaining two but no sure about that.

Then thought what about separating the cheques and printing one at a time...but could not find a paper size 210mm wide x 99 mm high.

I will work on extracting the table/query /report and add some dummy data.

Regards

Alexander

Thats all we need Alexander.

So dummy data of your in a table (data dump of the query will do) and your report, and just a play.

Just hossed it down with rain here. Must have had an inch in 30 minutes. Everywhere flooded. Not quite seen rain like it.

Later.

Jim

Hi Jim..sounds serious and typical of our changing weather...warmer but will be wetter.

Sorry for delay...I am not good at extrating parts of the database and failed to get the module to work for converting amounts to english eg £20.34 Twenty Pounds and Thirty Four pence..works great om manin database.

Just included some basic data and the report.

If I move it to the required 99 cm height...3 cheques to an A4 page ir simply refuses to print 3 per page...the best I can do is 9.3cm but then not all line up.

First printed line is date at 3.4 cm

Sorry not a great example but it will show you the problem.

Regards and appreciated

Alexander

Well I have had a play

I think that I have it.

I have three to a page and it looks about in the same position as your two.

Take a look and see how close this is, you might have to slightly move the control position and not the heights.

It is cheques2 in your base.

Jim

Hi Jim

I know you are working in the dark on the layout.

Still need just a little more space between names...middle is perfect..top name just below and third just above.

Regards and interesting you have reduced the controls?

I tried to heighen the detail but then only two printed.

Alexander

Stay away from the details height, move the controls, just nudge them up and down and see.

I like the can grow approach to controls like this.

Jim

Hi Jim..sorry because of this problem I have not been thinking clearly.

I attach the blanks so you can print them and then try.

See if this helps

Alexander

Pine forests ravaged, but I have it working

Hope this suffices.

Save the yippee report as a copy before playing with it.

Hope this satisfies your expectations.

Jimbo

Hi Jim and thanks....don't know how you did it and don't quite know how I am going to get into the main database but it's very very close to being perfect.

MUCH APPRECIATED.

I am amazed (with Access of course I should not be ) that with such a small detail height it still prints out almost correct.

At the moment you are getting between the names 95 mm....ideal would be 100 mm.

I have not encountered controls that I can bearly see so I am not sure what to do with them.

I will have a further play and comment.

Best regards

Alexander

Well I think that it is about as good as it will get.

I am using the fact that they grow to get the height right.

If you move the widest one by 0.002 cm from 3.866 to 3.868 it throws it down further, so i think truly this is as good as it gets I am afraid.

You might be able to select all and nudge them down or up, but I think this is about it.

My only concern in the numbers in words. If you have mega thousands, then you might find it going funny, but I have not tested for this.

You can export the report into you live base and then play here and this should work.

Jim

Thanks Jim...you have been great and have stuck at it....I will let you know the final outcome.

We are very close and thanks for your solution.

Alexander

Well I hope I have helped.

Just send one of those cheques to AQ Morgan.

Will be nice. LOL

Hope I have helped Alexander.

Jimbo

HA HA...super stuff Jim...you have been a grea help on this and my other issues.

Just received in the post today "Running Access 2000" by John Viescas ...mint condition...99p on ebay and £5 postage...what a deal and extra reading for me as I try to improve my skills....may be one day Ican answer some posts on UA.

Hope the rain has stopped.

Alexander

Hi Jim..mixed weather today but warmish.

Cricket not on today due to gala day...we play tomorrow.

In the end I have settled on two per page as the 3 simply are about 5 mm out...no matter what I try i cannot get them into all into position.

I have not given up and I will work away on it.

Thanks again and I will keep you posted.

Hope you had a decent match

Alexander

Hi Alexander

Dont know if you have moved on but I had a play
with your cheque report and i think it fits OK with 3 on a page

Take a look

Regards

Mike

Hi Mike from one of my favorite places in Scotland and the for the rest of UA the cleanest, friendliest public toilets in the UK, if not the world.

Thanks for taking the trouble.

As yet I have failed to have 3 printed per page.

I can print 2 perfectly but I need 98 mm between the names to get 3 to work and your example is the same as we are getting.

It's a problem I just cannot solve.

Appreciate you trying but if must need some header/footer option as well.

I will keep you posted. Did you have a copy of the blanks to work on?

Regards

Alexander

Hi Alexander

yes I downloaded the blank page and it printer perfectly on my printer?

Mike

Thanks Mike...I must be missing something.

Please measure the distance between the centr of the Payee name to the centre of the payee name on cheqye 2 and 3.

It needs to be 98mm...what did you get?

Thanks for helping

Alexander