hello i have a database where i am trying to store information about 5 different types of machines by using a table that holds the common information, with...

I am trying to build a db in access 2003 it has riskSections... Schedule, Technical, Commercial, Financial, and so on each section has Topics... Warranty,...

Why is possible to create a table without a primary key? In other words what advantages come from creating a table with no primary key? I am working with a...

I'm trying to construct a DB that's essentially a list of lists, with each sublist having an identical structure. Seems straightforward, right? Make a...

Hello: I work for a govt. agency and developed a database that is split into an application.mdb and a table.mdb. Obviously all of the tables are stored in...

I feel like there's a simple answer which eludes me. I'm trying to make it so that a person can only have one preferred...

I have a table with all our Sales contractors. It has names and their IdCode. Also, there's a Sales Order table where all their sales will be entered. On...

Hi , What do I write in the expr. box when I want that there "must" be a value in the field and it "must be between the number 0 and 1" ?

We have a Date of Birth field in a few different forms that are all linked to the same field in a table. What I would like is for users to be able to enter a...

Is there a prevailing wisdom on whether or not tables with many fields should be split into 2 or more separate tables? I have a situation with one table,...

Hello! While I'm not new to flat databases, I am new to relational databases. I've been trying to build a database to keep track of my inventory...

I want to change the data type of certain fields in certain tables using VB6 code. I currently use code like this to modify some of the field attributes: ...

Dear All I Have been here a few weeks trying to get a attendance database up and running. I have had a lot of help so far. Duane Hookum helped me on...

Can someone help? I'm being asked to create a training database. There are 129 employees and 14 sets of work instructions. One set has 208...

Is it possible to ignore the "-" (dash) character in a text field somehow? I want to be able to search any part of the field, but I never know where the...

HI, I am a new user of MS Access and looking for help desperately. I have so many questions but right now would ask only one. The data i am working at is a...

Apologies, I am asking for quite a bit of help. I have been working on this in spurts for about 1 month. I feel like if I ever could just devote a several hour...

I am having trouble figuring something out and hoping someone out there might be able to help. I have built an Access database for a hospital education...

This may sound like a dumb question, but I really can't understand Microsoft's explanation of how I may use Multivalued fields in Access 2007. I think that...

I am a novice at Access. I have just discovered there is a limit to the size of the database which I have just passed. I keep records of a coin collection in...