Display simultaneous records on a form

[DaveB]

Hi there,

Hoping someone can help with the following issue:

I have a form which displays an image on the screen by using an x, y coordinate stored in the record.

Each record has an [Xcoord] and [Ycoord] value so on the form it will display an image (image23) by using the 'left' and 'top' functions to emulate the x and y co-ordinates. like so:

Private Sub Form_Current()
Me.image23.Left = Me.xcoord
Me.image23.Top = Me.ycoord

This works fine and scrolling through the records shows the different locations of the various records.

But what I would like to do is show all of them at the same time! so you can see all of the records in their relevant co-ordinates.

I hope I have explained it well enough and that makes sense. Any help would be much appreciated.

 

[KenHigg]

If you are trying to do this with a continuous form I think you're out of luck.

 

[DaveB]

yeah I was afraid that might be the answer. I have tried it with a continuous form but that's not what I'm after. I tried a split form as well and that was close as it did display each record as I selected it in the table view, but again that wasn't suitable as it was a manual process, I was after an immediate display of all records. I'm not overly hopeful to be honest but thought I would ask. You never know eh.

 

[DCrake]

Couple of things

1 what are the images of
2 how are you obtaining the images (linked v embedded)
3 are they all the same size
4 why do they all appear in different places on the form
5 does the placement of the image not interfeer with other objects on the form

Well more than a couple.

David

 

[DaveB]

OK,

The image is of a small building, appearing on an overhead map. It's an embedded image and is used is to represent a location on the map. there is only one image on the form, the different records show the image in different locations.

The [xcoords] and [ycoords] values are actually determined on a different form (although very similar in appearance) by clicking on the map and the x,y coordinates being allocated to that record so they wont interfer with any other objects on the form.

Viewing the indivual images as you scroll the records works a treat, the small building appears on the map in the different acreas representing the location.

Thanks for the prompt replies to this.

 

[DCrake]

So what you are doing is saying "You are here..." by overlaying an image over a larger image. Is that correct. Can you send a screen dump?

David

 

[KenHigg]

So what you are doing is saying "You are here..." by overlaying an image over a larger image. Is that correct. Can you send a screen dump?

David

I think if he's trying to do this in a continuous form or table view he's out of luck.

 

[DCrake]

Yes Ken, I am of the same opinion however I am interested in seing his imagery now.

David

 

[dcb]

But what I would like to do is show all of them at the same time! so you can see all of the records in their relevant co-ordinates.

From what I can tell you have one image that is the map and you place the corr building where it needs to go: This then works!

All records:
So why not use RecordsetClone and Loop through all using the same code for placement?

 

[DaveB]

Here's a small animated gif of the screen I am working on. As you can see on the list to the right it has the different users. This only test data right now so will grow longer. There are x,y coordinates attached to each user which is displayed in the top right (but will be hidden in final version) and as you select the user it will display the location image.

http://picasion.com/pic13/d69a6cf36b070aa7aef49ad625b8fd14.gif

@dcb. The 'recordsetclone' options certainly sounds like it might be useful, but I'm not seeing where that is applied. Can you please point me in the right direction.

Thanks again everyone for the feeback and help.

 

[KenHigg]

Yes Ken, I am of the same opinion however I am interested in seing his imagery now.

David

Oh, sorry. And his map / image thing is pretty cool. Never seen anything like that before in access...

 

[DaveB]

Oh, sorry. And his map / image thing is pretty cool. Never seen anything like that before in access...

Thanks KenHigg, appreciate the compliment. It's a little project I've been working on for a couple of weeks in my spare time and so far this is the only thing I've not been able to do which I would like to.

 

[DCrake]

From what I can visualise an embedded image (which should be linked) is placed in a picture/image control on the main form, then a further image (the flag) is initially invisible is placed in a location on the form. When the user selects a record the event procedure picks up the x and y (top and left) then re positions the control accordingly and makes the image/picture visible.

The placement of the flag is dependant on the accurate position of the main graphic, so if it was on a continious form then the repeating image would essentially have different coordinates thus making it impossible to postion the flag in the right place for the current record.

The only way I think that this could be achieved would be to have a bit map viewer that had static images of the location within the main overhead. I have a very good example of a bit map viewer in VB that also has zooming caperbilities. I may look at converting it to Access if I get the time or the inclination.

David

 

[KenHigg]

Based on your sample images, if you simply want to show more than one overlay image at a time could you have x number of copies of the overlay image and then make them visible and positioned as needed?

 

[DaveB]

From what I can visualise an embedded image (which should be linked) is placed in a picture/image control on the main form, then a further image (the flag) is initially invisible is placed in a location on the form. When the user selects a record the event procedure picks up the x and y (top and left) then re positions the control accordingly and makes the image/picture visible.

The placement of the flag is dependant on the accurate position of the main graphic, so if it was on a continious form then the repeating image would essentially have different coordinates thus making it impossible to postion the flag in the right place for the current record.

The only way I think that this could be achieved would be to have a bit map viewer that had static images of the location within the main overhead. I have a very good example of a bit map viewer in VB that also has zooming caperbilities. I may look at converting it to Access if I get the time or the inclination.

David

That is essentially correct yes. The continuous forms doesn't work as I want the image to remain static on the screen. I've got it working exactly as I want with the individual locations, you select one and it shows it on the map to the left, but I would like it to show all of them at the same time to give an overview of who is in what area.

Kenn,
The idea of multiple images wouldn't work as the list of users can grow, and also the code I am using would need to reference a different image so for each user so it wouldn't work. As it is it reference just the one image which gets moved around accordingly.

I'm not around for the rest of the day now so won't be posting any more comments today but please feel free to continue with your suggestions as it is most appreciated.

Thanks.
Dave