NumberNest - Sudoku in Spirit

[murray83]

Another Access DB which does not what it was maybe designed for

This time a little Sudoku game, levels of difficulty from Very Easy, Easy, Medium and Hard. Also hint option for each level ( not unlimited and amount have depends on level picked )

hope you like an enjoy, any suggestions are always welcome

 

[murray83]

slight update now has a hidden ribbon on load and clear

 

[MajP]

I added a right click menu making it faster and easier to enter/clear a cell.

 

[murray83]

Clear cell I get. But to enter you can just click and type

I'll have a look at work later though

 

[murray83]

Final update by me ( unless someone finds a bad bug ) but have had time to add following

Update Info: Once you complete a puzzle, you’ll receive a notification, and your completion time will be saved, along with number of hints used. This feature allows you to track how long it took you to solve each puzzle and even set a target for others (though that’s not the main goal of this update).

Also the clear button before complete will remove your attempt so no zero records showing

 

[JTrilloJ]

Hi Murray:Excellent work. Congratulations.
When you run a test without using hints, an error is generated in the UPDATE SQL at the end of the game.
Private Sub LeaderBoardSave()
Line >> DoCmd.RunSQL sql
That doesn't detract from the overall package, which is good. If I find anything, I'll let you know. Best regards >> JTJ

 

[murray83]

Guessing because if no hints that text box would be null

I'll have a look.

And thanks for the compliments

 

[murray83]

fixed it just changed the following

from
hintValue = Nz(Me.txtClickCount.Value, "") ' Default to 0 if txtClickCount is empty

and to this
hintValue = Nz(Me.txtClickCount.Value, 0) ' Default to 0 if txtClickCount is empty

 

[murray83]

Okay no more

One colleague/user wanted a pause so if they had to leave desk it would not impact there time

 

[murray83]

Hey all

Quick update as colleague managed to find a few loopholes/glitches I had missed as I just tested it normally

So now limit to one number in each box, the hint's now should work as before they would put numbers but was in the incorrect location so couldn't finish

and changed the number of hints for v easy to match easy so hints allowed goes 15, 15, 10 and 5 for each level