Recent content by Vitesse

Is there any facility here to do stuff live - like a chat client? I'm thinking that if someone could push me in the right direction then I might get a bit better at this, feel like I'm absorbing you guys' time but not making much progress

"Unrecognised database format" again :-( I wish I could get this software updated but I've tried and failed in the past.

Thanks for that rsmonkey - I've always had a bit of a blind spot on how to start doing these things especially when it comes to setting up tables. I always want to put everything in one big table. I can see that splitting it down is better BUT it's the relationships bit that I can't quite get my...

That works great thanks! I think what I needed was something to work on, so big thank you for that:D Now to get to understand how the db works and what I can do with it - this is so much better than the one I tried to do! OK so I guess the next step is to put the existing data into the db by...

Access '97 says "Unrecognised database format" :-( I've got Office 2007 on my home PC I'll see if I can see it on that machine. Sorry about that - one of my limitations is that I can only work on the thing in Access 97.

Thanks rsmonkey, the way I look at this is that I know it can be done and I know it should be done but I don't know how it can be done. There's no other resource available to us apart from me and you guys :-) So, to cut a long story short, I'm in with my sleeves rolled up. The "database so far"...

Thanks - I think I'm clear on Normalisation now, that Wikipedia is great! How do I go about creating the queries I need?

It will be often updated, at least monthly but more likely weekly - I really don't want to get too far into the black arts of VBA before I have something that works. I'd really like to have something I understand and can use first :-)

Normalisation - that's getting your data to be "clean" isn't it? ie "yes", "Yes" and "YES" are not the same until you normalise them into "yes" or am I thinking of something else? Also, when you say "read up on" - where do you suggest I go to read up on this? All I have to work from is an...

I've done imports before but never actually linked an Excel table in the way you describe so that could be "fun". The idea behind this whole thing is that we use the spreasheet to record and run the actions, when the Gods want a report we don't have to spend ages collecting and collating...

Cheers Rabbie

OK I can see where you're going and it's helpful - what do you mean by "PK" and "FK"? I'm assuming PK is Primary Key but what the FK is FK? Location? Well the idea is we are UK based supporting three offshore locations but that's not really relevant, the actual location is my study in my house...

Thanks guys - I've used a db before but never in this way, ie with text and no calculations. When you say post a schema what do you mean? I can post the outline of the data collected in the Excel spreadsheet (attached) and what I've done so far is to split that up into tables of similar data in...

I'm kinda lost in here so I'd appreciate some help in pointing me in the right direction please. I've no doubt the answers are out there but I'm having trouble finding what I need, probably because I don't know how to frame my questions! Basically the story is this - there are three guys...