My first suggestion is to go to make a backup of the database and then go to Tools (from the menu bar), Database Utilities and select Compact and Repair Database.

If that doesn't work, then I...

Feel free to e-mail me. I will look over anything you send.

As far as the number of records in the combo box, you can start typing in the combo box and access will look for the first record that...

Feel free to e-mail me. I will look over anything you send.

As far as the number of records in the combo box, you can start typing in the combo box and access will look for the first record that...

First of all, what version of Access are you using? All versions of Access are capable of doing what you are trying to do, but the user interface of of Access may be different depending on the...

Here are some recommendations I have:

1) Remove the car_id field from the buyer table; what is the purpose of that field?
2) Create a table to track the make of the car; instead of typing in the...

To handle situations like this, I use a combobox in the header of the form.

For this purpose, the row source of the combobox would be a SQL statement that selects the id from the childrens' table....

Yes, that looks good to me.

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

I would strongly recommend creating tables from scratch and not from imported spreadsheets. Spreadsheets usually won't be divided into the database structure you need.

As far as importing data......

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

It sounds like all you need is to build a query and use the WHERE clause. Doing a quick search will give you plenty of examples.

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

If I understood everything correctly, what you need is an additional order table. The customer table would then use the order table as a subform. The issue you then have is how to add products to...

As far as the subform, access will control showing the additional "attachments" rows. Before you enter any attachments, there will be one row that is displayed to enter an attachment; however, keep...

The easiest thing to do would be to make another table to store the "attachments" with the following fields:

ID, e-mail ID (FK), attachment

I realize that your situation not actually be e-mails...

As far as building queries, once I know what result I'm interested in, I start with one table as my 'base' table. In the query I provided to you, I used 'people' as the base query.

From there, I...

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

Here is a SQL statement to produce the results you asked for:


SELECT person.first_name, person.last_name, activity.activity_name, session.date
FROM ((person LEFT JOIN attendance ON person.id =...

You can either create a table (we'll can it the index table) that contains all the card numbers that should be in the database and then join it to your table to see if there are any records in the...

First, you need to make sure that the database is recording the number correctly. Does it record the digits after the decimal point? I only mention this because you had mentioned the use of...

Can you better describe the problem? I use autonumbers for IDs, which allows the databaes to automatically create them and then I just have to refer to them if I need them. When I use autonumbers,...

Just wanted to let you know that I did look over those screen shots and everything looks good to me.

If the only change you made was to insert the session_activity table, then you should be able to just drop that table; however, if it is easier to start fresh, you can drop all the tables and create...

Please note that there should be a one-to-many relationship from activity to session_activity and a one-to-many relationship from session to session_activity. The code you supplied looks correct,...

With the design I had in mind, there is only a one-to-many relationship from activity to session. For example, I am a physics lab instructor. For each physics lab course (activity), I teach 13...

Since you are using only one table, I didn't understand what you were trying to do.

What is the record source of the form? If you have the record source of the form set to the table, then all you...

It looks like you have been busy and made good progress. Before I go in to anything else, I noticed that the design I suggested is missing one crucial field.
The attendance table should have three...

Since the textboxes have a control source of the combobox, any changes to the textboxes will not be reflected in the table. This is because the textboxes do not have a control source of the fields...

Can you give more details about the location of the fields you are referring to?

From your original post, I was thinking that you had two forms:
1) Store form - This form allows you to edit the...

Just so I am clear on the issue; for a particular acquisition, it is okay to have two acquirees, but there can only be one acquirer. Further, you want the databaes to prevent the user from entering...

The activity table that I suggested is simply the date_time table you had but with the addition of the activity id to track for which activity the date and time was for.

You mention that there is...

I don't see a need for the master_id. Could you explain it further? The problem I have, for example, is that the date and time of an activity is not related to the people.

Here is the design...

The weekday() function returns the day of the week as an integer. The function takes a date and an optional beginning day of the week value as arguments.

The dateadd() function allows you to add...

I just wanted to mention that I have used that method as well and it is what I would recommend.

I see... where are you having problems? There are two approaches:

1) Create a field to track the current number of leave days and at the end of each month, add a specified number of days to that...