A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Rearranging entires



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2005, 11:30 PM
PatriciaT
external usenet poster
 
Posts: n/a
Default Rearranging entires

I entered data into the data base the way I wanted it to print out on mailing
labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?
  #2  
Old May 26th, 2005, 12:19 AM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

PatriciaT wrote:
I entered data into the data base the way I wanted it to print out on
mailing labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?


First, I assume you are using Microsoft Access Database, part of they
professional Office?

Assuming Access, I would guess you will need to edit the Report that is
producing the labels. I have never used Access to print address labels so I
am making a few guesses.

How familiar are you with Access and report writing?

--
Joseph Meehan

Dia duit


  #3  
Old May 26th, 2005, 04:58 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Wed, 25 May 2005 15:30:08 -0700, PatriciaT
wrote:

I entered data into the data base the way I wanted it to print out on mailing
labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?


It's not "interpreting" - it's doing exactly what you're asking it to
do. This might not be what you WANT it to do though!

Assuming that this is a Microsoft Access(TM) Report (rather than Works
or some other program, which may require a different approach), open
the Report in design view. You should see textboxes for the name,
title, organization and so on. Simply move these textboxes around on
the report (using the mouse) until they are laid out the way you want
them. Save the Report and see if it looks like you want it.

John W. Vinson[MVP]
  #4  
Old May 26th, 2005, 08:21 PM
Tom Brown
external usenet poster
 
Posts: n/a
Default

This reminds me of one of my favorite "computer" sayings.

"I really hate this darn machine, I wish that they would sell it!
It never does what I want it to, it only does what I tell it!"

Good luck,

Tom



"John Vinson" wrote in message
...
On Wed, 25 May 2005 15:30:08 -0700, PatriciaT
wrote:

I entered data into the data base the way I wanted it to print out on
mailing
labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?


It's not "interpreting" - it's doing exactly what you're asking it to
do. This might not be what you WANT it to do though!

Assuming that this is a Microsoft Access(TM) Report (rather than Works
or some other program, which may require a different approach), open
the Report in design view. You should see textboxes for the name,
title, organization and so on. Simply move these textboxes around on
the report (using the mouse) until they are laid out the way you want
them. Save the Report and see if it looks like you want it.

John W. Vinson[MVP]



  #5  
Old May 27th, 2005, 11:52 PM
a
external usenet poster
 
Posts: n/a
Default


"Tom Brown" wrote in message
...
This reminds me of one of my favorite "computer" sayings.

"I really hate this darn machine, I wish that they would sell it!
It never does what I want it to, it only does what I tell it!"

Good luck,

Tom



"John Vinson" wrote in message
...
On Wed, 25 May 2005 15:30:08 -0700, PatriciaT
wrote:

I entered data into the data base the way I wanted it to print out on
mailing
labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?


It's not "interpreting" - it's doing exactly what you're asking it to
do. This might not be what you WANT it to do though!

Assuming that this is a Microsoft Access(TM) Report (rather than Works
or some other program, which may require a different approach), open
the Report in design view. You should see textboxes for the name,
title, organization and so on. Simply move these textboxes around on
the report (using the mouse) until they are laid out the way you want
them. Save the Report and see if it looks like you want it.

John W. Vinson[MVP]





  #6  
Old May 27th, 2005, 11:56 PM
a
external usenet poster
 
Posts: n/a
Default


"Tom Brown" wrote in message
...
This reminds me of one of my favorite "computer" sayings.

"I really hate this darn machine, I wish that they would sell it!
It never does what I want it to, it only does what I tell it!"

Good luck,

Tom



"John Vinson" wrote in message
...
On Wed, 25 May 2005 15:30:08 -0700, PatriciaT
wrote:

I entered data into the data base the way I wanted it to print out on
mailing
labels.
name
title
organization
address
city, state zip
The settings print out the labels with title then name.
How do I change the settings to stop interpreting and do what I say?


It's not "interpreting" - it's doing exactly what you're asking it to
do. This might not be what you WANT it to do though!

Assuming that this is a Microsoft Access(TM) Report (rather than Works
or some other program, which may require a different approach), open
the Report in design view. You should see textboxes for the name,
title, organization and so on. Simply move these textboxes around on
the report (using the mouse) until they are laid out the way you want
them. Save the Report and see if it looks like you want it.

John W. Vinson[MVP]





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Entires and ignore duplicates Alan Running & Setting Up Queries 3 March 11th, 2005 03:49 PM
Large Entires into an Access Table.Field (IIS4) Wayne General Discussion 2 February 11th, 2005 04:53 AM
How to prevent foreign entires appearing in Outlook Contacts? jimRedfield Contacts 1 February 3rd, 2005 09:24 PM
Count Unique Entires -- with conditions Erik Wynn Worksheet Functions 2 December 7th, 2003 03:17 AM


All times are GMT +1. The time now is 05:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.