Recent content by Steepleboy04

What is the difference between the two? I'm a newbie messing around with both of these properties in a form and need some help.

msds db forgot to attach it

I am having trouble with my database structure on this project. Please look at my DB (relationships) and let me know what is incorrect. My MSDS tbl appears to have lots of fields, however, the values of these fields are already determined and will not change. The Product_Ingredient tbl is...

Is it possible to create a Database to record, search, edit, and print records without relying on the codebuilder and VBA to make these Forms functional? I ask this quesiton mainly because I do not know any VBA, but I am trying to create a database to create and manage Material Safety Data...

msds db I have attached my db. The main form is the MSDS form. I modeled this table after our current msds document---each tab will capture the data for a section on the actual msds document. I will need to either create a new product code, or update a record, from this page. On the second...

I am trying to create a database that generates a msds document for our products. I have three tables so far: TBL_MSDS ID (PK) ProductCode ComanyName TBL_ProductCode_Ingredient ProductCode IngredientID TBL_Ingredient IngredientID CAS# I've created a form that has default values for company...

So I can I create another field and use an autonumber data type, and make this new field my 'hidden' primary key????? I want to be able label records by an 'ID' field that distinguishes them from all other records. Why wouldn't the 'ID' field become the primary key in this respect?

I want to create a database that stores a customer's history of problems with a specific product on a particular machine. I think I have correctly created all the tables I need with their respective primary key. Please note the TBLJobRegister table at the bottom of this post. This was going to...

Karma, I unzipped the file you sent me and I have spent a little time studying it in my quest to gain some skills and understanding in databases/access. (I'm a complete novice, but I am learning from your posts and examples). My first question is a general question about database design. In...

I read an article on Normalization from the utexas ITS site to familiarize myself with the concept before I read your response. I followed your structure and created three data tables. I made the Formula_Code field in the TBL_Formula a primary key, since this will be unique. Formula_Names may...

I need help designing a couple databases. I have 300 formulas to manage for our chemist. He wants to be able to veiw a formula code, name, and notes (this data would come from a Formula data table with 3 fields). He also wants components listed below with their respective code, name, price and...