Search results

Thanks again.. The DB is in the early stages of design (its actually a complete revamp of an old one) so whilst there are not that many fields at the moment as the design goes on this thread and the help you guys have given will come in very very handy. Paul

Thank you and everyone else so much for your time. and what makes is better is that I actually understand what the code means now and can relate to it. Paul

sorry for being a right pain in the ... !! I actually understand what you mean by putting 2 in the tag (so if I wanted it to be upper case i would put 3 in it instead?) But I don't unserdstand what you mean by "In your loop" Sorry ! I do really appriciate your patience and help

Thanks for the reply.. I will only need to convert text in the details section as the form (s) will all have buttons and form title's ect in the header and footer bits. So If I am correct in understadning you I would put the code in the BeforeUpdate box on the Details Section? As to what I am...

This is all really interetesting and helpful stuff ! Would mind explaining waht you have written in more basic terms as I am really new to Vb - thanks

Ha Ha - thank you so much for the explanation it's always good to learn and understanding things and trust me I have a lot to learn ! Thanks again Paul

Thanks Smig Just for confirmation where you have put 'ctl name' I'm asumming you mean the name of the field e.g. FirstName, Occupation ect...? Paul

Many thanks David for the reply. I think I will stay with the basic strConv for now as in reality it is 1- working fine and 2-there are not that many fields that need converting at the present time. but I will certainly refere back to this post in the coming weeks i'm sure !! Thanks again Paul

Many thanks smig for the reply,

scrub that so sorry !! I did not clear out the old lost focus event it works perfectly Thanks very much

many thanks John for the reply - that works apart from one small glitch .. the message comes up the first time I try and leave the Firstname field but if i then still don't enter anything it doesnt come up and stops the strconv code bit any ideas? Paul

Hi Guys I have a field "First Name" that is required on my bound form. If the field is left empty i get the default error message ... you must enter a value blah blah blah... Firstly is there a way to change this msg to something more user friendly? and secondly I also have some strConv code...

Many thanks again I am aware of ths issues of case changing names like Mc ect . I have found a far many suggestions on code to sort this but each is not wothout it's problems I think I will address this issue at a lter date but for now its just stayinng "simple" !! Thanks again for your time

Many thanks David, thats pretty much what I am using it for although I am using it on the Lost Focus so it updates the "screen" as the users see's it. I asssuming this is ok?

Hi David thanks for the reply. I not 100% sure what you mean by naming conventions but I think it is the actual name of the field? If so I have just called them FirstName, Surname, OccupationType... ect ect. does this cause problems for me? As to the Strconv main reason for my original...

Hi Guys could someone advise me if it is possible to string convert certain fields in a form when the field loses the focus? I know how to do it for induvidual fields but wondered if it was possible to have 1 bit of code that will pickup the text fields on a whole form for example and exclude...

Thanks you John works a charm extacly what I needed Paul

Hi guys Could someone please advise what I am doing wrong here. On my Personal Details Form I have various fields including Date Of birth, Mobile Tel Number and Home Tel Number. I have a short date input mask for the dates of birth I have a Telephone Mask for both the Number fields I have...

Thats great Im onto the design of the tables / forms now I've gone for Autonumber as the key ! - hopefully it will be plain sailing Is it ok if I need to post back on this topic? Thanks again for all the advice.

Thanks guys very much for the responses .. The issue relating to what shoud be the primary key is a real difficult one to resolve for me. basically we have nurses , medics working at various locations throughout the day. they only deal with "patients" if the patients suffers an injury or...