Multiple Alert forms

[Pauldohert]

I have a series of Alert screens - just forms which show the user that certain conditions are/aren't met.

Currently I have them opening on the start of the application - open Dialog and the Cancel = true in the open event if there is not records.

Potentially 4 differant Alert screens could open one after the other when the application is opened. Which could becaome annoying if the user has logged on to do something in particular.

Can anyone tell me a better way of alerting the user about multple things.

I am using cancel = true hoping that I am only running the query for each form once. If I use another method rather than opening each alert form to alert the user will I have to run the query twice - Ie once to check whether the Alert records exist then agian when I open the form

I have thought of putting all alerts on multiple pages of one form - but have dismissed this idea.


THanks

 

[Fizzio]

Your idea of one alert form seems the most inviting.

How about placing all of your alerts on one form but in one textbox / continuous form where they could press a button / check a tickbox to dismiss the alert.

You could easily dynamically create this form using VBA and a locally held Alert Table (Providing your DB is split into multiple FE with one BE)

Just a thought.

 

[Pauldohert]

Each individaul alert form has a dynamic recordsource - changed using the opening args - how would I do this when I don't open them individually - just as subforms??

Thanks!!