I’m creating a database application for billing clients. The Main form has the Client information, customer #, address, etc. The subform, with a one to many...

I have a "Master"table that various fields, i.e. Salutation. In my Master table I created a field called Salutation. Made it a Combo Box - Table/Query and...

Hi, I want to enable a user to select more than one item from a combo box. Is there a way to do this in Access 2003? Thanks in advance for any help you can...

Hi, Problem ****** My db, which is not quite finished, tracks keys (assignments, request for new/additional from locksmith and those that have been...

I'm a realtor and new at Access 2003 however i would like some ideas about setting up a helpful, useful real estate database.

I was trying to make my database more efficient so I ran the "Analyze Table" database tool. I chose my "tblContacts" table and drag and dropped the "AD...

Hey everyone. I'm currently working on a project for my company. Right now we have about 12-17 people working in the database and I have just...

I have a task to create tracking of projects and subprojects. Its sounds like a simple 1 to many relationship with the parents FK in the child...

Hi there, I'm trying to keep a db of clients who take courses and the employees they send for those courses: TblClients ClientID (autonumber...

Hello, I'm working on creating a checkbook database for my church. I have the basics set up on it. I created a table of catagories of where money...

hello outside, when i retrieve column information on an acces table: by using: GetOleDbSchemaTable(OleDbSchemaGuid.Columns, I get something like the...

One table (Employee) is created having 6 fields. 2 fields of them are Last name and first name. Another table (Employee1) is created having some fields. One...

As a student of other languages besides English, I continually encounter the need for a resource that is a consolidation of all that my databases makes use of,...

Here's what I'm trying to do. I have separate tables for Office, Branch and Department (moving up the ladder). For most other tables, I link to just one of...

Hi guys I have a table with several fields, some columns are empty, what I need is to dynamically generate a table with the fields that at lease have 1...

My apologies if I have the terminology slightly wrong. I chose my Display Name for a reason.... I'm trying to create a database with the following...

-- Catherine W

In one table two fileds jointly create unique record (each filed has duplicate record). How can I assign primary key to both fields to avoid duplicate record...

I have developed an application with a front end and back end. Now users want to be able to use the database on laptops when they are out of the office. Now...

I am creating a new database. When I try to enforce referential intergrity I get an error message that "The database engine could not lock Table ' ' beacuse...