I'm trying to populate fields in one table with data from another say I have a table with employees in as follows employeeID(primary key) name charge...

Is there a premade layout for recording my music collection in Access?

I am setting up a new database and am wondering how to sort a lookup list after adding new value. I have a list of job titles, with the primary key as an...

I created a data collection database that has been distributed to remote offices on rented PCs. The PC's have Access 2K. I built and maintain the db on...

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. MS Help is no help whatsoever. I'm trying to create...

Hello Access Users. I've been setting up list boxes for a while now (enough knowledge to be dangerous I guess). Why does my list box selection (once it is...

I'm starting a design separating company and contact info. Please have a look and make suggestion. http://www.collage.co.za/sql/diagram.jpg

Recently the company I work for switched to windows 2003. I currently support 3 Access databases, front end/back end, written in Access 97. I converted the 3...

Access 2003, need to customize switchboard and sub-switchboards to make more efficient. Need to title each switchboard with title other than the name of the...

I have 2 tables in a data base with a relationship defined beteen 2 fields eg: FAMILY ID (AUTONUMBER - PRIMARY) related to FAMILY ID (NUMBER) I have a LOOKup...

I have a real Dilbert kind of assignment that I am hoping that someone can give me a hand with. Currently my company uses a spreadsheet to calculate the...

I have a database sharing folder for two persons . One of them have the full control database and another has read-only database. The porblem is the readonly...

Sorry if this is a repeat, but I could not find the answer in the archived posts. I have two tables that have a one-to-many relationship with one another. The...

I have a product list!! Based on that list I am building customer requirements, by product, schedule date and quantity. The list is huge and I don't have to...

I understand that I need to build table relationships based on IDs, not on text values that may change over the life of the database. I have read in this...

Hi all. I have come across a problem with using a linked value in a lookup value. The situation has arisen trying to format an aircraft register. Table1:...

Using MS Acess 2000 I need a good customer service template for Access for tracking customer call ins, status and discussion of the call, follow up etc. This...

i am creating a league database for my club squash leagues. the leagues go from premier 1-10, intermediate 1-10 and club-1-3. so far i have tables...

unable to download the office 2003 update (KB892236) regards Fred