Access problem - can anyone help please

[mudskipper]

Put the kettle on love

Lisa - I like kittens too and not sure but you might also get a problem if you've got ' or " in Me.Text26.

WZS.

Try

Replace(Me.Text26, "'", "''")

[TheFaQQer]

Don't worry, I am a boy (PM me for proof, I have pictures of parts of me that I don't show on here ) but what you should be doing is using Stored Procedures in Oracle RAC in a RISC virtual environment, right lads?

Access is for lasses, poufs and NLUK.

RAC is sooooo last year - you should get a Grid Control Architect in for something like this

[LisaContractorUmbrella]

Put the kettle on love

Lisa - I like kittens too and not sure but you might also get a problem if you've got ' or " in Me.Text26.

Yes, I am also a kitten lover (unless I've missed something and it's a euphemism for something dodgy) and thanks for your help - is all sussed now and my sanity (such as it is) is restored

[LisaContractorUmbrella]

Don't worry, I am a boy (PM me for proof, I have pictures of parts of me that I don't show on here ) but what you should be doing is using Stored Procedures in Oracle RAC in a RISC virtual environment, right lads?

Access is for lasses, poufs and NLUK.

Thanks for the offer Stek but you're ok - the pictures are probably not on here for a jolly good reason As for the rest of your message - huh?????

How can you be sexist and NLUKist about software?