Turning off hourglass pointer when refreshing table?

[DaniLucas]

Hello,

I have a table that is linked to SharePoint with two columns. One is the ID, the other is a checkbox labeled "Activate." I also have a form for this table that, when "Activate" = -1, displays a msgbox to all users that an update is being pushed out (from the back end database) and they need to close and re-open their forms.

The timer is set to an interval of 1 second so every second it runs a DoCmd.RunCommand acCmdRefreshSharePointList command (so when the back end database finishes updating and the "Activate" field is set to 0, the message stops displaying)

My problem is, every second, when the refresh command is run, a hourglass pointer briefly displays. It is not typically a problem, just more of a real nuisance, but if there is a way to not use hourglass pointers when this happens (or at all in this database if that's an option) I would prefer to use that. I have tried DoCmd.Hourglass False but that hasn't worked for me yet.

Oh, just P.S., I am new to VB so I hate to ask, but painfully simple instruction is requested.

:banghead:

Thanks in advance!!

 

[Ranman256]

docmd.hourglass false

 

[DaniLucas]

I appreciate it, but I've tried that. No go.

docmd.hourglass false

 

[DaniLucas]

Okay, apparently the DoCmd.Hourglass False IS right, I just had it on the wrong line of code. I needed it to be the first line.

Thanks!