Query Check

[mjenkinson05]

I have a query that will check a stock table and show a list of stock that is running low or run out.

What i would like is for the system to check this query at the start and if its populated then to show a message.
ive looked everywhere for a solution but cant find one, wondered if any one here had an idea.

Thanks

 

[cjard]

Uhm.. What are you asking? How to make an operation run at startup? Of what? the app or the system? Can you ask your question more specifically?

 

[mjenkinson05]

sorry at the startup of the app.
what i would like is when the app starts, and the splash has closed, to open the query, see if its populated, then close it again, and if it is populated, to display a message, and if its not, obviously do nothing.

 

[Arg81]

Are you using a menu, or a main form for navigation?

You'd simply have the query attached to that form.

Your code would be along the lines of;

me.tableadapter.fill(me.dataset.datatable)
If me.dataset.datatable.rows.count > 0 Then
messagebox.show("Put your message here")
End If

 

[cjard]

see attached