473,323 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

How to print a report from a command button click in Access 2003

Hi,

I’m having difficulty getting a report in ms access 2003 to print (physically print to printer) once I’ve clicked a command button in a form. What’s the best way to do this?

I tried connecting to a printout macro however I’ve not installed the correct wizard. I’m 6,000 miles away from my home office so installing it is more difficult than it sounds.

Is there a simple way to do this using a simple sql statement?

Thanks in advance,
Hot ~:)
Oct 30 '07 #1
2 3876
missinglinq
3,532 Expert 2GB
You can do all this using the Command Button Wizard!

Place the button on your form. When the Wizard comes up, click on Report Operations in the left hand box and then, from the right hand box, select either Print Report (to go straight to the printer) or Preview Report (to preview before printing.) The Wizard will then walk you thru selecting the actual report you want to print.

Welcome to TheScripts!

Linq ;0)>
Oct 30 '07 #2
Thanks Linq, glad to have found this place.

I've have an additional question why i do as you you state, is there a way i can limit the pages printed to say page 1 only, or say a sequence of pages?

Thanks,
Hot~:)
Oct 31 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Jack | last post by:
Hello, I have a web-based application, located on the Internet, and I'd like to use a command button like a hyperlink. Ideally, I'd like to have the users default mail client be initiated with...
6
by: MLH | last post by:
How can I hit www.someplace.com from an Access form? I'd like to... 1) open user's default browser (if not already open) 2) type in a URL 3) press enter (or click Go - or - whatever it takes) ...
5
by: martin DH | last post by:
Hello, I am using MS Access 2002-2003. I added a "Print Record" command button to a form in my database. Is there a way (via VBA or anything else) to open a print preview screen when the command...
2
jaccess
by: jaccess | last post by:
I was wondering if there is a simple way to open a specific folder from an access form button. I have a form that a user can enter a date range and either view or print reports based on the date...
24
Dököll
by: Dököll | last post by:
Jumped for joy last night after learning, indeed, the command button wizard can be switched on or off. Well this occured here, with my Access 2000...an attempt to redo at work failed. Here's the...
12
by: HowHow | last post by:
I need to create a few reports using one query and I wish to do the program filter from the buttons in a form. I had created a query named q_ClientsHvServices and a report based on that query named...
1
by: RyanT | last post by:
Access 2000 Windows XP I have a small form with two text boxes: - User ID - Password The form also has two command buttons: - Login - Cancel
3
by: KrazyKasper | last post by:
I created two Command buttons in a form, one to preview the entire report and one to "cancel" or exit the form. They both work. I'm trying to create a third Command button to select/filter data from...
3
by: cambar | last post by:
I created a simple macro to open a form with several command buttons on the form. On one of these buttons I want to require a password for access. I am not a programmer. What do I need to do to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.