Search results for query: *

OK thanks guy's it finally clicked. I'm a dork. Bob I changed the table name but never changed the field name. Doh. Trouble is I was trying to understand what was actually happening.-----No wonder I couldn’t work it out. Now I understand and have learnt a heck of a lot about SQL in trying to...

Thanks for the responses guy's but I'm still in trouble. I've been working on this for days now and it's realy beging to bug me Can't get any of these to work. prob just me being thick. Bob Scriver I would like to go with your idea but the SQL doesn't go. The bit I'm confused on is SELECT...

Ok heres a good one. I'ts probably just me being blond I'm sur there is a simple answer. I have a table with an alphanumeric field that I need to sort.The field is formated as text. There can be between one and six numbers leading the data. There can also be zero to three letters trailing the...

Hiya AceMan I'm fine; been away for a while though. Thanks for the thought and yes I am still interested but happy to see the thread develope where it will.So don't mind me. I resolved this prob long ago. It was purley for looks (I'm Vain like that) I left the main sceen maximised and either...

Yes thanks I think I get the idea. Thanks for your help. I'll go and read up in help now I know what to look for Cheers

Thanks Yes the numbers can be re-used for different account types, that gives me a total of 999 accounts for each type, 8000 possible over half of them corporate (some of our large corporate's have .............. at an avg..... I've just run the numbers, if I ever reach even half capacity I'm...

We use an account number that consists of 3 different elements. 1)A four leter code that indicates the type of account (these are finite and so are listed in their own table) 2)A 3 digit number (has leading zero's) 3)A text code that is used as a booking code (this is a code generated from the...

Thank you BSman for your reply. This is what is writen in the lookup. SELECT [ID] AS xyz_ID_xyz, [Home Address] & ', ' & [Post Town] & ', ' & [County] AS xyz_DispExpr_xyz, [Home Address], [Post Town], [County] FROM tblHomeAddress ORDER BY [Home Address], [Post Town], [County]; Can't see owt...

I have a wierd problem I think the route of the problem is in the design of a lookup query but I am unsure. I have a tbl (Table1) that has a number of lookups to other tables. The lookup that appears to be causing the prob. is a lookup to a tbl called "tbleHomeAddress" I split...

Yes i am aware of that but it's not so much a problem with unauthorised people outside of our employ gaining access to keyboards it's more of a visual problem . There is only a maximum of 4 employees in this office and anyone who shouldn't be messing with anything behind a barrier is easily...

Hi Brenda Thanks No not to vague and given me food for thought. what I am trying to protect is sensitive information that (a) only certain people can see and (b) only certain people can change. Other people can see the screens so information like credit card details etc do not need to be...

I would like to pasword protect certain controls in my Access db, namley a text control box and a tabsheet control. The textbox needs to have it's value visable at all times but only certain users able to change it's contents. The tabsheet control needs to only be visable on the entry of a...

JimbOne Doh! You just answered my question for me. Yes it is based on a query -- I just need to sort the ID field in the query --- Just me brain needed a poke. Many thanks Pete

I have a subform displayed in datasheet view. By default it displays records in assending order. How do I change this so that I get the latest record at the top of the list? I've tried using the 'Order By' property but I can't seem to get it to work. Any ideas? Pete

Thanks Guys Prob solved Once again TTF tops

Ok I'll try owt once email on it's way Thanks Pete

Eric my e-mail is not geting to you for some reason anyone else got any ideas?

Thanks anch tried that but it don't make no difference Pete

OK thanks I'll have to make a copy and empty the tables so i'tll take me a little while Pete

No still not sorted It dosn't appear to be a problem caused by a join in the tables or queries. I can edit or add to the table directly and the bassic order will show on the sub form so that side is ok. But the add new record option is greyed out on the subform. When a new order is generated...