My office installed MS Access 2007 recently. I have designed a contact database and have a simple table. I want to add an attachment. I went through MS...

I have the following tables and keys and am seeking a way to easily populate Table 2 with values from Table 1. Table 1: PK1, PK2, F1, F2, ... Table 2: ...

I was wondering after reading some comments about table design. Is it wrong to use a lookup in a table to store the text of the foreign key to make the table...

I have the suspition that only in Access XP the following message appears. I created the file in Access 2000 and when I was using access 2000 was fine. After I...

I'm trying to set up a database in Access for our Instructors but am running into a problem. Some instructors teach multiple programs which in turn has...

Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and...

I have an HR dbase with S.S.# as the primary key and info about a person's position. I also have separate tables with S.S.# as the foreign key -- one has...

I'm hoping this is the appropriate group for this, none seemed quite perfect for this question. I have an Access 2003 front end, which is linked to some SQL...

-- Dennis

This is going to seem like a real beginner question, but here goes... Does anyone know where to download icons from Microsoft so when I create my standalone,...

I have a flat database that will not do.. and need to make it as relational as I possibly can. This is for a non-profit organization, and deals with coal...

I've been asked to design a database for up to 60 concurrent users. The awkward side of it is that the company in question use a mixture of Macs (OSX) and PCs...

I would like to use the calendar control to set a start date in the database and then automatically calculate a date 12 weeks after that date, but I would also...

I want to make the field names in the table I am working on wrap through two lines. Is this possible in datasheet view?

Hi I am trying to avoid being able to do double bookings in a form. I have a combo box holding 3 options eg AM PM All Day. Based on the date of the...

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

I have a main database that is located on an office server. Six people connect to it using a replicated copy of a front end, each of which are linked to the...

I need to calculate time differences (in hours and minutes) across a couple of days. The database is set up with a separate fields for date and time. Can I...

Our school is working on collecting information on grants and scholarship money. Is there a sample database design that we can use? I am not very good at...

I have recently been aproached with questions about Document management / Relational Databases for managing business. I also recently attended a presentation...