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

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

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

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

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

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

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

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

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

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

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

Can you explain what you mean by taking days x add y days and store them as accumulated days? I'm guessing you are not trying to take, for example, an initial 45 days, add 50 days and then store 95...

In this case, using an INNER join should give the same results as using a LEFT join. When I build queries, I usually think of one table as the "base" table and join other tables to it.

With...

You do not use the SELECT and FROM command when creating an update query. Instead, you will use UPDATE and SET. I believe this is the statement you are needing:


UPDATE tblCourse LEFT JOIN...

I am a MS Access person and don't have any experience using FileMaker. However, I downloaded the FileMaker trial to see what I could figure out.

You currently have a customer form. The contacts...

Just like subforms, there are times when it is very appropriate to use subreports. However, you may notice some performace issues when using subreports.

I usually stay away from subreports unless...

You are able to use subreports within a report; this is just like using a subform on a form.

Here is a link to Microsofts solution on how to export a report to MS Word:...

I'm not sure I understand what the problem is. For a library system that includes fining its patrons, I would create a database that tracks when the patron checks out an item and when the item is...

Again, I don't know why you are prompted again when you try to print, because I don't run into that problem.

However, when you can do is us the On Open event to prompt the user for the year and...

I tried duplicating the issue, but I can't. I am able to create a report that prompts me for the year when I view it; however, when I go to print it, it doesn't prompt me a second time.

Can you...

Just so I am clear...it sounds like we solved at least part of the issue. Before it prompted several times before the report would be displayed but now it only prompts once. The problem now is that...

That is odd... I am using MS Access 2002 and it works fine for me. I would be surprised if the timing of the on current event changed from access 2000 to 2002. I thought the on current event always...