Search results

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

Good morning all. Could anyone help with the following please. I am working in access 2007 and on my form I am entering in a date and time, in two separate control boxes. When I enter the control a small Date pane appears where I can then pick my date. When I next go to my Time control the same...

Aha that sounds like something a simpleton like me can understand ! now it's all clear...... very many thanks Bob

Hi Garypanic well .I split my d/b after copying. I note that the tables have been sent to c/:Docs etc. I also note that when looking at these tables in the d/b they have a little arrow on the side , I assume this relates to the relationship of the f/e and b/e. Q. I still have the tables in the...

Hi Bob many thanks for your info, Just to let you know that this is a simple d/b working off one machine. It's a club d/b which has 5 tables and about 12 forms etc. I am basically I am beginner with a little knowledge of VB, but simple stuff. I would not how how to "split" a d/b, in fact I am...

Many thanks for your quicko reply Trevor I give this a go, Rgds Nick