tbl_parts: part_id - autonumber - pk part_description - text tbl_bom: (bill of material) bom_id - autonumber - indexed(no dupes) part_id - number -...

Ok here is the situation. I a looking at setting up a database for my company that tracks manufactures/potential manufactures and their capabilities. What I...

Datasheet view returns autonumber instead of field value. I have the following tables: 1) a table for rank codes which only has two fields, autonumber (primary...

Hello: I have a simple Access 2000 database with 2 tables; tblSites and tblLandspreading. I need to look up the date a site was last used from the...

is there a way to use multiple validation rules in table's properties that would return a unique message depending on which rule was violated as data is...

I'm having trouble with the creation of what should be a fairly simple database. I work for a company with 120 retail stores. Our department takes care of...

hello all! does anyone, or has anyone, used a data modeling tool for Access 2007 database design? i need to design a pretty complex database, and we need to...

I have 9 products in my products table list. I want to create a sales table where all of these products will be shown so that I can enter sales for each one....

I have the following code which checks the ISBN check digit to ensure a correct ISBN no is enter for a product. This works fine, however, if the user enters...

I have a database with a lookup field I created with the Wizard. Now I want to get rid of the lookup key value that is stored and instead store the actual...

I am using an unbound multi-select list box as the interface where the user can select the zip codes they want. However, I want to be able to store this...

I have a table in Access that I run many update queries on to get the data in the correct format. Once this is completed, I then need to export this data...

I have a simple database for storing information about research articles. Fields on the input form include title, author, year, journal, type, keypoint1,...

I am using Access 2002. I have two tables. The primary table has an autonumber field which is set to increment. The field is a long integer.This field is set...

Hi, I have a set-up where I import an Excel spreadsheet (usually only 1 record) into a temporary table that is appended to one table (Artwork approval) in my...

Employee Table Employe ID AutoNumber Primary Name Number Secondary Number when i input NO.1 in Primary Name it should show me Persons name in the drop down...

am trying to build a database and need a query build to count times example Hound Number 999 score 35 Time 11:00 Hound Number 999 score 30 ...

I need to hold an inquiry to sick persons. I have: T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields; T_Questions: IdQuestion (with primary...

Hi All! I want to create a ("status") field in my contracts tracking table to tell me the status of the contract based on whether or not some other fields in...

I have some 140 MB's worth of journal articles. I need a searchable database that shows the author, journal name, date, a brief summary, key words, as well...