473,851 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Feb 21 '06 #1
9 1582
"Tris" <tr***********@ yahoo.co.uk> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.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.

Feb 21 '06 #2
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

Feb 21 '06 #3

"Tris" <tr***********@ yahoo.co.uk> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.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'.

Feb 21 '06 #4
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

Feb 21 '06 #5

"Tris" <tr***********@ yahoo.co.uk> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.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.
Feb 21 '06 #6

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

Feb 21 '06 #7

"Tris" <tr***********@ yahoo.co.uk> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.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.
Feb 21 '06 #8
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

Feb 21 '06 #9
Glad to hear you got it sorted!

"Tris" <tr***********@ yahoo.co.uk> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.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

Feb 21 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2707
by: Rajiv | last post by:
HI ALL, actually , i m working in a company having large number of employee , i have two userid and password . on id is from admin group(id given to me by technology manager) of the server and other is simpley the user . my software is based on Lan authentication based i.e. when a user works on my system i find that user using AUTH_USER , i think you will be getting my point . when i login using that admin id it creats the excel sheet...
3
4623
by: Joakim Olesen | last post by:
Hi I have an issue with an asp page that reads from an Excel file. I read the file using OLEDB. I create a new Excel file using "MS Excel 2003" and put the following data into a sheet called "Ark1" (2 columns and 5 rows): 1234 reer 1234 feb 4467 heerh 4467 123123
9
8905
by: Paul | last post by:
Hi all Arggghhh........... The problem.....I want the user to be able to create an excel document and name particular cells in the document where they want the data to be placed and then save this out of an XML file or Excel Template file. Next I need to convert a dataset to xml and try and transform this data into the users xml file..........i've seen a few things on this but havent had much success...
3
4331
by: Grim Reaper | last post by:
I print mailing labels out of Access 2000 databases about 3 to 4 times a week. I have been having problems with one thing since I have been printing mailing labels. I print mailing labels by using a report I created and then printing them on a continuous-feed dot matrix printer. I used the Label Wizard, chose the query I created, picked the 'Avery USA 4146' (1 7/16" x 4") - 3 across, paper size: 'Fanfold 358mm x 12 in', and Printer:...
3
2340
by: Grim Reaper | last post by:
I know this is probably an easy question, but I could not find/figure it out. Basically, I am printing mailing labels with a "Sorting/Grouping" section that groups the label types together. Also, I am using a "Report Header" to show a count of how many total labels that are being printed. Now, my problem is that without the "Report Header", the spacing is perfect. But, when I add the Report Header, it gets shifted downwards and the...
1
2306
by: Vivek | last post by:
Hi all, I am trying to import data from an excel sheet to MSSQL server 2000 using a web application (C#). Since I have to validate the data in the excel sheet, the approach i have used is to get the data from the excel sheet in a datatable in my excel sheet. For this i have used an ODBC connection and selected the contents from my excel sheet. Through the data adapter got it into a datatable. CLOSED THE ODBC CONNECTION. Validated the...
14
5809
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a button. Is this possible? & what is the BEST APPROACH for doing this? & also if any links are there do tell those to me too coz I have no idea how to go about doing it.
3
13613
by: implicate_order | last post by:
Greetings, I'm new to python and am in the process of writing a script to parse some CSV data, spread it across multiple Excel worksheets and then generate charts. I searched the internet to find some place where I could look up a HOWTO doc/recipe to do that using either pyExcelerator or win32com.client. Could someone point me in the right direction? I'm at the stage where the spreadsheet and associated data worksheets
3
4549
by: natrajsr | last post by:
Hi, I want to load the data of a excel sheet or in the exact excel sheet format into a Rich TextBox control. I have already worked with loading WORD into a Rich TextBox. It is working fine.; But it is taking long time for our need. So we thoguht, we can find another better solution rather than that. Can anyone help me to find out how to load a excel sheet or in the
0
9898
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11020
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10735
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10356
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7907
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7073
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5934
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4549
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4143
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.