I currently have a multi-user database that is used to track maintenance and data records for industrial tooling. The users of this database are not computer savvy individuals so all their actions are conducted through customized forms. In this database I have a table specific for "tooling notes" where the user can input valuable information on that specific tool for retrieval by others at a later date.
What I'm trying to add on is what i call a "critical Message" option where if that specific tooling note is deemed critical (checkbox on the entry form). It will pop up that specific message the next time someone pulls up the data for that specific tool. Now on to the specifics, The body of this message could be rather long so doing a simple message box wont do (I've already built the pop-up form, so that's not a problem) Also, if there are multiple critical messages for that tool it would need to automatically cycle through all of them before closing the pop-up form.
my approach is to write a function (so i can call it out specifically later) that takes the input from the user (Tool Number in this case) and outputs a customized SQL statement to run a query returning all the critical messages relevant for that tool number. But how do i get the results of that SQL to populate the text box on the Pop-up form? and how do i get it to cycle through each message automatically, a loop possibly?
For the Pro's out there, in your opinion is this the right method to go about this? is there a better way of doing this?
Thanks in advance!
What I'm trying to add on is what i call a "critical Message" option where if that specific tooling note is deemed critical (checkbox on the entry form). It will pop up that specific message the next time someone pulls up the data for that specific tool. Now on to the specifics, The body of this message could be rather long so doing a simple message box wont do (I've already built the pop-up form, so that's not a problem) Also, if there are multiple critical messages for that tool it would need to automatically cycle through all of them before closing the pop-up form.
my approach is to write a function (so i can call it out specifically later) that takes the input from the user (Tool Number in this case) and outputs a customized SQL statement to run a query returning all the critical messages relevant for that tool number. But how do i get the results of that SQL to populate the text box on the Pop-up form? and how do i get it to cycle through each message automatically, a loop possibly?
For the Pro's out there, in your opinion is this the right method to go about this? is there a better way of doing this?
Thanks in advance!