A
Alex219267 via AccessMonster.com
I have an Access Database connected to an office network that tracks our
office computer assets etc.
I have a button click event that once clicked it grabs the computer netname
of an office PC, and then executes vba code to look and see when the computer
was last rebooted. The problem I am having is if the computer it is trying
to connect to is turned off, I am having to wait over 3 minutes before I get
a response telling me that the PC is unavailable.
My question is: Is there a way to program in VBA and have a set timer, so
that if data is not found within 30 seconds display X error in a display box?
THanks
office computer assets etc.
I have a button click event that once clicked it grabs the computer netname
of an office PC, and then executes vba code to look and see when the computer
was last rebooted. The problem I am having is if the computer it is trying
to connect to is turned off, I am having to wait over 3 minutes before I get
a response telling me that the PC is unavailable.
My question is: Is there a way to program in VBA and have a set timer, so
that if data is not found within 30 seconds display X error in a display box?
THanks