timothybard

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 that comes to my mind: person: id (primary key), first_name, last_name category: …

It looks like you are off to a good start. However, I would suggest that, in addition to the Booking entity, you have an Enrolled entity to track that a person not only booked a course, but was accepted into the course. Secondly, you have student_no as a foreign key …

This is my recommendation: Create one 'user' table that stores, at a minimum, UserId, but could also store name, DOB, etc. Create one 'Attributes' table that stores all the different "questions" ("What is your hair color","What is your eye color","What are you favorite activities", etc.) [B]This table needs an ID …

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 and attachments, but I wanted to keep the same example to make things easier. After you need …

Here are just some ideas: Bank: ID, Name, Address, etc Account: ID, Account number, Bank, Type, Parent Account? Transaction: ID, Date, Source Account, Destination Account, Amount, Transaction Code That should be the basic design, but I would recommend additional tables for transaction type, reason codes, etc.

Okay... not quick and simple and I don't have the specific details, but here is the general idea I would use. I would write some VBA code that does the following: 1) Loop through each Policy 2) Withing each loop, keep track of a currentDate variable that is initially set …

Click on the Office Button (in Access 2007) or File (in Access 2010) and then Options. On the options screen, click on Current Database on the left menu. Under Document Window Options, click on Overlapping Windows. Click OK and then reopen your database. Forms will now appear in the traditional …

One possibility is to not store the attachments in the database, but rather save them in a specific directory and only store the location and filename of the attachment in the database. When you need to access the attachment, have the database look up the location of the file and …

You will need to create a RoomsTime entity. This entity will have two attributes: RoomsID and TimeID. You then need to make both of them into the compound key for the entity. This will ensure that no two rooms will have the same time scheduled. Each class can then have …

Here are some suggestions for additional tables: Owner Elected Officials Principle businesses Principle investors Mortgagors Renovations and Repairs Occupancy (a table that records the unit, beginning date of occupancy and ending date of occupancy) There are several more tables I would recommend adding, but the ones I listed above are …

MS Access supports multiple users using a single database at the same time. What issue do you run into? What happens when several people try to open the same database file at the same time?

Here is what I would recommend as a beginning: Make: ID (PK), Description Model: ID (PK), Description, Make (FK) Car Type: ID (PK), Model (FK), Year Owner: ID (PK), Last Name, First Name Car: ID (PK), Car Type (FK), Owner (FK)

That's a pretty big question to answer in a forum. I would recommend going through an Access tutorial or finding a good introduction to Access book. Having said that, the process of database programming is usually made up of the following steps: 1) Identify the tables you will need 2) …

I reviewed the document you attached; however, do you have any questions that you need answered? You mention that your ERD is half finished; are you unable to finish it and what do you need help with? I see you have author, publisher and authorship listed as entities, but you …

I don't see how this makes a 2D array in to a 1D array. All it does is loop through all the 'cells' of the array and stores a number as Index. What, by the way, is rowNum? It is neither declared nor set in the provided code. I'm guessing …

Yes, city and province should be different tables; however, in addition to that, do provinces contain cities? If so, then perhaps you should use the provinceID as a FK in the city table.

MySQL and MSSQL would handle a database of that size with no problem. Depending on the data, you can use MS Access, but I'm guessing you would notice speed and reliability issues if you did.

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 compound primary keys; simply open the table in design view, select the fields to …

I would recommend adding a tutorial group entity and a student assessment entity. I would remove the name attribute from the lecturer entity and add it to the staff entity. Lastly I would add a staff id attribute to the lecturer and tutor entities. After making those changes, a few …

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 would recommend creating a new blank database and importing all the objects into 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. The On Change Event of the combo box would have something similar to …

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 make for each car in the car table, I would use a …

Yes, that looks good to me.

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... with MS Access, you can import the tables directly into temp tables and then create queries or write code in vba …

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 Assignment: ID, Section ID, Assignment Name Grades: ID, Student ID, Assignment ID, Grade

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.

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 and a model combo box. When someone selected the …

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, I am not concerned with assigning my own values to them as they are …

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 index table that doesn't have a corresponding record in your …

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 integer, which does not record anything beyond the decimal point. The appropriate values for the field …

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

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 two acuirers but without the use of a "trigger". Is that correct?

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 days to a date. You should be able to do what you are wanting with …

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 for a particular month in your first table is being …

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 days. I'm guessing you are trying do to something along …

1) The two database management systems I would recommend are MS SQL and MySQL. Both are very stable and are widely used. 2) I agree with the single database approach. All related data (i.e. a single project) should be in one database. 3) Personally, I have found MySQL easier to …

This can be done with either a query or vba. If you do it with a query, then you are interested in using an update query. However, you will need a way to run the query. Either someone will have the run the query manually or it will have to …

Just thinking outside the box a little... you could use a program that gives you remote access to a computer, such as PC anywhere, or by using VPN. Of course, you can always use MySQL or MSSQL, etc., as a backend and use php, VB.NET, etc. as a frontend, but …

I believe MS Access would be a good way to go with the description you mention above. Other possibilities are MySQL and MSSQL; however, that would, in my opinion, require more work than is needed for this project. With MySQL and MSSQL, you would need to run a MySQL server …

If salary is based simply on position, you can have a position table that stores all the positions and salaries related to each position. You can also have a table to track the history of employment so you can track what positions each person used to be at and the …

I am not able to view images that you are trying to link to. However, from your description, if sounds like you have a form and a subform. Are you trying to make it so that when the user clicks on the plus sign, the user is taken to the …

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: [url]http://office.microsoft.com/en-us/access/HA010448891033.aspx[/url] The procedure is simply to export it as an RTF file. You should be …

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 checked back in. After the item is checked in, it would see if …

I would actually go with MS Access for these reasons: 1) Easy to set up (the entire database is in one mdb file and you just need the Microsoft Access Runtime to use the database). There is no need to install a database server (such as MS SQL or MySQL). …

This sounds like something I have run into before.... I don't remember if this was the issue or not, but it is something you can try... If you have more than one field that relies on the year prompt, then instead of using [year] in each of those fields, create …

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 ran after the record was changed. Have you tried this …

This sounds like a homework assignment... I don't want to simply give you the answer. What ideas have you come up with so far?

[QUOTE=laghaterohan;695616] I TRIED DECLARING THE TXTID.TEXT AND CMBATTENDANCE AS GLOBAL N TRIED CMBATTENDANCE.ITEMS.ADD(TXTID.TEXT) [/QUOTE] I don't know if this is a mistake in your code or if you just copied your code incorrectly to the forum... in the statement CMBATTENDANCE.ITEMS.ADD(TXTID.TEXT), since the combobox is on a different form than TXTID …

I don't believe a multi-select listbox can have a control source. Instead, I have used multi-select listboxes and recorded the data using vba. I simply created a loop to go through each of the selected items and recorded each as a seperate record into a table.

I would recommend a new table that has fields to track the following: Room, Customer, Check-In Date, Check-Out Date