Search results

@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...

Quick update thanks to the very helpful people on here in particular @The_Doc_Man and his help in some VBA, have managed to update the battle system we now have potions ( at the minute unlimited ) but working on fixing that click the link below to go to my home page for the project and download...

attached is the WIP with the now working potion button ( well it works as in it gives health back but need to just fix the time you can use ) thanks all

Bloody Awesome, works a charm, now just got to fix it so cant keep spamming it cheers @The_Doc_Man

starts saying in the code Execute Query as string dont get as far as trying to run as not sure doing it right

have this code at moment CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = " & Me.Text133 & " WHERE [GoodGuy] = 'Player'" but i want to flip it so when user presses command it takes the health count and adds an arbitrary number of my choosing to it ( the number will be the same each...

hard to pick one so here my list of best/worst for the consoles I have and played Master System Best - Ghouls N Ghosts Worst - Micro Machines Game Gear Best - Sonic Chaos Worst - Joe Montana Football Mega Drive/Genesis Best - Quack Attack Worst - Hard Drivin Mega CD Best - Sonic CD Worst...

I swear I made a post about this back in 2020 when I started but seems not. probably started it but work got in the way as it does Anyways here is what have been working on (so far anyway) Its a modern take on a point n click adventure using access, which is handy as no need to build a...

works like a charm thanks a million

so would that be something like this again back of envlope thinking Select ID from tbl_Rouges, loop when EOF

works a charm but just one question I have which remains. how would i make it loop round as it present i have stuck with the arrow command boxes but when get to last record would like it to just move back to first character/rouge ? cheers CJ_London