Printing gridlines in Address Query
- Thread starter PghPatti
- Start date
pcs
Registered User.
- Local time
- Today, 05:51
- Joined
- May 19, 2001
- Messages
- 398
well, i'm clueless...
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).]
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).]
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
pcs
Registered User.
- Local time
- Today, 05:51
- Joined
- May 19, 2001
- Messages
- 398
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).]
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).]
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).]
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.
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.
pcs
Registered User.
- Local time
- Today, 05:51
- Joined
- May 19, 2001
- Messages
- 398
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)
al
[This message has been edited by pcs (edited 08-19-2001).]
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)
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.
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.
pcs
Registered User.
- Local time
- Today, 05:51
- Joined
- May 19, 2001
- Messages
- 398
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!
al
i'm actually a colts fan. so you can see my problems!
al
Jack Cowley
Registered User.
- Local time
- Today, 11:51
- Joined
- Aug 7, 2000
- Messages
- 2,639
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....
R
Rich
Guest
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
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
Similar threads
