Jun 6 2008, 08:06 AM
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.
Jun 6 2008, 08:57 AM
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.
Jun 6 2008, 09:07 AM
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.
Jun 6 2008, 09:20 AM
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
Jun 6 2008, 09:29 AM
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.
Jun 6 2008, 09:51 AM
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.
Jun 6 2008, 10:08 AM
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
Jun 6 2008, 10:21 AM
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.
Jun 6 2008, 10:29 AM
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????
Jun 6 2008, 11:21 AM
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.
Jun 8 2008, 07:10 AM
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.
Jun 8 2008, 08:38 AM
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.
Jun 8 2008, 12:42 PM
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.
Jun 8 2008, 02:02 PM
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.
Jun 8 2008, 02:36 PM
Yeah, it was a good Saturday night. In fact, finishing early was even more fun.
You know where we are Alexander.
Jun 11 2008, 02:13 PM
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 !!!!!
Jun 11 2008, 05:05 PM
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.
Jun 11 2008, 05:37 PM
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.
Jun 12 2008, 03:38 AM
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.
Jun 12 2008, 05:00 AM
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
Jun 12 2008, 06:11 AM
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.
Jun 12 2008, 06:34 AM
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.
Jun 12 2008, 06:39 AM
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.
Jun 12 2008, 07:55 AM
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
Jun 12 2008, 09:43 AM
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.
Jun 12 2008, 10:06 AM
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.
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.
Jun 12 2008, 11:18 AM
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.
Jun 12 2008, 03:44 PM
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.
Jun 12 2008, 04:36 PM
Well I hope I have helped.
Just send one of those cheques to AQ Morgan.
Will be nice. LOL
Hope I have helped Alexander.
Jun 12 2008, 04:43 PM
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.
Jun 14 2008, 08:54 AM
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
Jun 14 2008, 04:56 PM
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
Jun 14 2008, 05:08 PM
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?
Jun 15 2008, 04:37 AM
yes I downloaded the blank page and it printer perfectly on my printer?
Jun 15 2008, 04:40 AM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here