I know there is a way for the gridlines to be printed in my Address Book - I've done it before - but I've just spent over an hour and can't find out how to do it. PLEASEEEEE help! Thanks! Patti

well, i'm clueless... http://www.access-programmers.co.uk/ubb/smile.gif

what address book are you talking about?

are you using access to print your address book from outlook?

if you are trying to print the datasheet view of a query, select Format>Cells>show gridlines...

hth,
al


[This message has been edited by pcs (edited 08-19-2001).]

Hi Patti

Fellow Steeler fan here.

Got to agree with Al on this. If you are keeping track of address why not just create a report and you can print however you like.

D.J.

I'm sorry I am not being very specific but I am TOTALLY new to ACCESS and and just trying to learn how to use it. I started by making an Address Book from scratch - just from my own personal (hard copy) address book. I inserted all my names, address and phone numbers and want to make a hard copy. I did this about a month ago and printed it - it has the lines on the pages of my hard copy. Now I just went into the address book to make a few corrections and can't seem to print it with the lines -for easier reading. I went to Format - but don't have the option for "cells". I have "datasheet" and when I go there it gives me the option to "show" the gridlines but not to "print" them. I don't remember how I did it the last time. Thanks for being patient with me if I'm not explaining this right. Patti

GO STEELERS!

Maybe this is a report and not a query - I don't even know this - duh! Can you explain the difference between a report and a query - in simple language. Thanks - Patti

what tab is selected when you look at your data? tables, forms, queries or what???

a query can be used to generate the data that is to be used in a form or report.

the report simply prints the selected data...and is based on either a query or the table.

hth,
al


[This message has been edited by pcs (edited 08-19-2001).]

Thanks PC - they do show on the Print Preview - but they don't print!

what color do you have selected for the gridlines (on the same form that you use select show...is a printable color (not white, etc...). set it to black...

al

A query is the object you use to gather the information from your tables. The report uses the query to print or view that information. You can use a table or a query to create a report. Once the report is created you can then change the appearence and other things as you please.
On the left side of your database window there should be a list of objects from which you can choose.
Tables , Queries , Forms , Reports etc.
If they are not visible try left clicking on the Objects heading to see if the list of objects appears.
From there you should be able to select an object to see where you created your address book.
Use the Report, Form and Query wizards to create simple designs and then go into design view for those objects and change things. Experiment with them. You will be surprised what you can learn this way.
Also help, , can be informative.

I feel your pain. I've been there as well. Access has a larger learning curve.

D.J.

oops I don't type fast enough


[This message has been edited by DJBummy (edited 08-19-2001).]

[This message has been edited by DJBummy (edited 08-19-2001).]

Thanks DJ - I would really like to take a class in Access - I'm amazed at all the possibilites. I work in Word Perfect Tables all the time - do quite a lot in there but that's like baby steps compared to what can be done in Access - and probably much easier.

Thanks PC also - I do have the gridlines set at black - they were silver and I thought maybe that was the problem and they just weren't showing up. I changed to black and even on the print preview it shows them much darker BUT.......still no lines when I print.

This forum is awesome - to be able to have people trying to help like this. I appreciate it.

patti,
i'm out of ideas, think you may have some sort of printer problem. check your printer settings...

dj's suggestion is apt. make a back-up copy of your database, and experiment!

(btw, a Browns fan probably wouldn't be having these problems) http://www.access-programmers.co.uk/ubb/smile.gif

al


[This message has been edited by pcs (edited 08-19-2001).]

Thanks PC for the attempt - I sure appreciate it.

About the Browns thing - LOL - just wait a couple weeks and we'll see what kind of problems the Browns fans will have!!!It's hard to walk with your chin hanging on the ground.

ahh, just trying to 'stir the pot' a bit. thru the years i've worked a bit in both cleveland & pittsburgh. had a client in pitt. that told me the hardest thing about the browns moving was that he had no one to hate!
i'm actually a colts fan. so you can see my problems! http://www.access-programmers.co.uk/ubb/smile.gif

al

Your use of the word 'cells' made me think that you can show the 'cells' around the individual items in your report, meaning that the items will be in a 'box'. You can show these 'boxes or cells' by selecting the Format tab of the text boxes property sheet and setting the Border Style to Solid. And you can also draw lines in the report as a last resort....

Put the following funtion on your report
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim CtlDetail As Control
Dim intLineMargin As Integer


intLineMargin = 60


For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail

Me.Line ((.left + .Width + intLineMargin), 0)-(.left + .Width + _
intLineMargin, Me.Height)

End With
Next
With Me
Me.Line (0, 0)-Step(.Width, .Height), 0, B
End With

Set CtlDetail = Nothing

End Sub
HTH