Search results

Thanks TessB...The Form update sounds like a good idea, this is where the end user "is supposed to enter the W" so if I can auto it on the form...problem will be solved...I'll have a go and update you accordingly.....Thanks again

I have table that is used to collect roster information the date field is formatted dddd/dd/mm/yyyy a second field requires the end user to insert W to designate the entry as a weekend date. The end user's often forget to insert the W (not functional) I need a way to code the field to look @...

Can't thank, you enough between all of the replies the cloud of confusion and much frustration has now evaporated...Applied the formatting in the SQL statement....tested the export....Hey presto....don't even have to tweak the export properties...YE HA

Can't thank you enough...it's working

I applied Properties - Format: ddmmyyyy to the field in query design. Query displays perfectly. Go to export query records to txt file. go to avanced tab of export spec's remove / as date separator, check allow leading zeros, check allow 4 digit date format etc etc. Exports as ,ddmmyyyy 0:00:00...

Thanks ghudson... I thought I had been Formating correctly? but I will try using this. When exporting where do I apply/attach the Format()?

Hi I have 2003 Access Dbase from which some of the fields must be exported as comma deliminated txt and email to a repository. I need the end user to see DOB, date format dd/mm/yyyy (15/06/1959) but it must be exported as ,15061959,Town,State....etc Now I have formatted Table, Form & Query...

This might work try setting the criteria to Like "null"

Thanks for the code Thanks Byte Myzer where do I attach the code Query? Table? Form? property

Manny Thanks Thank you I will do that, greatly appreciate the lead

Hi all: I have two fields family_name & given_name.I need to extract 2nd, 3rd & 5th letters of family_name and 2nd & 3rd letters of given_name into text field called link_key. Where names do not have suffient letters for extraction then the numeral 2 is used as a replacement. Currently entering...

Hi all: MS Access 2003. I have two text fields family_name and given_name I need to extract 1st, 2nd & 5th letter of family_name along with 2nd & 3rd letter of given_name to form a link_key field. If either name has insufficient letters the missing letter is replaced by the numeral 2. Does...