473,321 Members | 1,778 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,321 software developers and data experts.

Access for Company Identification Cards

Thank you in advance for any and all assistance. I recently purchased an Ink
Dye Sublimation printer and I'm looking to do something with Access for my
employee ID Cards. I know I shouldn't store images for bloating purposes, but
how do I get an image into a report, say for printing ID cards, if I don't
store it in the program?

Michael
Nov 12 '05 #1
2 2717
Store the pics in a directory and then link to them.

Don
On 19 Apr 2004 12:50:40 GMT, lu*************@aol.com (Lumpierbritches)
wrote:
Thank you in advance for any and all assistance. I recently purchased an Ink
Dye Sublimation printer and I'm looking to do something with Access for my
employee ID Cards. I know I shouldn't store images for bloating purposes, but
how do I get an image into a report, say for printing ID cards, if I don't
store it in the program?

Michael


Nov 12 '05 #2
"Lumpierbritches" wrote
I recently purchased an Ink Dye Sub...
printer . . . Access for my employee ID
Cards. I know I shouldn't store images
for bloating purposes,
That's not necessarily so -- see the article in the referenced download.
but how do I get an image into a report,
say for printing ID cards, if I don't
store it in the program?


The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

Code that is in the OnCurrent event for Forms would be in the OnPrint or
OnFormat event in Reports.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Lumpierbritches | last post by:
Thank you in advance for any and all assistance. I recently purchased an Ink Dye Sublimation printer and I'm looking to do something with Access for my employee ID Cards. I know I shouldn't store...
3
by: Rolan | last post by:
To those that have been around Access long enough, I'm sure that insight can be shared as to what aspects of computer processing speed improves its performance. Perhaps in some respects even...
23
by: Roel Melchers | last post by:
My ACCESS-database contains all members of my association. When the members attend to a meeting I want to record their presence. When they enter they identify themselves by putting their finger...
3
by: topmind | last post by:
I need to search for database text with underlines in it. However, underlines are interpreted as wild-cards in LIKE clause text . I need to know how to escape the underlines so as to be able to...
2
by: suresh | last post by:
Hello to you all In my .Net application, I want to import document images (Tiff images), having same format, in a batch, For e.g. I have a document folder containing mixed images like...
0
by: jayohare | last post by:
Hello, I have code within my DB application to process credit cards through authorize.net. Ive been using the same code for several years without a problem. I have an order entry computer and...
2
by: nmrpa91290 | last post by:
Hi, I am in the design phase of building a database that will track the productivity of my warehouse. I am thinking of using a barcode scanner to assist me with this. Employees will hopefully...
18
by: Asle | last post by:
Hi, I am creating a Quote Database in MS Access 2007 that prepares Quote for a Printing Company. I have 2 tables, tblClient and tblQuote with 1-to-many relationships. in the Quote form, i...
1
by: Dan1 | last post by:
Hi Guys, I have borrowed below VB code which I like to use to validate card numbers in ms access 2003 Database text box"CardNumber" The card will be checked as the user clicks a command buttom and...
0
by: linkswanted | last post by:
We are your trusted source. World Moving & Storage is bonded and licensed by the U.S. Department of Transportation and is one of the largest residential moving and corporate relocation company in...
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...
1
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: 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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.