Search results

Your welcome and yeah I thought it needed some tunes just like classic Tetris hence why the semi russian theme of the songs and when you don't pick it defaults to Cossack ( I think B ) as most like ol' Tetris theme ( which is in fact a russian folk song )

last update I can think of adding all done now has Looping music, Next Shape coming, speed increase when you hit next level hope you all enjoy sorry I can't post it on here but the whole thing with the tunes is 13.2 MB ( and that's zipped ) AccessTris

updated with new name also new pause ( hit space to pause and un pause ) also level which will speed up after each level AccessTris

okay how is Accesstris

AcTris: A Tetris Clone in MS Access I am pleased to introduce AcTris, an innovative project that reimagines the classic Tetris game within the Microsoft Access environment. Currently in the development phase, AcTris captures the fundamental mechanics of Tetris, allowing players to engage in the...

first time seen that issue crop up and in regard to the mouse down yeah but then i just had duckduckgo AI chat repeat them for txt_5_n so on on up to the txt_10_n and ill check yours out, cheers

It does What you mean ?

AccessSweeper: Uncover the Fun! Back again, making DB's not dull and boring. My target this time was Minesweeper so please... Dive into the captivating world of AccessSweeper, the ultimate twist on the classic Minesweeper game, now designed for Microsoft Access! Challenge your mind and...

SELECT MID([RawData], INSTR(INSTR([RawData], 'UNITED KINGDOM') + 1, [RawData], 'UNITED KINGDOM') - 10, 8) AS ShipToPostCode FROM TempRawData WHERE TempRawData.RawData Is Not Null;

ok another similar question how would i chop the pdf when pasted into raw data so it got the address Sales Order From: DHL SUPPLY CHAIN DANES WAY NORTHAMPTONSHIRE CRICK NN6 7EX UNITED KINGDOM Ship To: BEST FOOD LOGISTICS (PRET A MANGER) RATTY'S LANE HODDESDON EN11 0RF UNITED KINGDOM Order...

yes as the data comes in a pdf and easiest way to get it in is copy and paste and then pick whats needed and @Gasman sorry, yes you are correct it does work. Many thanks all, closed ( for know ) :)

thanks for the reply which yes i didforget to say what to replace, but have some news still has the gap should i not also put 13 for the CRLF ?

how about tidying with INSERT INTO tblForCSV_main (OrderNo, ProductCode, Qty) SELECT Replace(Mid([RawData], InStr([RawData], "Booking Ref:") + 12, 12), ' ', '') AS BookingRef, Mid([RawData], InStr([RawData], "Pallets") + 21, 13) AS HSProductCode, Mid([RawData], InStr([RawData]...

ok so how do i try and clear that is it as you said with (trim)

ok have tried loading the page at work ( and looks like blocked booo ) have attached database and one pdf which is the raw data so steps open the PDF copy all ( ctrl + a ) and then paste into subform on the frm_Import just using ctl + v ( no paste special required ) then click Import and...

Cheers all. Not back in work till Friday so will give it all a look then But cheers

Hi All have exhasusted AI and google help so thought would actually ask some proper smart people ( me not included ) so i have the following SQL INSERT INTO tblForCSV_main ( OrderNo, ProductCode, Qty ) SELECT Mid([RawData], InStr([RawData], "Booking Ref:") + 12, 12) AS BookingRef...

updated as few bugs found when pressing buttons and it would alow a cell ( text box ) to take a blank entry and then break the game

last update 1.9 adds German flags so aware on which language you are doing fix so able to enter the letters any way in last 5 boxes and not have it finish on the 5th box straight away ( which previously did ) enjoy oh and last update shows how long words will last for :)

true so prob not best idea to follow was just a suggestion from one user but make a valid point, so think ill drop this avenue of thought