473,666 Members | 2,121 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to print out files using VBA

1 New Member
I have an access database. It has a query with one field as Unique ID "Passport Number" and another field containing the path to the scanned passport copies (which I have in a folder). The scanned copies are named with the passport numbers. I want to make a form with a command button that will print the respective scan photo.
Sep 22 '13 #1
2 1403
jimatqsi
1,276 Recognized Expert Top Contributor
It's not very clear what you need help with. Do you know how to make a form with a command button? Is it dealing with images you have trouble with? Where's the part you need help with?

When you clarify your need, please add details about what version of MS Access you are using.

You could write a report to print the photo. There's a very easy to use wizard for creating reports. The button could just launch the report, either stopping to ask for which printer to use or directing the output to a printer specified in the report.

Or you could use Access to launch another application with a command line switch to do the printing.

Jim
Sep 22 '13 #2
zmbd
5,501 Recognized Expert Moderator Expert
You also need to tell us what:
OS
Version of Access/Office
Format scans are in (PDF, TIFF, JPG, RAW, etc...)
Sep 22 '13 #3

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

Similar topics

0
2119
by: Joshua Burvill | last post by:
Hello, I am trying to print something to a print server using the following function but I get errors, does anyone have any pointers? Rgds, Josh Traceback (most recent call last): File "<pyshell#2>", line 1, in ?
17
22381
by: John Baker | last post by:
HI; I feel like a fool..I put CUTE FTP in my last request for help --it should have been CUTE PDF! I have FTP on my mind because I have been working on a web based application, and somehow my brain got stuck on it..sorry! Hi: I need some help writing code that will "print" a report using Cute PDF.
3
2047
by: Dan Kjaergaard | last post by:
Hi I created a program using C#, which iterates files and displays these in a listview. However I would like to filter the files, so files won't be displayed if the current user hasn't "read access" any clever way to do that in the .NET Framework using C#? thanks
2
9023
by: Vanga Sasidhar | last post by:
Already posted the same message but the date and time of my machine was set back. and it was listed under the old date. Thats why I am posting the same message again. Please accept this. ------------------------------------------------------------------------------------ Hi All, I have some AVI files and i want to create a program which will open an AVI file from the hard disk at runtime and run that Video. But here i want
1
1813
by: dashyone | last post by:
Hello, I am using the ShellExecute feature in VBA to print files with various types. This feature will open documents in its native format and print them before closing out. I am using the MS Access "DoCmd.OpenReport" command to print document separators containing the file name and path of the next document (slipsheet). This feature works fine except for one thing: the slipsheets are being printed/inserted randomly in the middle of...
11
10605
by: MadMonk | last post by:
Hi, I need to write a small Windows application (console or forms) (for Windows XP SP2 & Windows Server 2003), which will check a folder for the presence of some files, and if they exist, it will zip the files using the inbuilt Compressed files functionality of Windows (same as the Context Menu -Send to -Compressed (zipped) folder). I cannot use any other third party tool (like winzip etc.) because of some non-technical constraints.
0
1611
by: pbd22 | last post by:
Hi. I am having a really tough time here and would appreciate some help. i am using an iFrame to pass a url string of files to upload to server. on the client i have created a multiple upload javascript using the below link: http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element/
0
2346
by: Albert-jan Roskam | last post by:
Hi John, Thanks! Using a higher xlrd version did the trick! Regarding your other remarks: -yep, input files with multiple sheets don't work yet. I kinda repressed that ;-) Spss outputs only single-sheet xls files, but I agree it's nicer if the programs works in other cases too. -and no, I don't intend to use data fields. Wouldn't it be easier to convert those to string values if I ever came across them? Thanks again! Albert-Jan
0
1832
by: bharris | last post by:
Is there a simple way to print files stored in an OLE field using the Windows associated programs? So if it is a .doc, it will open Word, print it and close. PDF opens Acrobat Reader, prints and closes, etc. It would just like right clicking on a file in Windows Explorer & hitting Print. I just need to do it programmatically on files stored in an OLE field. Is it possible?
0
1251
by: brat33 | last post by:
I have lots of files that need monthly cleanup done on them. These files are located in many different directories on the same server. Some example files names are C1234.idx, C1111.idx, C8693.idx, etc....ALL the files will start with either an 'C' or an 'L' and then contain 4 random numbers followed by an extension of either .idx, or .dat. The problem is that there are also files named CTFIX.idx, Ctons.idx, etc...So I can not use: DEL...
0
8449
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8784
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8642
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6198
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
5666
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
4371
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2774
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
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1777
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.