Search results

Thanks for help! I actually wanted ONLY the most common subject, but I see, I had to use COUNT()...

Let's say I have in my database teachers, each one has one subject, and I want to find the most common subject... How do I do this with SQL? SELECT MAX(*) FROM Teachers GROUP BY Subject ??????

Thanks for help! I'm doing a Video Library project, and in settings I hold: Maximum Days for rent (New and old movies), and Fine per one day.

How do I make global variables? I have a settings table, which holds some basic information, which I need in almost every form I got. So how can I access this information from each form? I'm using usually other tables as a source of the form for the form needs, so I can't set this one as the...

How do I set a value of one object to the value of another object from other form (which is not loaded)?

I have a form, where I have a ComboBox(to choose a client), and the form should be an 'Update Clients' Details'. So I have there, also, Labels (which don't get changed) and TextBoxes which should be changed according to a query. In the query I put under ID criteria...

I have a few questions: 1) I have a few forms, and I have ListBoxes in them, and I want to set the value of one of them to another (these are two different forms). I don't want to combine it to one form or things like that... Should I use a module? If so, tell me how. 2) I want to receive some...