Search results

Hi all, i have searched here and google for this and found this https://www.access-programmers.co.uk/forums/threads/combo-box-selection-filters-results-in-subform.323733/ but not sure/how i can get it to work for my example attached, as it did filter one the role ( now its not dam thing ) but...

yeah correct

yes, is it meant to be or is that an issue, The DB is split in to BE and FE

Have a slight issue, seems have multiplie copies of the same DB appearing, see attached. Is this down to a dirty close down of the DB and can i just remove the excess and keep the one with out any numbers

quick update, did this on 18th but only had time to upload and post now. Have made a slight addition, which makes a point and click much nicer, a hand over icon. So when hover over point of interest it changes, thanks to the following for the code used https://nolongerset.com/usehand/ ( so far...

Update Time With help from you lovely people especially isladogs have managed to get the sound working on Battle Demo 2.2 so now when you take a swig of potion you get a nice little gulp noise, not much but think it adds and its ok it only plays once when pressed fell free to check out the...

Cheers, but i think its my version of access which is being the pain, as if i leave as you have very kindly layed out then i get the message but no noise, but if I am to put a break in and step through it then it plays

thanks i shall try that :)

But then how do i make it only play once, im guessing change the play code or the wait and also how do i make it play before the OK button in the message is pressed, is that based on where it comes in the code

thanks for that but i think it is my laptop ( well work laptop ) as the sound doesn't play either time on but will play in the folder

You say works but do you hear a sound then that plays just once as i did that and nothing so put a break in and steped into and played and played :( and played

@isladogs just got one question. what have i done wrong, i belive i have the code right ( the code is in the form final battle on potion button ) but no sound but before when i have steped into it has played ( and played and played until i close access ) would you mind helping out if you can...

thank you for the help, love your clock countdown, glad i had head phones when i put klaxon and ran it :)

yeah its Microsoft 365 ( that bad )

sorry for the DP but this is the example i have done as when they press use potion i would like it to make a sound rather then normal access boings and bleeps

well first concern was when i pasted it in the declarations went all ride line on me, as shown

I would like to put some sounds in access nd found this https://bytes.com/topic/access/insights/639316-how-play-sounds-access but not sure if thats the best way could some one look and maybe point in another direction cheers all

I'm just appreciative of the help, so thanks

any thoughts / feedback always welcome

I fixed and for once all by myself no google whoop the ol' brain does work from time to time. So what I did was add a calculating filed to items table and then had a text box on the page which when hits certain criteria locks the potion button, simple really See what you all think as always...