Adding pictures - Please help!

F

Fred's

Hi there,
I have an acces database which have the following: Tables, queries,
form, report

TABLES:
"NCtbl" table which is my primary table which contain the following
fields and data type


FIELDS NAME DATA TYPE


SCAR ID: AutoNumber
SCAR Number: Text
Supplier Name: Text
Retek Number: Number
Problem Date: Date/Time
Season: Text
Division: Text
Order number: Text
Country: Text
Style: Text
Color1 Text
Color2 Text
Color3 Text
Color4 Text
Problem Code: Text
Problem Code1: Text
Problem Code2 Text
Problem Code3: Text
Problem Code4: Text
Problem Code5: Text
Problem Code6: Text
Problem Description: Memo
Impact: Text
Corrective Action: Text
Preventive Action: Text
Rework manhours: Text
Hourly rates: Text
Labor Cost: Text
Disposition: Text
Rework Instructions: Memo
SPP Coordinator: Text
Root Cause: Memo
Supplier Response: Memo
Response Code: Text
Response Date: Date/Time
Resp_code: Text
Reviewed by: Text
Review Date: Date/Time
Follow up History: Memo
Status: Text
Generate Scar: Yes/No
Sent to suppliers: Yes/No
Closed Date: Date/Time
Merchtype: Text
Verification date: Date/Time
Verified by: Text


And have make relationship from my NCtbl to each of the below table
(Joined type: 1)


Colortbl
Countrytbl
Dispositiontbl
Divisiontbl
LaborCosttbl
merchtbl
ProblemCodetbl
Responsetbl
Responsibilitytbl
ReviewedBytbl
Seasontbl
SPPContacttbl
Statustbl
Suppliertbl
VerifyBy


QUERY
initiatescar query


FORM
NCMainTblForm


I have create This form "NCMainTblForm" with my primary table "NCtbl"
for data entry
and a report called "Scar report" which gather the information trough
my query "initiatescar query"


BUT, NOW MY MANAGER ASK ME TO MAKE THE FOLLOWING BUT WITHOUT USING
OLE
OBJECT.


1. TO BE ABLE TO ADD PICTURES TO EACH SCAR ID RECORD
2. AND THE PICTURES NEED TO BE LINKED TO A SPECIFIC SCARD ID


COULD SOMEONE HELP ME, PLEASE SHOW ME STEP BY STEP.


THANK YOU VERUY MUCH!!
 
L

Larry Linson

Fred's said:
BUT, NOW MY MANAGER ASK ME TO MAKE
THE FOLLOWING BUT WITHOUT USING
OLE OBJECT.

It is much more common for _teachers_ to specify _how_ you should accomplish
an assignment than for _managers_ (but there are some who try to
_micromanage_). Still, if you aren't using Access 2007, which has solved
the problem of bloating for pictures in OLE Objects, it's good practice to
avoid them.
1. TO BE ABLE TO ADD PICTURES TO EACH
SCAR ID RECORD
2. AND THE PICTURES NEED TO BE LINKED
TO A SPECIFIC SCARD ID

COULD SOMEONE HELP ME, PLEASE SHOW
ME STEP BY STEP.

THANK YOU VERUY MUCH!!

All caps is considered "shouting" and is also considered "very impolite".
Please use your shift key. Alas, we are not here to do your development for
you as "showing you step by step" would be doing, but to help you obtain
information that will allow you to do it. In that spirit, I offer the
following (which includes examples that you can adapt to your own use,
provided you have invested a modicum of time and energy learning Access).

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top