Forms, linked images with a twist

[rotabug]

Hi People
I'm new to this forum and have just learnt to link images (for example)

I have a problem I need to create a database for my boss. We're a hotel management school with students living onsite like a real hotel scenario.

So far i have created a database with linked images (of each room) but i need to add buttons to the database, say to represent a light or desk or computer (basically every thing in the room that can be damaged)

What (is supposed to, or) needs to happen, is when there is a fault the lecturer/student, whoever.. chooses their room from the list then clicks on the picture of say the light above the bed to inform us its broken, maintenance guy then gets an email, fixes it and deselects it, the boss gets an email to say job done.

attached is a sample room pic

Is this sounding impossible or just very very expensive???
I would love any advice, info, input that you may have.

Thank you
Ross.

 

[vbaInet]

Welcome rotabug.

What you're trying to do sounds EXPENSIVE (just like you said) . It's the sort of database an expert would embark on. It's going to be a very steep learning curve if you want all those flashy effects.

 

[rotabug]

Hi there, and thanks for the fast response yeah i actually created a very plain and basic version which was just all tick boxes to represent boken or fixed but he (the boss) was not happy with it, he wanted a picture that he could click... Why i'm not sure? my one kinda worked.

so yeah any advice would be awesome

 

[vbaInet]

Fine things cost money If your boss wants it now then he/she should be willing to pay an expert to get that sorted.

However, this could be a really good project for you. There are lots of posts on this forum talking about images and the like. Use the search tool. Also check out the Samples Databases, Code Repository sections. You may find something

 

[rotabug]

Cool, i will do, thanks for your help

 

[vbaInet]

No worries. Good luck with the project. If you have specific questions or are unsure how to accomplish a specific task, just post a quick question.

 

[Zigzag]

My approach (in simple terms) to this would be as follows...

1, When the room has been selected load an unbound object with the picture/image of the room.
2, Using the mouse move event capture the X,Y Position and compare it to pre set zones for different items around the room (you will need to build another one to many table for this)
3, Using the mouse click event in combination with the above identify the item and create a work order for the repair.

Garry

 

[rotabug]

Hey Thanks Garry

 

[Zigzag]

Your welcome.

 

[ChrisO]

Attached is something with which to play.

With some work the relevant items could be images but it may suffice as is.

Regards,
Chris.

 

[vbaInet]

Attached is something with which to play.

With some work the relevant items could be images but it may suffice as is.

Regards,
Chris.

Very nice Chris. I like the movement and the dynamic changes in dimensions. Seems almost seamless.

What bits did you improve upon?

 

[ChrisO]

Well, it took a few passes at re-writing it to improve readability (not that it’s all that readable now). So I included the backup/restore, mouse over, double click details and such like while I was at it.

One of the things that surprised me about that is that it is written in A97 with what seems to be full blown WithEvents. It was started in A97 but I don’t think Microsoft finished it till A2K.

Thinking about the OP’s question a ‘chair’ could become a ‘fault condition’ where the fault condition is dragged and dropped on something else. Then details of the fault could be entered. When the job is done, the fault details could be cleared and dragged back to the parking bay.

But I don’t know if that would be flash enough for the boss.

 

[rotabug]

yeah thanks for your help Chris, he is a point and click kinda guy... i'll keep trying

 

[vbaInet]

I would imagine most of the events that were released in 2000 and designed for that version were actually written (but not fully tested and/or optimised) prior to 97. But it's amazing the sort of event handlers that are included in 97.

In relation to the OP's question from what you've said, layout wise it would be good to have a static map designed by an admin. To the right would be a drop off zone for repairs and logging faults and below that a combo box listing the different possible faults. Below the combo would be a label that identifies the item that was dropped onto the drop off zone displaying the name of the item dropped.

 

[ChrisO]

Perhaps they could also get the architects to supply a black and white image of the different floor plans and use those images as the background image for the Form. The images could have a blank section left or right for the parking bay. If the image is zoomed it would be to scale.

 

[vbaInet]

Well, there you go rotabug. Lots of ideas for you to get started on your amazing project

 

[rotabug]

Thanks Guys

 

[vbaInet]

You're welcome. Will be good to see your final work-of-art

Enjoy!