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...
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'...