jorge.miranda
New member
- Local time
- Today, 08:25
- Joined
- Sep 15, 2013
- Messages
- 4
Hi, i need assistance with a problem i just can't discramble:
I have to tables:
Table 1 contains "cases picked"
Table 2 contains "cases required"
i have a query with info populated from those 2 tables:
field "results" shows the results of this calculation:
"cases required"-"cases picked"="results"
In this query I have a conditional format stating: If true, displays text "ok" and the field will be green, if false, displays text "alert" and the field will be red.
Then I have this query in a subform (a form within another form), now:
I would like to have a code or a formula for this query, where it would play a sound if (and only in this case) the value of "cases picked" is bigger than the value in "cases required"
This is how it works, you open the main form, start using a barcode scanner to scan cases, everytime you scan each case, the subform is refreshed and adds cases, and shows results, and shows how many cases you are missing or how many cases you are over, but this is only in the screen, i would like to have a sound in this subform, so in case you pick more cases than required, a loud sound is played as an alert, i still can't figure out where to put the solution, if as a formula in the query, or a code in the subform, please, i've been reading all over the cloud and can't find the answer, i will appreciate any help, thanks in advance!
I have to tables:
Table 1 contains "cases picked"
Table 2 contains "cases required"
i have a query with info populated from those 2 tables:
field "results" shows the results of this calculation:
"cases required"-"cases picked"="results"
In this query I have a conditional format stating: If true, displays text "ok" and the field will be green, if false, displays text "alert" and the field will be red.
Then I have this query in a subform (a form within another form), now:
I would like to have a code or a formula for this query, where it would play a sound if (and only in this case) the value of "cases picked" is bigger than the value in "cases required"
This is how it works, you open the main form, start using a barcode scanner to scan cases, everytime you scan each case, the subform is refreshed and adds cases, and shows results, and shows how many cases you are missing or how many cases you are over, but this is only in the screen, i would like to have a sound in this subform, so in case you pick more cases than required, a loud sound is played as an alert, i still can't figure out where to put the solution, if as a formula in the query, or a code in the subform, please, i've been reading all over the cloud and can't find the answer, i will appreciate any help, thanks in advance!