Search results

PlayerOneNamePlayerOneLetter1PlayerOneLetter2PlayerOneLetter3PlayerOneLetter4PlayerOneLetter5PlayerOneLetter6 KevinACCESP I would like the table to look like this when the query has ran the query in question called FirstRandomLetters Please see attached version :) reuploaded as had a light...

you mean

cross tab

Hi folks local nut case loose with access again and brain full of ideas, anyways Have this append query which works just dandy INSERT INTO PlayerOneTable ( PlayerOneLetters ) SELECT TOP 7 ScrabbleLettersToUse.Letter FROM ScrabbleLettersToUse WHERE (((ScrabbleLettersToUse.LetterUsed)=False))...

I did. See post #6

True and thanks for the info and ideas very much appreciated ( never to much help ) but I have solved it :)

Afraid so 😟

Cheers for that and yeah, at work don't have that access ( Boo ) but always good to have any way of investigating what occurred on a PC not locked down. So cheers for the input of info always appreciated :)

So i went down the code route and added this Me.WMPQuizVid.Visible = False Me.WMPQuizVid.URL = "" to my sub ( At the top in below code ) and now this works like a charm, cheers for the input @arnelgp about video not matching up Private Sub GetQuestion() Dim dbs As DAO.Database, rst...

suggestions ? how would i kill the video player when choise is made ? or Making the video shorter be better ?

OK so saying video length is to long or need wait for vid to finish before moving or add some code when user press a button then it kills the video player

So have had to use google drive as file is a bit bigger then here to upload but i have an issue not sure why it does and hoping that some one here can shed some light. The issue i have is when it gets to a question which has a video it seems to crash and I'm not sure the reason AWF Example -...

I have fixed it by adding Me.WMPQuizVid.uiMode = "none" 'trying to hide play back buttons so 'for video attempt If Not IsNull(rst![VideoAttached]) Then 'Some video is attached to the question 'Me.Question.Width = 4479 'Reduce the width of the question box so the video box...

Hi All So have managed to get videos to work in my quiz ( see attached example and vid file ) but now i have one follow up question how do you / or can you Hide the player buttons and file name ( file name not that important ) but would like it to hide the play stop buttons ( if possible of...

SORRY for the DP but i think i fixed it. I added Me.cmdJoker.Enabled = True Me.cmdJoker.Visible = False as can see here

Hi so another branch of question, i have tried to capture this but to no avail ( example attached ) issue i have is hwne user uses's the joker they get score double for all rather then one correct could you please have a look and point what have done wrong. Have tried making button not...

and i know, love a bit of office humour :) or perhaps as American cousins would spell hmor lol ( as they seemed scared of the letter U in words like honour or colour )

cheers all but i just created a second query to count number of times correct and joker played and had this result sent to a text box on results page and then added them together, maybe not the most elegant but it works :) and yes my spelling was not great but then I didn't notice till months...

Hi All I have the below query which is running fine but i want it to total ( some how ) so it should show 3 ( as when they use a joker they get a bonus if the answer was correct ) query ran query details so any help be grateful appreciated cheers all :)

as I'm aware of how to get it to work for one time as i have done for music on this other project of mine Access Point And Click Adventure but in this instance i want it to call the video in the same fashion as does for the pictures so based on the quiz round and question number