I have a database of all the users (about 500) at our company. I have made a link that opens a HTML file with the floor plan when clicking on the user's location. Thats good.... but, what I would like is to make the location blink. Easier to find.
I have divided the floor plan with tables. (see screenshot)
I know that if I put <blink>.......<blink> the table blinks fine..... (you probably know the answer by now).
How do I go to make the proper table blink when I select it in the database?
You could make it blink by using the form's Timer event and the Timer Interval to however many seconds * 1000 you want it to blink. In the code, you'd set the fore/back color for whichever control you want to blink. I would make it subtle, as blinking can be annoying.
You could make it blink by using the form's Timer event and the Timer Interval to however many seconds * 1000 you want it to blink. In the code, you'd set the fore/back color for whichever control you want to blink. I would make it subtle, as blinking can be annoying.
Select "[Event Procedure]" in the form's OnTimer event, then click the "..." button next to it. In the procedure that comes up, put something like this:
Code:
Me.ControlName.Visible = Not Me.ControlName.Visible
That should give a blinking effect for whatever ControlName is. If you want to use colors instead of on/off, do something like this:
Code:
If Me.ControlName.ForeColor = RGB(200,0,0) Then
Me.ControlName.ForeColor = RGB(150,0,0)
Else
Me.ControlName.ForeColor = RGB(200,0,0)
End If
oh no no!! I probably didnt explain myself correctly!!!
I dont want the field in Access to blink or change color... I want the HTM file to open... (see screenshot floorplan at the top)... and desk of the user to blink or change color once it comes up.
This what I have till now...
when clicking on the button (Location of user) I have this in my code
Code:
Call Shell("c:\...\...\...\whatever.htm", 1)
Is there something in there that I could say.....
open whatever.htm file, search for user (or pc name in my case) pc-111wx.... and make it blink???
Here's 2 example of what the code looks like in the htm file (2 tables):
I don't think there's an easy way to make something blink in Internet Explorer, so I'd recommend just changing the color or other aspect of the PC you want highlighted. To accomplish this, you'll need to use Javascript or VBScript. I found an example for Javascript here. I modified that a little bit and saved the result in two HTML files you can have a look at in the zipped attachment in this post.
I don't think there's an easy way to make something blink in Internet Explorer, so I'd recommend just changing the color or other aspect of the PC you want highlighted. To accomplish this, you'll need to use Javascript or VBScript. I found an example for Javascript here. I modified that a little bit and saved the result in two HTML files you can have a look at in the zipped attachment in this post.
