I’m trying to develop a database to track Engineering Change Requests (ECR) and prevent drawings that are under ECR from being printed. Once an ECR is...

I'm trying to edit the Access 2003 "Orders Management Database" template that I downloaded from this the home site. However, whenever I try to add a table...

Hi - so far today (first day with access 2003) I created a table - customerID...then created a form...customerID and made the layout the way I want it to...

Hello, I have an access database and I would like to the Update field to generate the date automatically after each change of data in the table. I read all...

I just inherited a large Access 2K3 application that is designed with 1 front-end mdb file that links to one of 3 dozen back-end mdbs. Each of the back end...

I need to create an autonumbered field in my access 2003 database that looks like the following: DCR-07-000 The DCR is a constant, the 07 is the year and...

I am starting a new project to be able to track some of Inventory that is being shipped with the product. All the items have bar coding. I need to create a...

I created a database with list boxes and combo boxes. I know there is a limit of 325 row in combo box and list box. I have 30000 items in the list and I want...

Hello, Is it material description enough as a primary key?, we are not in the stage of using catalog as a material coding, what would be the constraints if...

I have downloaded the "Issues Database" from MS. I have made changes to it to suit my needs. Anyway, I get stuck on one thing though. In the databse you can...

I am making a new database and need a little help on the design... Im going to need to see what type of rig (Drilling, Swab, and WorkOver) on a form that shows...

Hi All, I am trying to create a database table for a purchase order inventory system which tracks items issued in & issued out. I have designed the...

I need to be able to search the word documents that I've added to the database using the Attachment data type. I've tried querying it directly without...

Hi All I have a database setup for the storage of details for project submissions. I have a table which stores the details of the submissions themselves...

I am very new at access, but I am trying to generate a unique anme/number using the Last Name, First Name and autoNumber fields...by reading some of the...

I have what may seem like a silly question. I want to create a 3 table database. tbl1 - who! - names, title, category tbl2 - where! - contact info tbl3 -...

I'm building my first database. (I'm scared to death!). Forgive me if I ask a lot of questions -- this is a huge project given to me by my manager. I have...

I have added new records to a database via form, but when I go to search for the new record again using "FIND" it cannot find the record. Old records can...

I have two tables one is a table of components which has a unique item number as the primary key. The other fields are part numbers, component description,...

I created a database and made some changes to the attributes and of course that affected my reports. When I went to make the changes to the report, it was...