I need to show the app is working so lock the client until the results are back.
Are u refering to wait cursor?
'chk the documentation for actual code Waitcursor true 'do your stuff Waitcursor false
Check this post. It refers to a animated gif you can display: Recommendation of Spinner Control