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

[Guest]

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.

 

[Joseph Meehan]

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.

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Joseph Meehan]

I can think of at least four ways of doing it off the top of my head,
but I don't think any of them would really be very helpful for your specific
needs. Maybe someone else will have some better ideas. With only 120
names, everything I can think of would be more trouble than it is worth.

 

[Candea Darville]

I am not sure what you mean.