Help! Print selection brings empty box

[jen]

I have several things I need printed from a datasheet by
tomorrow afternoon and it never occurred to me that I
couldnt print in Access. I've used Access for awhile, but
never had this issue. I've tried using Visual Basic (didnt
know it existed until today) and setting up a PrintOut
macro, but I still just get a border. Please help. I
thought our Access guru would know this, but she does
screen print if she wants something printed. To do a
screen print I'll have to reload camera software that was
removed last week by our computer guru. Thanks!

 

[Rick B]

You never tell us what your problem is. What are you trying to print? What
happens when you do? What does vba have to do with this?

Are you printing a report? Reports are designed for printing. Step one
will be to build a report that pulls the data you need. Step two will be to
print it.

If your "access guru" screen prints anytime she needs data from Access, she
is very very far from a GURU.

Give us details if you need a detailed response.

Rick B

 

[Fred Boer]

Dear jen:

Ok, well, I'm not familiar with datasheets, and I do all my Access printing
using reports, so don't really have an answer to your Access problem, but if
you need a quick fix, and you just want to print off a screen shot, try
this:

Press the print screen key on the keyboard. (Possibly labelled "PrtScn")
Open Word or WordPad.
Press Ctrl-V to paste from clipboard.

This will paste a copy of the screen image into the word processor.. then,
just print.

Of course, it seems to me that printing things this way is really not using
Access to its proper potential...but at least you won't have to rinstall the
camera software...

HTH
Fred Boer

 

[jen]

I am trying to print a selection of data from a query.
When I do Print, Selection, (like I would for Word) it
gives me the border, not the contents of the selected
fields. There are 6 columns in the query and numerous
businesses (rows). One business might listed 30 times and
another one might be listed 100. I wish to print column 5
of each business, which might be anywhere from 30 rows to
100. I did a search in Help and the best 'help' I found
led me to vba. I think Help in Access is for people who
need help less than I do. I used vba because I thought
that's what help said do. In defense of my guru, I dont
think that what she told applies to all views (maybe she
was telling me about forms?). I'm not trying to be
difficult and I really do appreciate the time you're
taking to help me. Does this give you enough info? jen

 

[jen]

Fred:
Print screen has never worked on my keyboard. I'm
computer cursed, what can i say? It really wouldnt solve
my problem as I would like anyway because I would have the
entire page and not just the (much smaller) selection.
But I really appreciate the suggestion. And believe me, I
understand about not using it to it's fullest potiential!
I just dont know enough about what it could do, to do it!

jen

 

[Rick B]

Yes, but you missed the main point in my first post. Build a report.

You need to build a report that shows the data you want. (Base it off of
your query) Then, print the report.

Queries are not designed for printing, reports are.


Rick B

 

[Fred Boer]

Well, it was a long shot anyway. Do what Rick says - he's an expert and he's
giving you the right answer...

Good Luck!

Fred

 

[jen]

Yes, I missed that completely. Thanks. jen

-----Original Message-----
Yes, but you missed the main point in my first post. Build a report.

You need to build a report that shows the data you want. (Base it off of
your query) Then, print the report.

Queries are not designed for printing, reports are.


Rick B






.

 

[jen]

Thanks for the help, Fred. I'll have to work on creating
reports when I'm not so pressed for time. It seems an
incredible waste of Access, but for today, I'll cut and
paste into Excel and print from there. It was nice
speaking with you. jen

 

[Fred Boer]

....and with you, Jen! Good luck. If and when you do decide to try working
with Access, this is a great place to find answers and help, come back
again!

Fred

 

[Guest]

If it is a form, you need data in your table in order to print... I had the
same problem!