Loading Query

[data808]

I have an access form that has some buttons that open up queries when clicked on. The file is on a network drive and requires some load time to open the query up. I did notice the hourglass macro option listed in the actions drop down but when using this macro it does not seem to help. I need to have some kind of loading notification to the user so they know that the query is in progress of loading and not confuse them that its just not working at all when they click on the button. Does anyone know of an easy solution to this?

[June7]

Open forms or reports bound to the queries. This shows a 'working' cursor.

Users really shouldn't work directly with tables and queries.

[data808]

Sorry I wasn't clear. The form I have is not directly with the table. I made a separate access file for the form and the queries do not allow editing. The form is only to view data. I just want a load indicator. The cursor does have an hour glass for a couple seconds then vanishes back to the pointer cursor. The load time can take around 7 - 10 seconds so it looks like nothing is happening in that time that the hourglass vanishes to the time the datasheet finally appears.I tried the hourglass macro but it does not increase the time of the hourglass cursor at all. The form has a button that you click on to open the query that the table is on the network drive.

[June7]

I am confused. You say 'The form is only to view data.' But then you say you open a query. Don't open tables or queries. Open form bound to table or query.

You won't be able to get what you want when opening table or query.

[data808]

I have a form just for a table. Then I have a form for queries. The form for queries is linked to the table in another access file. The form for queries only has a bunch of buttons. When you click on these buttons, they do different queries. You click on one of the buttons and it will search the linked table for what I want it to do. Because I am opening the query through a button on the query form I made specifically for this purpose, I made it so I cannot edit any records once the datasheet pops up after the query has run from clicking on this button. My question is, can I have a loading indicator? When you click the button on the form I made for all these queries, the loading is slow because the file with the original table, is on the network. I guess you could say that its something like a frontend / backend kind of thing? All I want is some kind of loading indicator for the user to know that the query is in progress and to be patient because the datasheet will soon pop up. That's all.

[June7]

Access has a 'working' cursor that should show while the query is opening. At least I see one. The same one that shows while a form or report is opening.

[data808]

Yup I see that one too. Its just that it doesn't last long enough for the amount of time it takes to load since its pulling it from a network drive. You also could just say this isn't possible to do so we can close this thread already. Haha its ok if there isn't a solution for everything. You've already helped me with a lot of things.

[June7]

I think post 4 did say that. However, will amend that to say probably can't get it with a form or report either. Of course, I have been wrong before.