Recent content by NickNeville

Thanks Gemma I realise this, butI guess the only real way is to protect evertything but what a process that is ! This is why `I thought to make a separate module and put it somewhere Not obvious. Me being a new boy to this coding stuff it's a minefield .... but thanks anyway kind rgds nick

OK Ken Iv'e found it, shift when click on icon ! many thanks for your patience, this works a treat Nick

HI ken thanks for that, I have gone thru the tools options startup and yes that does seem a better idea to hise the options thankyou. But how can I reverse that ! as having unticked all the boxes I know don't have the option of tools etc .....sorry about this ! Nick

Hi ken could I ask you to give me a little more help with the "forms!myformname!text11" please. Do I open a class module or another type, do I add the code to the code like If me.forms!myformname!text11 text11 >31/05/2013 then docmd.quit end if end sub Or am I completely off course here...

thanks again Ken

Hiya Ken I have managed to locate and start a new module, I wondered if you could tell me how I refer to the Form which I want to use the module for. I have If me.text11 >31/05/2013 then docmd.quit end if end sub But I need to refer to the form where this is used , can you guide m please ...

many thanks Ken

Thanks for your quicko reply Ken, sorry to be a pain but could you tell me how. I'm a touch new to this code stuff but can follow info. Rgds Nick

Would anyone be able to tell me if it is possible to hide code within a database. I want to get the db to quit on a command but not want the code found. the db is not protected in any way or levels. Thankyou Nick

Thanks Pat rgds Nick

Yes the answer is there, It was a short date and should have been anything but ! many thanks indeed Rgds Nick

Could anyone tell me how to keep the date format in VB. I am trying to add a command which will happen after a certain date and enter the date UK style like 13/052012 but it always changes to 05/13/2012 and therefore will not work ! You help appreciated rgds Nick

Ok thanks Linq

Hi there linq could you advise me on how to suppress that small calendar within the text box please ? Nick

Many thanks your reply Yes it seems along way round, I think I'll try your idea and code as it sounds like a better way. thanks again Nick