| Author |
Creating a Mailing Sheet using Data - PLEASE HELP
|
|
|
| Hi People
I need help!!!
Have got a excel file that i have put into an access file so that i can
create a mailing carrier sheet without re typing everybodys details in.
The excel file has some blank spaces within it for example:
Mr A Smith
Headteacher
The School
Lincoln
LN1 1UY
and
Mr B Smith
The School
Lincoln
LN1 1UY
How can i get the database to not show the blank spaces, and move the
details up 1 line.
I have created the mailing using the report method on access and cannot
see how to fill in the blanks.
Do i need a bit of code? - If so how do i create it?
Your help would be much appreciated.
Tris n Ady
| |
| Anthony England 2006-02-21, 3:24 am |
| "Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140510480.485648.164950@g43g2000cwa.googlegroups.com...
> Hi People
>
> I need help!!!
>
> Have got a excel file that i have put into an access file so that i can
> create a mailing carrier sheet without re typing everybodys details in.
>
> The excel file has some blank spaces within it for example:
>
> Mr A Smith
> Headteacher
> The School
> Lincoln
> LN1 1UY
>
> and
>
> Mr B Smith
>
> The School
> Lincoln
> LN1 1UY
>
> How can i get the database to not show the blank spaces, and move the
> details up 1 line.
>
> I have created the mailing using the report method on access and cannot
> see how to fill in the blanks.
>
> Do i need a bit of code? - If so how do i create it?
>
> Your help would be much appreciated.
>
> Tris n Ady
I guess you have a field called JobTitle or something which is not filled in
for all people. In the design view of the report, highlight this textbox
and press F4 to show the properties. On the first tab labelled 'Format'
change the CanShrink property to Yes. This should cause it to shrink
completely when the field is blank.
| |
|
| Hi
Thats Brillant Thankyou, However
When doing this it looks like I have extra spacing after the lines
which contain no information
Is there a way of reducing this space so that it matches the rest of
the line spacing, I have no borders selected or any thing else that
seems obvious?!
Many Thanks
Tris n Ady
| |
| Anthony England 2006-02-21, 7:24 am |
|
"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140514276.287089.52430@z14g2000cwz.googlegroups.com...
> Hi
>
> Thats Brillant Thankyou, However
>
> When doing this it looks like I have extra spacing after the lines
> which contain no information
>
> Is there a way of reducing this space so that it matches the rest of
> the line spacing, I have no borders selected or any thing else that
> seems obvious?!
>
> Many Thanks
>
> Tris n Ady
If you were printing labels, for example, then you would want the height to
remain constant because you need to start printing the details at exactly
the same position on each label.
I'm not sure I completely understand, but I think you are saying that you
don't want this, but want the height taken by each entry to vary.
If that is the case, set the CanShrink property of the report's detail
section to Yes - this is 'the white space behind your textboxes'.
| |
|
| Hi Again!
The shrink option is working but we are recieving more line space in
the fields that are blank.
i.e
Mr Smith
Headteacher
The School
Lincoln
(This is because he has a job title)
and
Mr Smith
The School
Lincoln
We have managed to close the gap up a little by selecting the can
shrink option but we want it to look like it follows on, ie on three
lines not three lines and a blank line space.
Cheers
Tris n Ady
| |
| Anthony England 2006-02-21, 7:24 am |
|
"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140515446.652810.175390@g43g2000cwa.googlegroups.com...
> Hi Again!
>
> The shrink option is working but we are recieving more line space in
> the fields that are blank.
>
> i.e
>
> Mr Smith
> Headteacher
> The School
> Lincoln
>
> (This is because he has a job title)
>
> and
>
> Mr Smith
>
> The School
> Lincoln
>
> We have managed to close the gap up a little by selecting the can
> shrink option but we want it to look like it follows on, ie on three
> lines not three lines and a blank line space.
>
> Cheers
>
> Tris n Ady
And you have set CanShrink for the textboxes and the report's detail
section? If you still can't get it to work, post back and I'll send you an
e-mail address you can send it to if it's nothing too confidential.
| |
|
|
Hi
I have checked these and they are already checked.
I still cant get it to work.
I cannot send the file to you, however I have created a small made up
database and am happy to send that for you to have a look at.
If possible can you provide me with your email address so i can forward
this on to you.
Many Thanks
Tris n Ady
| |
| Anthony England 2006-02-21, 7:24 am |
|
"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140522242.100484.57160@f14g2000cwb.googlegroups.com...
>
> Hi
>
> I have checked these and they are already checked.
>
> I still cant get it to work.
>
> I cannot send the file to you, however I have created a small made up
> database and am happy to send that for you to have a look at.
>
> If possible can you provide me with your email address so i can forward
> this on to you.
>
> Many Thanks
>
> Tris n Ady
I've sent the details to yours assuming you provide a valid e-mail - I don't
post one here.
| |
|
| Hi
Many Thanks for that
However I have just done it!!!
My problem was that my boxes which contained the fields were slightly
over lapping each other!!!! I have made all these so they now do not
touch and the results are brillant.
I will read your reply to my email any way but just want to say many
thanks for the help!!!
Our Previous data bases were some what destroyed by a member of staff
who recently was made redundant!!!!!!
Cheers Again
Tris and Ady
| |
| Anthony England 2006-02-21, 7:24 am |
| NNTP-Posting-Host: host86-137-47-60.range86-137.btcentralplus.com
X-Trace: nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com 1140525806 9339 86.137.47.60 (21 Feb 2006 12:43:26 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Tue, 21 Feb 2006 12:43:26 +0000 (UTC)
X-RFC2646: Format=Flowed; Original
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Xref: number1.nntp.dca.giganews.com comp.databases.ms-access:851849
Glad to hear you got it sorted!
"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140525017.918960.86590@o13g2000cwo.googlegroups.com...
> Hi
>
> Many Thanks for that
>
> However I have just done it!!!
>
> My problem was that my boxes which contained the fields were slightly
> over lapping each other!!!! I have made all these so they now do not
> touch and the results are brillant.
>
> I will read your reply to my email any way but just want to say many
> thanks for the help!!!
>
> Our Previous data bases were some what destroyed by a member of staff
> who recently was made redundant!!!!!!
>
> Cheers Again
>
> Tris and Ady
>
|
|
|
|