Please help me!

[Cozzy]

Hello, I work in a college and I have completed Access 2007 level 1-4 and about to complete the VBA course, Basically what I want is to create is a form with floor plans of my college where you can click on a computer and it will show you they machine name/location etc in a sub query and also be able to click a machine name and it show highlight on the floor plan?? Eventually I need to be able to merge some programing that lets us know what machines are logged on with the database to show available machines on each floor? I have all location/machine name and floors stored in tables already. sorry if this is a bit confusing this is my first thread

 

[JamesMcS]

Welcome to AWF - What exactly is it you're after? You've described your project but what is it you're having trouble with?

 

[Cozzy]

sorry, basically peoples Ideas on the easiest way to achive this if possible, I have created the Floor Plans as .jpg but problem being is that they don't have the computers on the plan so need to insert them (guessing using object frame?) and using VBA to highlight them? like I say I have created databases but nothing this complicated.

anyway if need be I can break this down even more if need be.

many thanks

 

[JamesMcS]

Nah you should be alright. Have a form with the floor plan as a picture object, then all you'd need to do is have command buttons wherever there's a PC (you can make them invisible and stick them on top of a picture of a PC if you like), and in the on click event of that button put whatever code you need in, and robert's your father's brother.

 

[Cozzy]

cheers mate, having a little play now will let you know how it goes and think I'll have a better understanding after my VBA training this week.

 

[JamesMcS]

Good luck! Post back with problemos

 

[Cozzy]

right started to do this (which I regret now), but I was wondering if there is anyway of doing a select case statement so that if the text in a text box matches in code then the colour of a image changes to show it highlighted on the "map" form.

I got it working with

Private sub cmdfind_click()
if desc like "*096*" then
me!imgA26_1.backcolor = VBRed
end sub

"Desc" is the names of the computer's in the area (on the form) and "imgA26_1" is the image that represents the the computer in the location

Any help would be a help