Adding pictures into a database

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, I have long understood that "patience is a virtue"... posting
identical questions approximately an hour apart does not exhibit much
patience. Before I continue with my admonition, let me assure you that I
have responded to your question (albeit with additional admonitions) that
you asked about an hour after this one.

Now, to continue: the people who answer questions in this newsgroup are
volunteers -- no one pays us to answer newsgroup questions; even the
occasional Microsoft employee who drops in to answer questions is doing so
on their own time. Most of those volunteers work for a living, so expecting
someone to be sitting like a vulture ready to pounce on your question in the
middle of the workday is unreasonable. If you add to that the fact that
there might be some _suspicion_ that you are a student asking us to do
homework, and that you SHOUTED your question... both of which would cause
some very knowledgeable people to just go on to the next question, you may
get some idea why it might take a while for someone to read the question who
might be able and willing to reply.

Let me suggest that you visit the FAQ at
http://www.mvps.org/access/netiquette.htm for some good suggestions on
effective use of newsgroups. If you use newsgroups effectively, and are
civil and polite, you significantly increase your chance of getting useful
answers.

Larry Linson
Microsoft Access MVP

P.S. FYI, Access MVPs are NOT Microsoft employees. We have
been 'recognized' by Microsoft for our contribution to the
Microsoft software user community. For more information,
see http://mvp.support.microsoft.com.
 

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