Alphabet linked to handsign

[linda12]

Here's a link to three different approaches: http://accdevel.tripod.com/imaging.htm

I use Access 2007 , Which approach must I follow??

[amrut]

See the attachment. I have added pictures only for letters "A" and "B".

[linda12]

Take advantage of the ControlSource property by having a table of images with a record for each image. Text field for the characters and Attachment field to hold the images. Bind form to the table, bind Image control to the Attachment field holding the images, then code in textbox KeyUp event filters the form records to display appropriate sign.

I will choose the ControlSource Property way for the time being . Could you please elaborate on how to use it . I am interested in all this , but I am a beginner.

[linda12]

See the attachment. I have added pictures only for letters "A" and "B".

Attachment seen . It shows some error when I type "A" in there. The error message is something like this 'The error is due to the fact that only pictures of two alphabets are available' . I cannot see any pictures there.

[amrut]

I type A or B, I can see the image.See the screenshotAre there two files A.jpg and B.jpg in the same folder as the db file ? You can try with any two images. Copy and paste them in the same folder as the database. Rename them as A.jpg and B.jpg.

[June7]

The bound Image control is simple.

Build table with two fields as described (text and attachment). Name them Character and Image. Populate the fields. Build form and set its RecordSource property to the table. Create textbox and image control. Set their ControlSource properties to the fields. Set the image control Visible property to No. Set the textbox KeyUp event property to [Event Procedure]. Click the ellipses (...) to open the VBA editor. Type code.

[linda12]

I am getting the same error message. The two files A.jpg and B.jpg are in the same folder (Hand_Sign.zip) as the db file . Do I need to extract it and then use??

Also, Please let me know how did you do that. I will try on my own and see if it works.
Thank you

[amrut]

You have to extract them before using

[linda12]

The bound Image control is simple.

Build table with two fields as described (text and attachment). Name them Character and Image. Populate the fields. Build form and set its RecordSource property to the table. Create textbox and image control. Set their ControlSource properties to the fields. Set the image control Visible property to No. Set the textbox KeyUp event property to [Event Procedure]. Click the ellipses (...) to open the VBA editor. Type code.

How to populate the image field in the table ??

[June7]

Yes, all 3 files must be extracted from the zip.

Works perfectly, didn't change a thing.

You can populate image from open table. Click the image field to open the attachment dialog, navigate to image you want.

[linda12]

You have to extract them before using

Its working now .Looks great !!.. Can I use it for writing words if I include all the 26 alphabets ??Let me know how did you do that.

[June7]

Just keep typing letters in the textbox.

[linda12]

You can populate image from open table. Click the image field to open the attachment dialog, navigate to image you want.

Done . Next , how do I create textbox and ImageControl????

[June7]

Drag controls from the Design tab of ribbon. This is basic Access functionality. Access Help has guidelines for building forms.

[linda12]

Now that I have inserted the image and the letters in the first step , must I create a textbox and Image control. ? If yes , must I insert the same text and image which I have already entered??