How do I back up the address book in Access

J

JamieInNM

BLUEMOON:
I need help creating an address book! I have my table set up with Name,
address, citystatezip, but I can't figure out how to only print certain
addresses. Yes I have a yes/no check box....can you help!?
 
J

John Vinson

I want to create a cd backup of my address book in MS Access. Please advise.
Click to expand...

Exit Access altogether; copy the .mdb file containing your address
book to your CD.

It may help to first use Tools... Database Utilities... Compact and
Repair Database to shrink its size and make the database more
efficient.


John W. Vinson[MVP]
 
J

John Vinson

BLUEMOON:
I need help creating an address book! I have my table set up with Name,
address, citystatezip, but I can't figure out how to only print certain
addresses. Yes I have a yes/no check box....can you help!?
Click to expand...

Create a Query based on the table; select whatever fields you want
printed and the yes/no field; put

-1

on the Criteria line under the yes/no field. Base your label report on
this query instead of on the address table directly.

John W. Vinson[MVP]
 
J

JamieInNM

Ok, I did that...now...how do I get them to print on envelopes? If you don't
mind, you might have to walk me through this step by step...or if you have
some sort of website that might help....anything! Please!
Thank You!
Jamie
 
J

John Vinson

Ok, I did that...now...how do I get them to print on envelopes? If you don't
mind, you might have to walk me through this step by step...or if you have
some sort of website that might help....anything! Please!
Thank You!
Jamie
Click to expand...

Create a new Report.

Select the fields that you want printed on the envelope.

Use File... Page Setup to set the paper size to the size of the
envelope.

Put textboxes on the Report where you want the text to appear.

Run the Report, feeding envelopes into your printer.

For help, press F1 in the Report Designer.

John W. Vinson[MVP]
 
Top