Search results

After studying in detail the attached design of yours I kind of think that's there are unnecessary extra fields for the same info. For example the startTime is stored in 4 different tables. On the other hand I find using a field like the Day/Time to distinguish records a little bit confusing and...

First of all thank you for your time and your quick reply. Your comments were far more than jsut helpful and gave me food for thought analyzing the complexity of the problem. Now, considering your suggestions and especially the one saying that the less the number of related tables in a junction...

Have a look at here for example http://www.tinyportal.net/index.php?action=forum on the middle of the leftbar. Two of the most common functions is firtsly to serve as a small chatroom among the members, and secondly that it can save a big forum from all the one-word-reply* topics which are...

I think it's mandatory in modern forums, being more necessary as the later grows. I may elaborate on if you wish, but I think that we all know or can imagine the functionallity of such a feature

I am trying to redesign an older DB for a school, to meet the new needs that emerged. I am totally confused due to the complexity of the problem. I've already searched in this forum and in Google but most articles are for simpler DBs. Well to get to the point. School has Students, Students...

I have a Form with the property default view set to continuous forms. Due to the fact that at this form lots of rows (over 200) are displayed, user has to scroll down and down to get to the last empty row, if he/she wants to add a new record. So I'm wondering if there's a way to break the...

I think I'll go with the tab strip instead of the tab control since I found that the tab strip does have a color property. Do you know of any drawback that could prevent one to use tab strip instead of the default tab control? And another thing I'd like to ask. The tab control has this...

But this is only a local setting isn't it? I mean if I want to use that DB to another PC I should disable the option you mention to that PC too.

I'll try to put it as simple and extensive as possible. I am responsible for the DB of a private school which has 4 departments in different places of town. If an error occurs or more possible if they want to add a new feature to the DB I just can't go to each department and make the same...

Thanks for the immediate reply. What I am looking for is an automated process for the simple user, pressing a button and ready. I suppose can't avoid programming a VBA sub. Can you give some guidelines about linking and appending/making table queries. Let me inform that I am not a VBA beginner...

I want to import data from one DB to another, but only data without affecting the table structure and names. In the import dialog box has only two options, import tables and data import tables only. I want the third one ;) import data only. Is there any automatic way or do I have to make a VB...

Is it possible to enable scrolling bars to a field, when the form is in datasheet mode?

I am afraid my case is not so simple. Almost all of the basic joins are many-to-many, and that's where the problem starts (there's no unique Class-Lesson record as it depends also ). Let me explain in short the private school schedule structure to have a picture of the issue I am dealing with...

As I said I have a join table which contains the Students/Lessons/Classes-IDs. Then I have a form "Students" which contains a subform LessonsandClasses. Every Student picks some Lessons and every Lesson is held in one or more Classes (Lessons and Classes it's a many to many relationship) So in...

I've been designing a database for a private school. Every Student attends some Lessons in specific Classes. To my knowledge I can meet the above requirement by using a join table which holds StudentID, LessonID and ClassID, or to have a join table StudentsandLessons which holds StudentID and...