Recent content by stewartrose

Hi Keith, Sounds very logical, that you for the help and advice, and thanks to everyone else.... Best regards from Alan

Hi Keith, Mmmm very impressed, I can see that you have taken the data and filtered it then paste it into a new feild, I hope my understanding is correct using NewPreviewText: Right([PreviewText],Len([PreviewText])-2) now this assumes the data is awalys in the same place (I HOPE) how can you do...

Hi Keith, Mmmm very impressed, I can see that you have taken the data and filtered it then paste it into a new feild, I hope my understanding is correct using NewPreviewText: Right([PreviewText],Len([PreviewText])-2) now this assumes the data is awalys in the same place (I HOPE) how can you do...

Morning RuralGuy, Thank you for the reply, with the wind blowing from the right direction, and the sun shinning from the north, I hope this upload worked never done this before.. Thank you from Alan

Hi RuralGuy, Yes I have a backup, learnt that leasson years ago at great expence... What would you like me to try, or would you like me to email a database with a couple of records in it... All the best from Alan

Hi RuralGuy, Well I think I am moving forward, I put you code in a module and named it basFunctions, then opened up a query in design mode added the feilds for the table used in this case Articles, then selected Query from top menu, and selected SQL Specific, then Data Definition, added UPDATE...

Hi RuralGuy, This may be a pain, but from the query side of things I have no idea what to do never done anything like this before, if you have the time i would be glad of a step by step guide please, but only if you have time... All the best from Alan

Hi Team, The Feild is a Blog with some 300 words in it, and 21000 records, which I want to export into a tab delimitered file to export into a mysql database. The Character that you see when you open the access database is 2 square boxes but the center of the box is white, and when I try to...

Good Morning Team, I have a little problem, I have a access database that appears to have square boxs in some of the feilds, I presume these are Cr/lf, how the hell do I get rid of them please.. Best regards from Alan

Tables, Hi Pat, I have to add all the other data in for the othe Countys, but my problem is to get the form to store the correct infoformation in search database, and also use all the other inputs from search into the form. Best regards from Alan

Multiple Tables Hi Thank you for your reply, I have to say I am a total newbie to all of this, I am trying my best to learn, but it is hard at my age, so please forgive me. I have changed the structure as you said, and i found a form, that i have modified to use my tables County and State...

Multiple Tables Hi Sorry, Have a read of this, and you will understand better, thank you http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52897 Best regards from Alan

Hi Rich, could you look at this for me please and tell me where I am going wrong it is driving me mad. I cannot get the right values to show in County. Best regards from Alan

Multiple Tables Hi, Interesting fact, if the County-Num has more than one number of the same value eg: 1 Luce 1 Iron Then you cant make the Num feild a primary key. Best regards from Alan

Hi Rich, Yes I have been through them all, maybe I am missing something very basic, I have created the database as suggested above county has County-Num and County in, States has States-Num and States in, and Junction has Sates-Num and county-Num in, both other database has the data in them...