How do I create macros to repeat street addresses in Access 2000?

B

bjw

The only "Help" I can find for macros in Access Database are for actions. I
want to set up a macro to repeat street addresses for apartment buildings,
for a mailing database, so I can print envelopes.
 
B

bjw

Joseph Meehan said:
Could you provide some more specific information. It sounds like you
are wanting to be able to save the same address to a number of individuals
easily. If so you need to set up related tables, one for the individual and
one for the addresses. I would guess that you may need to consider one
individual with more than one address and one address for more than one
individual.




--
Joseph Meehan

Dia 's Muire duit

My database will include the street address of three apartment buildings. I would like to create a macro for each building, so when I enter the name of someone living in one of those buildings, I don't have to retype the street address each time. I can do "copy" if it is on the line above, but that's not always possible. the macro would read: 1234 Main Street, Apt#... Also, the city, state and zip code will be the same for all. I will have about 120 names and addresses in this database. Thanks for your help.
Click to expand...
 
B

bjw

Joseph Meehan said:
Could you provide some more specific information. It sounds like you
are wanting to be able to save the same address to a number of individuals
easily. If so you need to set up related tables, one for the individual and
one for the addresses. I would guess that you may need to consider one
individual with more than one address and one address for more than one
individual.




--
Joseph Meehan

Dia 's Muire duit

I forgot to add that it would be one address for several individuals. Not everyone in my database lives in the three apartment buildings, but enough do so that a macro would be very handy.
Click to expand...
 
Top