I’m working on an employee training database and am getting more confused by the minute… I have the following tables: tblEmployeeData pkEmployeeID –...

I’m trying to develop a database to track Engineering Change Requests (ECR) and prevent drawings that are under ECR from being printed. Once an ECR is...

I'm trying to construct a track meet database. I have 5 tables: tblMeet (fields are MeetID, MeetDate, Event); tblEventDetail (fields are EventDetailID,...

I have a customer table that lists all of our customers, and a contacts table that lists all of our contacts. Now it has been decided that rather than just...

Hope someone can help.... I was asked to create a contract databse, however, there are over 100 contracts with a minimum of 5 pages, each page containing at...

Hi All, Scenario: tblStandardPricing - Just what it says tblCustomerPricing - Customers that pay another rate tblOrderDetail - Sometimes another price comes...

Hello All, Looking for suggestions, ideas, thoughts... I have 5 tables included in my query: tblCoilReceiving PK tblCoilRun (related to tblCoilReceiving 1...

background is: JobProductTickets. This has to be further broken down for one particular customer because we are having to stockpile the product at various...

I have built a database for my company (a small electrical contracting firm) using various access 2007 templates. At the moment it contains customer contact...

In my library database, I've set up a table of topics and their base-# like this: ID = 1 TopicName = Parenting Shelf Number = 120 I linked this table to my...

I'm making a library database for a small non-profit org, and I need help streamlining the database to be user-friendly. The books are organized by several...

I don't understand why the entry form closes after I click OK. Form's Before Update code is as follows: On Error GoTo ProcError If Len(Me.LastName &...

Hi I have got a problem in establishing the relationship between the tables of my database. I am creating a database where to put different...

How will I be able to organize the database in order to put more than one value in one field (such as countries and regions)? The problem is that I need to...

Thank you for your time and patience. This board has been a wealth of information and knowledge. I hope you can help me with my latest Access challenge. ...

Bottomline, I need to create a keyword index. I have a file system that's nonuser friendly (system mandated by organization, not my choice). It's hard to...

Thank you for your help upfront. I’m trying to grasp how to use a junction table properly, because I’ve clearly missed something (this is one of those...

The db I have has 3 tables, agreements, organizations, amendments. 1 agreement can have many organizations and/or many amendments, 1 organization can be...

Where exactly do you put this command? "Rick Brandt" wrote: Kark wrote: How do I make a query column display only part of the fields of a table...

I want to be able to open one database from a master database. I'm not sure where to begin looking for help on this. I've tried looking under open but get...