Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Student I-Card Printing Using Access ,VB and Crystal Report 8.5 and ADO

Posted on 2006-05-31
Medium Priority
Last Modified: 2008-03-06
Respected Sir/Madam,

I am developing an application using Visual Basic 6.0 and MS-Access 2000, for Student I-Card Printing Using Crystal Report 8.5. I am accepting all Information from user including Student's Photo (May be JPG or BMP Format). I am not able to save and retrieve the Photo of student. I am using ADO and SQL To Insert and Update Data. Also the Photo should be printed in Crystal Report. Please Help me as the Project deadline is on Saturday 3rd June 2006.
Please do the needful ASAP.
Sandeep Bhambure
Question by:SandeepBhambure
1 Comment
LVL 58

Accepted Solution

harfang earned 1500 total points
ID: 16803313
Hello SandeepBhambure

You can store the files in a special folder, and rename them using the student's ID numbers (that is what I would do) or include them as binary objects in your database. That means you will have to write them out to a temporary folder each time you need them.

Here are two links for that method:

ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)

Jamie's Software - Access Articles
Handling Images with Microsoft® Access

Good luck!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question