Tables

Unique fields in table design
Hi, I have a payroll database which is currently in use, in Access 2002. One of the tables called TimeSheet consists of the following fields: TimeSheetID EmployeeID (references the employee table) PayPeriod (references the Pay period table). The problems that is occuring is that some staff members are filli... 24 Jan 2007 13:40

FE/BE question
I'm currently making some modifications to a copy of a database that is not split. The mods are to both forms/reports, as well as tables. After I finish the modifications, I intend to try splitting the database so there is a FE/BE structure. Because users are still using the original database, data in the tables... 20 Jan 2007 21:27

Printer and Cartridge Database
Hi, I am trying to create a database that I can store printers with their correct cartridges. From what I have read, and forgive me as I am new to Access etc, that I am trying to create a many-to-many relationship. Can someone please point me in the right direction on this as I have been trying for days now... 18 Jan 2007 17:46

Integrating MS Access database with a point of sales software
Hello experts: I am about to create a database for a client who already have a point of sales software in place. Once I create this db is there an easy way to integrate them so they work together and give faster service? ... 14 Jan 2007 21:28

Multi-Field Primary Key
I have 2 fields: [PHONE] and [AUTONUMBER] I would like to define the Primary Key as a multi-field primary key as the concatenation of [PHONE]+[AUTONUMBER] Now, [PHONE] may be null, but [AUTONUMBER] will always contain a unique autonumber. The problem is that Access won't allow null in [PHONE] even though t... 9 Jan 2007 09:23

Getting from Access to Word
In a form, I have a listbox based on a table that contains Section, Subsection, Page and Pathway. What I want to have happen is that selecting one of the lines in the listbox automatically activates the Pathway so that the specified document comes up in WORD. I'm just unable to do this, despite hours of frust... 12 Jan 2007 11:01

Multiple Product Description and Quantities?
I am working on normalizing my DB and wondering if this is the proper approach. I have Quotes with multiple items on them and each item can have multiple quantities with a price. Do i need a separate table for the items and then a sub table with the quantities? http://i118.photobucket.com/albums/o117/tednts... 3 Jan 2007 09:52

Splitting Database
Hopefully someone can help me out on this. So I want to split my database and I am having some trouble viewing the front end. When I go under TOOLS-> DATABASE UTILITIES->DATABASE SPLITTER, it saves the back end ( name of database_be.mdb). Now how do I view the front end? thanks! ... 28 Dec 2006 13:44

Hyperlink Email Address
I imported a table from Excel and one of the fields is the email address of each record. If i click on that field, it goes to the web site, not the email. I set the field property to hyperlink, i don't see anything else in properties to change unless i redo each record, which i do NOT want to do. ... 21 Dec 2006 11:25

data normalization
What is the best way to normalize the following data string: "John Doe, BA MS PhD". Each person may have a different number of degrees. I need to be able to address each person with all of his/her degrees. I need to be able to query on each degree separately, so data inconsistency like "BA", "B.A." etc canno... 22 Dec 2006 04:50