I would always recommend having a primary key; if you don't need it now, perhaps you will need it later; if nothing else, it will help you refer to records while debugging.

MS Access does support...

Your database design is a lot closer to what I was expecting. Please note that my original design included course sections in case there were different sections for each course; if you don't need to...

How do you plan to record the grade a student has for each of his/her classes? What is the difference between class and course?

I feel a lot of your relationships are backwards. For example,...

How does your design track which classes the grades are for? How does your design track each assignment? Is each major a part of a field? What do the penalty and class tables track? How does your...

I gave you the tables I would use for this database above. As far as the relationships:

course-section: one-to-many
section-enrollment: one-to-many
section-assignment: one-to-many...

You can join the grade table to the section table and then join that to the course table. If you need to track a subject, you can add a subject table and have a foreign key in the course table to...

Below is the database structure I would start with:

Student: ID, Last Name, First Name, etc
Course: ID, Course Name
Section: ID, Course ID, Section Name
Enrollment: ID, Section ID, Student ID...

Are you familiar with VBA? If so, the code you need should be something along the lines of this:


Private Sub Combo182_Change()
Combo183.rowsource = "SELECT Models.[Model Name] FROM Models...

What I had in mind was to use the On Change event of Combo182 to update the Row Source of the Model combo box.

From your post, it sounded as if you used the table directly to enter and view data. I would recommend that you use a form to modify and view the data.

With the form, you can add a make combo box...

Try creating the following three queries. If you use a name other than the ones I provide, then you will need to update the last query to refer to the names you used for the first two.

Query1:...

Can you tell me what the fields in each of the tables are and what the table d contains?

It seems like the issue you are having is that is that your join is creating an instance where each record...

Try this:


SQLText = "INSERT INTO issues1 ([title], [time], [Opened], [opened by], [staff], [status], [category], [comment], [assigned to]) SELECT [title], [time], [Opened], [opened by], [staff],...

Can you show us the statement that doesn't work? My first guess would be that you don't have brackets around each of the fields. I see you have brackets in the Insert INTO section of the SQL...

From what I can make from your description and table names, here are the fields I would use:

GuestTicket: ID, GuestTicketType (FK), Name, etc
GuestTicketOrder: ID, GuestTicket (FK),...

With the form in design view, go to View, Tab Order. You can then click and drag items in the order you want the user to tab in or click Auto Order.

Do you have that code on a line all by itself? You need to add the 'SQLTEXT =' to the beginning of the line.

View the attached picture to see exactly what it should look like. The Me.Id refers...

You are correct... I overlooked the word 'issues' in the SQL statement.

You should be able to replace 'helpdeskLogTable issues' with isses1

You mentioned you linked the two tables. Wasn't...

Two issues:

1) I don't think you can update a table that is not in the database. I think you need to create a linked table. To do so, click on File, Get External Data, Link tables. Then browse...

Are you familiar with both VBA and SQL? If so, then you can see how to run an append query from VBA at this site:

http://www.blueclaw-db.com/docmd_runsql_example.htm

Specifically, look at this...

I would recommend adding a button on the form and setting its visibility to false. Then on the AfterUpdate event of the form, make the button visible. Lastly, if someone clicks the button, have the...

You'll need to create a query that joins the table with itself on the Length field.


SELECT movie.Title, movie.Length, movie_1.Title
FROM movie LEFT JOIN movie AS movie_1 ON movie.Length =...

Try something like this. If first creates and sets a connection and recordset, opens the recordset (SELET * FROM [Product]) and then loops through the recordset, counter the number of records as it...