Search results

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

I used a free product called "Dia" once. Works pretty good...very Visio like without the high price tag and some of the features.

If you don't want to fiddle around with maintaining DSNs, you could go with a DSN-less ODBC connection. Banana on these forums wrote a nice little (or big) article on the why's and how's. Just search here for DSN-less and you can go into the advanced search and only search for posts by Banana...

Just saw it. For those who might find this in the future, localhost is the computer you are sitting in front of. It's IP address is ALWAYS 127.0.0.1. The way Adam's cheat works is by re-routing traffic from any of the sites that he has in his list (in the hosts file) to the local computer...

No need to have a separate combo box for each interest rating: just create a sub-form for the table that holds your interest rating for the student/subject. As you enter the interest rating for the student, a new row will be entered into this table. I am quite concerned that you might have a...

Post #10 reported as spam.

Too many quote marks. The "AND" (without quote marks) is part of the SQL query. Thus, when you build it, you cannot have "" around it. WhereCondition:="Social LIKE '*" & Me.Last_4 & "' And LastName = '" & Me.LastName & "'" Or something like that.

Put the "AND" keyword between the conditions.

Depending on your backend, "char" type columns are padded. If you don't want padded fields, change your data type to something that doesn't pad, like varchar, varchar2, text, or whatever your backend uses.

Not really without seeing everything that creates the data for the report. I've been taking a shot in the dark so far on everything.

Please consider the meaning of the word "obvious". It is not obvious to us. How do you know it doesn't work? Do you get an error? What is it? Does it display the wrong data? What? No data? What do you expect to see that you don't? What do/does the table(s) look like? I would never...

I assume it is getting the 4 digits from the query. If so, modify the query with something like: 'xxx-xx'&Whatever.Last_4 in place of the the portion of the query that creates the last 4 digits field.

I have no clue but I do have a thought. Would this work as your where condition: WhereCondition:="Social LIKE '*" & Me.Last_4 & "'"