Search results

What about adding primary keys to these tables? The examples I've seen split the table in half and assign a primary key to the top table and assign 2 primary keys to the bottom table. However, looking at my list, the whole of the top table are primary keys. How do I advance beyond this and into...

Sorry, I'm getting confused. In my last post I said the ones with an ID are NON-REPEATABLE. Although you've just said that: "The date, time and final score are unique for each game and there for non-repeatable." So the ones WITHOUT an ID (date, time and score) are actually NON-REPEATABLE and...

Thanks for the 1NF structure. So are all the ones where you've added ID on the end non-repeatable? And all the ones which don't have an ID are repeatable? Don't quite get what you mean about the referee. Surely it still is non-repeatable as it's coming from a referee table containing each ref...

Okay, I get the advantages of doing it, but I'm still struggling with what is repeating and what is non-repeating data. Unless I'm missing something blatant, isn't it all repeating data because everything under each of those columns (I've listed in my last post) will repeat. I need to know what...

Right, I've been through countless tutorials on how to normalise a database. It's something I have successfully done in the past, but quite a long time ago so I've forgotten a lot of it. Here is my UNF (normalised form) of a soccer match database: UNF Season Tier Division Fixture Result Date...

The problem now is I can't seem to put more than a certain number of entries in the combo box to be used for the 'Nationality' column. I have 201 entries, but when I put them in and click 'OK', the bottom few, with nationalities beginning with T onwards are ignored. I can't seem to increase this...

Ah yes, thank you. It does, so now I know. :)

I'm looking to adjust the size of the list. I was just wondering why it's not automatically adjusting the width as I have it on "Auto". But I guess I could just do it manually anyway.

I've set the 'List Width' of my combo box as "Auto". However, the problem is that it doesn't actually adjust the width of it according to the longest text length in the combo box (as shown below). How can I automate it so it works? http://img27.imageshack.us/img27/9516/56884497.jpg

I'm trying to create some sort of validation so when a person enters a decimal number in the 'Squad Number' field, rather than rounding it up to the nearest whole number, how can I send out some sort of validation message which states that the user has to enter a whole number? Below's picture...

I'm having a little bit of trouble with my customer complaints database. This error message keeps coming up when I try to enter a complaint in any of the related tables: And here is a picture of the relationships: It was allowing me to enter complaints before, but now it doesn't work for...

I was wondering how I go about making my form functional. Okay, so I have an exit button, which doesn't work. Even though the code looks good to me. I want the form to close when the user clicks exit. Private Sub Command5_Click() Unload.Me End Sub I have a button which is meant to take the...

Okay, so I've designed the form I need to. The problem is I don't know how I am meant to go about making it integrate wth the database. It's a complaints form which allows the customer to fill out the complaint and I'd like it to store it in the database when the customer clicks 'Submit'...