Search results

Please take a look at Pat Hartman's M:M demo: Many-to-many example

I guess if I actually paid to use the sites I use, I wouldn't mind it. I just have a problem with getting free stuff when it wasn't the intention of the person providing the content. Everybody's got to eat.

I recently disabled the Adblock Plus. Maybe that's why this symptom has returned? I'll try re-installing it, I guess. I honestly don't like the idea of Adblock Plus but if it makes the site work correctly, I'll have to bite the bullet.

I don't really understand the issue. Is your combo-box bound to a field in your sub-form's query? If not, it will behave the way you say. Continuous forms are pretty unforgiving about what fields you put on them. Also, I'm a bit confused as to why you need VBA at all. Once the tables are...

Nice. Thanks for the info.

One of the tables on the outside of the M:M relationship goes in the main form. The junction table goes in the sub-form. Using this strategy, you have 2 different ways to see and/or manipulate your data. See Pat Hartman's M:M sample on this site.

All the way. Put things that are about a certain entity in its own entity. I've commented on this multiple times on this forum. For instance, here: http://www.access-programmers.co.uk/forums/showthread.php?t=189081 The purpose of normalization is not as an academic exercise; it is to remove...

Well, 1 problem is that most objects names don't have a space after them and you have added a space after "nama" (at least in the sample you've shown us).

The information shown in the screen shots you sent is not using the code I told you to use in post 12. That code populates the junction table correctly. If it asks for a parameter, see the above paragraph. The old code was not using the correct column names.

Ok, I found several things. Try this: Private Sub Form_AfterInsert() DoCmd.SetWarnings (False) DoCmd.RunSQL "INSERT INTO t_Training_Association ([Employee ID],[Class ID]) select " & Me.txtID & ", [Class ID] from t_Class_Name;" DoCmd.SetWarnings (True) End Sub I ran it on a copy...

What is it doing wrong? It looks like I got the order of columns wrong as I pointed out in my last post. Is there anything else wrong? Still gotta get it trusted and read/write to test it.

Dunno, if you're interested, I can dig through all my old stuff to see if I can find my old disks. It has been a while. Can you deal with floppy disks?

I really have trouble answering this type of question because I believe the premise is all wrong. A table (and thus it's database design) is NOT in XNF when it can introduce data anomalies that are corrected by normalizing with that NF. Additionally, when you correct the anomaly, you have to...

Re: Training Tracking It would be more like (air code): Private Sub Form_AfterInsert() DoCmd.RunSQL "INSERT INTO t_Training_Association ([Class ID], [Employee ID]) select " & Me.txtID & ", ID from t_Class_Name;" End Sub Also, I don't see your link anymore and can't find the copy of your db I...

A lot of people have this all wrong (including the "authors" of the Wikipedia entries on normalization). If you read a text book on normalization, you will frequently see the words: "A data model in X-1 normal form is usually already in X normal form" or something of that sort. It says this...

For Windows 3.1?

Well, that helps a little. In form f_Training_Requirements_Update: First, create a hidden bound field to hold your Employee "ID" field. Name it something like "txtID" Then in the "After Insert" event, run this SQL: insert into t_Training_Association ([Class ID], [Employee ID]) select...

With the little bit of information I have: Create a bound form and on the After Insert event run something like the SQL I provided?

It SOUNDS like you're keeping your "list" of classes in your transaction table. If that is the case, you can run something like this SQL: insert into Transaction (StudentID, ClassID) select StudentID, ClassID from Student, Classes Where StudentID = "TheStudentIDYouJustEntered" AND ClassID in...

You have a ways to go. Every type of "thing" should have its own table. I use a rule of thumb to see if a field belongs in a table by asking myself: "did this 'thing' have this when it was born or will it have it when it dies?" For instance, a person (a student or faculty member) will have a...