Yes/No Attach Graphic?!?!?!

krishill

Registered User.
Local time
Today, 16:19
Joined
Jun 16, 2003
Messages
16
I have been trying for DAYS to figure this one out!!!!

On the form in the attached database, at the bottom, left-hand side, there's a field for "Mgr Training". I need to know if there's ANY way (even close to what I want) for me to have a YES or NO option and IF YES, attach/insert a graphic (which would show on report) which is a signature and IF NO, insert the word "DRAFT"?

Also, if I can do this, can I make it a password-protected control? (I MIGHT be able to figure this part out if I could find how to get even close to what I want in the first part!).

I have a few other questions I'll be posting in other threads also. Thank you sooooo much for the help. I spent all day Thurs & Fri going thru ALL of these posts and several other sites'.

THANKS! Have a great day! Also, please let me know if my .zip file doesn't work! I've actually never zipped anything before, but seemed to be way easy!

Kris
 

Attachments

Save and post your db in an Access 97 version and I will look at it.
 
My first reaction is to make this field a yes/no check box

Then in the on open event of your report
If me.checkbox = true then
siginaturepic.visible = true
else
me.draft.visible = true
end if

will download and have a look
Dave
 
You have a lot of repeated fields that a subform would handle better, but you will fix that over time. Also another suggestion is dont use spaces or # in your table names. The spaces just cause headaches when writing VB and the # is regarded as a special key by access and can cause problem also.
Any way have a look at the attachment and good luck.
Dave
 

Attachments

Report won't open

Hi There! I didn't get an email telling me there were replies to this post!! I'm glad I came to check on it. Anyway, I've opened the .zip file you sent me and the database opened, but when I tried to open the report it tells me that it cant' do it, so to "Debug" or "End". I clicked Debug but I really have NO knowledge of VB so I have no idea what it's telling me or how to fix it!

Any ideas?

THanks so much guys for replying!

Also...would this be done on my REPORT or my FORM actually (having authorized mgr click yes or no)?
 

Users who are viewing this thread

Back
Top Bottom