473,748 Members | 4,065 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

2 New Member
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 3913
missinglinq
3,532 Recognized Expert Specialist
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
Hothead
2 New Member
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
476
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 my application populating the recipient and subject. I have the latter values in variables, I just need to know how to initiate the user's default mail client and pass the recipient and subject values in. Thanks in advance!!
6
5116
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) I'd like it all to happen when user clicks button on form.
5
8521
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 button is selected instead of immediately printing the record? Thank you! Martin DH
2
4468
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 range. These reports are based on linked excel files. What I am trying to do provide a simple way (press a button) for my users to be able to open their excel files from the form instead of having to open excel, locate the folder then locate the...
24
15746
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 scenario, quite amusing, and I'll try to sum this up quickly:-) At home, when the command button wizard (Access 2000) loads and give me some wonderful options/selection tips, the result, code is pre-written for the button when completed. I...
12
2746
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 Rpt_ClientsHvService. In the main form, I created few buttons to view clients from different progrom. When I click on a button named "HACC", the report should select all the clients that have services under PROGRAM starting with HA (and all HA*). When...
1
8818
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
2311
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 the report. My code to filter the data is: Private Sub SelectedContract_Click() On Error GoTo Err_SelectedContract_Click strFilter = " = '" & Me! & "'" DoCmd.OpenReport "OPTIMIZEIT-Audit1", acViewPreview, , strFilter ...
3
7887
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 make this happen? Thanks for your help
0
8826
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9534
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9316
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6793
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6073
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4597
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3303
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2777
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2211
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.