Search results

Hello everyone in Access Land ~ hope you’re all well! As you know, I’m training to be a London Taxi driver by learning one ¼ mile radius circle at a time (a Quarter) of London and all the Resturants, Bars etc. (a Point) in each Quarter. Then I learn the route between all the Points in the...

Hello Bob Your link to the Evils of Look Ups a table level is, of course, completely right. Nevertheless, I missed the significance of it. In the past my databases have all been very simple affairs - just for me - and Look Ups Fields in Tables work fine at my (very low) Level. It's only...

Hi Diksah BookID sounds like a Primary Key field – if it is, I suggest Access should decide what to choose – you will never care what the actual number is – nor will you ever change it! Perhaps you might have another field MyBookID for your own code for a book. You might use an Input Mask...

Hello Jdraw Thank you so much for your post - I was feeling lonely. I’ve been off scratching my head for a solution alone. Sometimes a week or so not thinking about a problem helps solve it. Other times (like now) it just takes a week longer. Yes. I have a very clear plan. I know exactly...

Perhaps I said too much. If so, I'm sorry, I'll be more concise in future. Perhaps you've already told me the answer and I missed it (quite likely actually). Or, perhaps the answer is so obvious - that it seems I haven't done my homework. That's okay too - I will try harder. Once I have...

Thank you for replying jdraw. I’m very pleased with the link you sent – I am working through the sample db and lessons there. All of my posts seem huge, and I am anxious not to overload you chaps with useless (and dull) info. I have tried to be as concise as poss and not lose meaning. My...

Good morning gentlemen I've gotton a bit stuck creating a table to capure data. May I ask you to help me figure this out? These are my important tables so far List (The Quarter are grouped by List) Quarter (There are 640 Quarter, each is a ¼ mile radius area of London) Point (There are...

WOW! I had the wizard create a Form from fields in the Table Points and some from the Table Grids and it worked straightaway! I've never seen a Form in Datasheet View before. Was poking around in your Link Alan. At the bit "hide a table in a database window" figuring I don't want to be ever...

Thanks Pat. I haven't learned about Forms properly yet, I'll do that next. Thanks Alan I need some time to understand your link. I'm getting some really great help from you gentlemen - I really apreciate it, thanks again

May I ask you gentlemen please if there is a solution to this? In Table “Points” a field name “PointGridAToZMap” has a LookUp to another Table “Grids” field name “GridAToZMap” The Input Mask for both fields is. 0>L\ 099 As you know, this Mask places a spacebar near the middle of the...

Great Site Lightwave, I don't often play computer games - but I love this working on my score for countries of Europe best wishes Steve C

cheers RainLover, something to do with tables displaying the reference to the data not the actual date I'm guessing. I wouldn't have dared deleting a column in a Table in case that was different to hiding the column.

I didn't read that right, thanks for steering me straight. I'll always be using a form to enter/edit/view data anyways. I was confused by another post from someone who says they never use LookUps. I've created the Grid table and entered 3500 A~Z references (not the corresponding other map...

I’m using two maps. The first map is a huge 6ft x 4ft rectangle and hangs on the wall. The second map is an A~Z book with A4 sized pages. The two maps are really the same map - of London - but, because one is in book format and the other is a giant single sheet of paper, the grid...

Thank you for your post jdraw. Oh dear. Seems like I am disagreeing with Dave and it’s only my first day! And, it gets worse, because now I’m going to disagree with you too jdraw!! Oh dear Oh dear! I would love to have your help please gentlemen with this database. I apologise if I...

Thank you for your reply. You are right about postcodes and I can see an input mask might be better. But, I chose a separate Table for postcodes because there are only 119 possible postcodes in London (E1, E2, and so on). Each postcode is associated with an area (E1 = Mile End, Stepney: E2 =...

Is it okay to have a Table in a One To Many (with enforce referential integrity) relationship to TWO other tables? I tried it and it works but I am worried about problems later on. So, instead, would it be better to I create a duplicate of the Table on the “one” side of the relationship so...

Hi P Baldy lol Nice to know you'd help if you could - thanks for that.

Hello, Joined today and am told to introduce myself. Here goes... I'm a Knowledge Boy (although I have no knowledge and neither am I a boy at 49 years old). It's what they call people learning to be a London Black Cab Driver. I need to learn all the 25,000 streets of London as well as...