Search results

They generally collect similar data, but in different phases of training. Not all students in tblPrimary will complete the second phase (tblWinging). I also have an attrition table formatted similarly, but only those students who fail any phase will have a record in that table. The last table...

I also thought about adding tables for specific Squadrons that teach each of the courses, for example: VT-2, VT-3, VT-6, VT-27 & VT-28 all teach the Primary course VT-7, VT-9, VT-21, VT-22, VT-31, VT-35, HT-8, HT-18, & HT-28 all teach Advanced courses (Within the Advanced Courses are Strike...

I went through a lot of the links that Gina recommended and tried to understand normalization as much as possible. I also used some of the recommendations on forms provided in this post. I have attached a version of my db showing just 3 tables that are related. I believe these tables are in a...

Gina, I just sent you a pm. Not sure the protocol on this kinda stuff, but if you can help educate me a little I would greatly appreciate it. If I just need to keep looking around, that is fine too....just let me know. Thank you for your help. I think I need to take a big step back and...

Ok, I do understand how this works better now, thanks. As for my students, we have thousands go through each year and a combo box would get very long at some point. My db currently has over 400 students with more being added daily. Also, each student is really treated independently therefore I...

I looked through the various links noted above. I can see where a there are naming conventions for field names that may better improve my db. It seems there are some who would use the tblStudentInfo naming convention and some who would use StudentInfo. The latter is more of what I was using...

Wow, you are good. Currently some of this is tracked using a basic excel workbook and I am trying to streamline that process as well as include all of the things that my office tracks. Let me take a look at this link and I'll get started on fixing things.

I have uploaded my db again with all objects. Take a look at the ProductionCharts report to see what I am tracking. As far as your question here, my assumption is that the fewer tables you have to link with relationships, the easier it is to pull queries and reports, etc. Also, I always seem...

This could work for my purposes, I'll mill it over and see what I can do with it. It appears that the tabs in your form simply hold the fields on each page vice having to use a subform for no reason as in mine. This was a db design that I inherited and I'm trying to make the db work, so I'm...

Please discuss anything you see that needs to be addressed. The form in question is the StudentAdd form

Yes the StudentID is the PK, but I do not have any validation rule set on the table.

I have attached a zip file of my stripped db for review. Please take a look and help me streamline it if possible. I have an additional question regarding filling in forms. My db has a input form and an update form. The input form is based on the StudentInfo table, while the update form is...

Thanks, Gina. Your code worked for the pop up. Now for a follow-up: After I click OK to close the message box, I get a second system error code: "This value violates the validation rule for the field or record" OK/Help I would like to prohibit this system message if possible. Also, I...

Same failure error as before.

So, I went through and cleaned up my naming convention for all objects. I have tried the following two codes with similar failures. I have an OnLoad embedded macro to go to a new record when the form is opened. There are no other macros or codes associated with the form. Option (1) Private...

I'm going back through my db now and removing any spaces in my names for tables, queries, forms, fields, etc. It seems that my naming convention causes confusion when using the code that others have. I'll post back shortly and I'll also try Shoji's code.

I have tried the code below, but I am not getting what I need. I have a table [Student Info] with a field [Student ID] as the primary key and many other fields. I added the Student ID field to my form, [Student Add]. When I input an ID that already exists I get an error code as expected but...

I attempted the code recommended in the report module, but I could not figure out how it works. I did some research on DSum, DCount, etc but I'm not sure this gets me what I wanted. I got it to work this way: I added a subreport and based the subreport on my counts query. In the subreport, I...

Where do I input this code as part of the report properties? Also, can you elaborate on the fields in the code you posted? Which parts do I need to modify for my fields? To clarify: My count field is generated from a query that counts the number of completed students within the Fiscal Year...

This is what my final product should look like. Again, once I input my criteria into my Fiscal Year Filter Form, I am prompted for that same input again for each chart in the report. Thanks again.