I am creating a database in which users can enter answers to a questionaire. (About 200 questions.) Most of the questions are multiple choice and I would like...

This is probably basic normalization design, but I can't seem to figure it out: I have four Vendor Types: AG, IC, GB, DE I have ten Service Types: 001 -...

I am designing a database for my wifde to track product orders. she has hundreds of products that can be divided into about 10 categories. each category...

I am an access newbie. i need a validation rule that will limit the users to enter only of four, two character text strings. "Fr" - "So" - "Ju" - or "Sr". ...

I have been working with MS Access for about five years. I have been able to grow my solutions from a simple mdb with a couple of hundred records to adp with...

Hi, I have been directed here as the guys in the query group couldn't help. I am thinking of using access to produce a system to allow production members to...

I have these two tables, in two different mdb files. http://www.anothermasterpiece.com/help/access2.jpg I now want to transfer the data from the one...

How do I set up my database so only one user can enter data at a time? I was told that is two users entered data into the same page at the same time and...

Hello I am using access 2003 creating a reports database. I have 2 columns working with this scenario i need. I have an AGENT column and a NUMCALLS...

Woody, My first choice for modeling a one-to-many relationship is a continuous subform, in your case, with a combo box that lists the choices. Your can...

Woody, Be careful to use quotes around literal strings but not around numbers. The following are valid expressions: Me.CategoryID = "Thread" Me.CategoryID...

I have several general-use tables that are in a "Common.mdb" database. A front-end file will link tables from this database as well as tables developed...

Woody, Woody, Now that you have the form as a subform, there's no need to execute the Openform code. The only code you need is the bit about toggling the...

Woody, I have no idea how to open a form with a hyperlink so I can't advise as to its nuances. The straightforward way to open a form is the OpenForm...

Is Product the name of a form control (textbox, combo box, etc.) or the name of a field in the underlying table? Or both? If the latter, this is not a good...

This was what I needed. Thank you. Susan "Lynn Trapp" wrote: First of all, 0.5 is not less than zero. It is less than 1. Second, check the field size...

Designing an MS Access 2003 VER database for the recording and recall of library records. Would like to have a 'keyword search" option to recall library...

In the object table, I can see there is a linked table but how do I know the actual table located?

I am attempting to design a database for my not-for-profit organization. This database will be used to enter information while generating a contact list and...

I am having problems normalizing my database. The staticTime table is the time that the employee receives at the begining each year and was rolled-over from...