I posted this question in the Reports section, but am thinking maybe it is more of a basic design issue than report issue. I have a basic db of part numbers...

Hey everyone - I've been to this newsgroup before, and really appreciate how helpful everyone is. Sorry to bother ya'll again! My latest project for the town...

I'm trying to set up a database to keep track of company equipment. We are surveyors and so use: theodolites, tripods, prisms, cameras, and numerous other...

Hi My understanding about foreign keys is that they are generally a primary key in foreign table. The primary table primary key would be unique. In fact I...

I want to create a database that I can assign a job to a person based on their skills. Some people have more than one skill. Some jobs need more than one...

I have .rtf files and .wav files that I want to save in an Access table. What kind of datatype should I assign to the .rtf files and .wav files? Can I...

All- I have been stumbling through Access (I have 2000 & 2007 so I can work with either one) trying to figure out how to accomplish the following with no luck...

I have a db with ticket sales. I want to have an inventory list of all the seats and be able to assign them to the purchasers. I can't find a way to produce...

Greetings, I have a project where I have to assign a three-part ID number to each new entry. The first two parts to the "number" are typed in by the user....

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 have a table already populated with distinct records and I need to add a field where I can assign a unique ID. I want the unique ID for the first record to...

I have a DB which has deposits and withdrawls for customer accounts.Some of these accounts are given a set percentage of 3 or 2 percentage added on to their...

I have a list of 1000 discrete passwords (and that list may grow from time to time). I'd like a system where when I click a command button ("Generate...

Using Access 2007 but need to save in Access 2003 format to share the database. I want to create a section of an existing database with a fixed total number...

Currently doing this all on paper. Here goes. Presently the top part of the DAILY Sheet lists all available trucks to use in order of union priority. there...

Hello, Am fairly new to Access and this is puzzling me. I have a form (obviously tied to a table) that asks for several inputs in fields: - Month 1 - Amount...

I am a relative newbie to Access DB design and am looking for some assistance in setting up appropriate relationships between tables so that I can run queries...

I'm looking into correcting a previously developed database that was originally done and works like an excel spreadsheet (all fields are currently in one...

I'm having difficulty with the relationships. They connect OK but when I come to click on the plus sign in any of the tables I get the message:- This...

If you right-click on a table or query, one of the options is to create a shortcut to that object. The result of this is a .MAT file. I have a user trying to...