Drawing/Creating Table and Table Coordinates with Access 2002 VBA

[binny45]

Good Day

I have records with x, y, and z values. I'm trying to create a report or form that will show a graphical representation of these locations.

There are a number of layers, these are the value x (1 through 26). y and z are the axis for the table with each axis having 5 slots (so 26 of these 5X5 tables, one for each value of x).

I'm trying to have it so these tables get drawn, then based on the x, y and z values, color the resulting cell black, leaving the rest white. I've seen some Access Battleship games around and have been trying to find the code to see if I can get some inspiration for this task.

I'm really quite stumped. Anyone have any ideas, hints or suggestions?

[jforbes]

A lot of how you implement this will depend on how your data/table(s) is/are laid out. An easy way to knock this out is to

• have a single record with all twenty five (5x5) elements as separate fields, either Boolean or Integers.
• Then you could arrange the twenty-five fields on a Form in a grid and bind them to their corresponding Field in the Table.
• Then setup Conditional Formatting on the twenty-five fields where if it is one value the background would be black, and white if it is the other value.

Then all you would have to do is Load the Form and Filter to the record you would like to show and then Access would do all the heavy lifting for you.

[binny45]

Unfortunately it's multiple records. I'm looking at iterating through them to get the values. That being said, I'd completely forgotten about Conditional Formatting. Thanks!

[jforbes]

You could still use Conditional Formatting. Just use Unbound Controls and set their values through VBA and an OpenRecordSet.

Or if you are opening a RecordeSet in VBA, you can set the BackColor yourself.

If you get stuck while creating the code, post it and we will try to help you out.

[Rabbit]

How do you plan on representing a three dimensional object? As far as I'm aware, Access doesn't support transparency so you can't layer your objects in an x,y,z plane and have them be visible if there's something in "front" of it.