Search results

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

Aim is duplicate letter in the word so as stated in the game it would show blue.

picked it as it had double letters and first one i thought off and cheers for ideas on solution

in the attached i have tried ( but removed also ) to make so if the letter of the word is twice it would hopefully colour the square blue i tried googling it but the fixes they said didn't work talked abut dictionary functions in access just want a nice simple fi and am sure this is the...

i like it and most of all it works so cheers :)

Genius cheers, but then am not sure how i had it working previously then before i went and broke it. cheers all and thanks

Okay what did you do that works perfect What did i miss :(

Sorry maybe me not being very clear please see this vid of issue Video of Issue

you have to go from the start of the quiz, just spam one of the buttons till get to the end and then be at the results page which says how many you got in how many seconds, and then the reval will show which you got right and which you didnt ( well it should ) but its not so start with form Start

can some one look at the attached and answer my question, which is. When you get to the end of the quiz and click reveal it should show how you did i.e. wrong and correct but for some reason it is not populating and I cant figure out the reason why cheers all

1.5d -Updates Added Spanish ( again colleague request ) Removed the back button once in language to stop some ol cheats Increased Romanian word count

ok fixed sorry all