Create shapes

[kit_sune]

I’m working on a home project right now, and I have a desire to add some shapes (that would be recolored based on the user’s preference) to a form. I’ve searched this forum, and google, and found that drawing in Access is very limited. Each time it was mentioned people asked “What do you want to do with the shapes?” so I’ll add that detail.

Basically, I want to create a “Character Sheet” type of form that would save a bunch of data to a table for a user’s character. But I also want the user to be able to modify the image of the character based on specified criteria. I don’t want to save these pictures as separate imported images. The plan was to save values for colors and character properties, then, the image would alter Via VBA based on those values.
I did see that "Circle" is available on a print procedure for Reports but that's not going to help me...
Does anyone know of a way? Please!!!
~Kit

 

[MarkK]

Modifying images is really hard even in software designed to modify images.
What "character property" would you save and then use VBA to alter?

 

[kit_sune]

What "character property" would you save and then use VBA to alter?

An easy way to illustrate an example of what could be possible is to imagine a smiley face.

You could have three circles – two for eyes which overlay a larger one for the head. My plan was to allow the user to save character traits, like eye color, to a table. I wanted to have VBA refer to the content of this table (Via SQL statement) and then alter the color of the eye circles.
Also, if the user specifies a male or female character then the position of the shapes could be relocated to reflect an appropriate image.
That's the concept I have in my head... I actually came up with it while hiking one day.

 

[MarkK]

Yeah, in Access you'd want to do that by just swapping out the images rather than actually modifying them directly, or write something in another language that performs the graphics changes and then control that with VBA. But neither Access nor VBA provides a drawing surface or tools to draw on things or update drawings.

 

[ChrisO]

Most things are possible in Access...

http://www.access-programmers.co.uk/forums/showthread.php?t=232752

Chris.

 

[kit_sune]

I have seen that website before in my searches...Your linked post makes it easier to understand how it works though. To use it I assume I will first have to install it. But it is late. I'll look into that tomorrow. Thanks a lot ChrisO

I'm off to bed.
~Kit