Ms Office Programs Expert?

Lounge By TexasSugar Updated 8 Mar 2010 , 4:29am by TexasSugar

TexasSugar Posted 1 Mar 2010 , 6:43pm
post #1 of 15

I need to make a data base for 27 years worth of customers. I'm figuring on using Access to do it, and have that part figured out, mostly. My problem is that because not everyone in the office is computer friendly, they want a hard copy. When playing around with Access, I couldn't ever get the list print how I wanted it. I could only get about 3 entries per page, and that would just be a waste of paper, because again we are talking 27 years worth of names, addresses, and other information.

I know that you can import/export information from one program to another, in the MS Office Programs, but it has been so long since I have done any of that stuff, so I'm not sure it will work for what I want.

Can I take some of the information from the Access Database and import it into Word or Excel and print out what I need, with out all the extra stuff that Access thinks it needs to list print?

14 replies
KASCARLETT Posted 1 Mar 2010 , 7:08pm
post #2 of 15

When looking at the design view of your report, make sure there is no space between the end of your detail and the "Page Footer" row. If you have "dead" space between the end of your detail info and that "line", Access also counts that space as an entry. Does that make sense? lol

TexasSugar Posted 1 Mar 2010 , 7:31pm
post #3 of 15

Not really.

My issue with it is that it wants to print it all in boxes with all kinds of empty space between each catergory. All I need is a row with the information so they can easily look it up.

KASCARLETT Posted 1 Mar 2010 , 7:44pm
post #4 of 15

It's really hard to explain I guess, unless I can see it. Have you moved the stuff around like you want it to look like on the report? I'll help you the best I can. Send me an email at [email protected]

TexasSugar Posted 1 Mar 2010 , 8:10pm
post #5 of 15

I've got to make some adjustments to it. Someone else made the database for me and I have to make some changes to what I need and don't need on it. I didn't know if I wanted to go through all the work of making changes and starting to type in all the information if I wouldn't be able to realisticly print it out. I'm perfectly happy looking things up in the data base on the computer, but others around me, think they have to have a print out. And of course they don't understand that I can't always just tell the program to do what I want it too.

Guess I just need to play some more.

KASCARLETT Posted 1 Mar 2010 , 8:48pm
post #6 of 15

LOL I understand!

TexasSugar Posted 1 Mar 2010 , 9:09pm
post #7 of 15

If I can't get it to do what I need I'll be sending you a message. icon_wink.gif

CakesbyCarla Posted 3 Mar 2010 , 8:44pm
post #8 of 15

I'm really rusty on Access, but way back when I used it a lot and it seems to me that you could do a 'query' where you would hand select the fields that you want printed (as well as date ranges etc) and then print it out. I don't have access on my machine, so I'm not sure where to look, but I do know that the word was 'query' and it's probably up in the main menu under File or Tools or something along that line. See if that helps.

TexasSugar Posted 3 Mar 2010 , 8:52pm
post #9 of 15

Oh I can get it to print out things, they just want to dress up what I am printing by putting things in neat little boxes and I don't want 6 different boxes with in the big box when I print this stuff out. Sigh.

I have the 2006 version, I'm betting the older ones probably would do it, but this one, nope.

CakesbyCarla Posted 3 Mar 2010 , 9:06pm
post #10 of 15

Maybe there is a place to select formatting features you do and don't want like an "options" or "properties" or something like that you can click on before printing it? Or even in the printer properties? Sorry the query thing didn't help. I was thinking when you set up the parameters for the query you might be able to designate formatting options as well.

myslady Posted 7 Mar 2010 , 8:10pm
post #11 of 15

Can you export the report to excel and then print from there?

KathysCC Posted 7 Mar 2010 , 8:27pm
post #12 of 15

You have a lot of options for this. I would think that the best thing to do would be to export your data to something that is more printer friendly. It's hard to help without seeing everything but keep trying different things.

TexasSugar Posted 8 Mar 2010 , 4:07am
post #13 of 15
Originally Posted by myslady

Can you export the report to excel and then print from there?

This is what I want to know too. I guess tomorrow while at work I just need to open excel and see if I can figure the import/export thing out.

Doug Posted 8 Mar 2010 , 4:17am
post #14 of 15

if you have 2007 version export to Excel is under the External Data Tab -- simply labeled Excel.

once in Excel can do a database merge with Word to pretty it up.

TexasSugar Posted 8 Mar 2010 , 4:29am
post #15 of 15

Hmm, not sure which version of Excel I have, but I will definetly look tomorrow.

Thanks!! icon_smile.gif

Quote by @%username% on %date%