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 9 1579
"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.
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
"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'.
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
"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.
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
"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.
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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
|
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...
|
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:...
|
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...
| |
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...
|
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.
|
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
|
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
|
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...
|
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,...
| |
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |