Tables

missing or broken / 'dao2535.tlb
Over a year a go I got the error "your Microsoft Access database or project contains a missing or broken reference to 'dao2535.tlb" version 3.5. The database was original written in Access 97. I was able to use Office 2003 to convert the data base. This has worked well. However, today I set up a new computer an... 6 Jan 2006 08:19

how to create a multi-part IF statement
In an Access database form I have a drop down field that has three possible choices. I want to create a calculated field with an IF statement that says if choice#1 display "CHOICE#1", if choice#2 display "CHOICE#2", if choice#3 display "CHOICE#3" otherwise leave this space empty. I can get one of them to show ... 31 Dec 2005 07:45

change long data types??
I am trying to create an infopath form and link to an access database. I have already created the tables in access and none of the fields have the "long" data type. When I try to create the connection it says "unable to submit form b/c one or more fields in the table have a data type of long. What should I do?... 29 Dec 2005 13:11

how to create a question answer form?
I would like to create a game similar to Jepardy. it will be an interactive learning tool. ... 17 Nov 2005 17:27

Multiple Junction Tables?
I have several tables that require many-to-many relationships; Would you create one Junction Table holding the PK's of all the other tables.....or would you make several Junction Tables? What I am trying to determine is why you would have several Junction Tables...by looking at Sample DB's. Also, what is th... 23 Sep 2005 04:12

Cascade Update & Delete
I'm setting up a new DB for my employee training records. I have a table for employees and a table for departments. There is a one-to-many relationship in the department table (one) and in the employee table (many) for department number. Let's say that when an employee leaves the company, I want to delete al... 15 Sep 2005 13:54

How to do a simple inventory database?
Right now I'm managing my inventory through Excel and it's working just fine but I wanted to try it out on Access. It's not too complicated since I only have ONE product which I order every month or two from the same manufacturer and send out to my sites. In Excel, all I have are rows with information as such: 1... 9 Sep 2005 16:28

Normalization
I am building a new db and am battling with the following: Should I use one table named tblPersons or two separate tables such as tblEmployees and tblFamilyMembers. The former, I believe, would be a higher normal form, however, the latter may be more intuitive when developing, coding, etc. Any thoughts? R... 5 Sep 2005 08:16

Foreign Key
Good day, I have Access 2000 How do I make a field have a Fireign Key attribute. I have looked in adding new buttons to my toolbar, but cannot find a Foreign Key button (help suggests this) Any advice would be appreciated Thanks ... 7 Sep 2005 08:45

Access Employee Training Database
I firmly believe a popular Access database template would be one for employee tracking of training. I would greatly appreciate a database where I could use to tracking my employee training to comply with federal and state regulations (i.e. OSHA, EPA, DOT...) I notice there is a database template for training ... 22 Aug 2005 10:07