Hi, Maybe someone can help me with a relationship setup for the following senario: I have the following tables, furniture, Building, Floor, and RoomCode. I...

I'm relatively new to access, so bear with me as I try to explain my issue. I have 2 tables of interest. One table, I'm using as a lookup table and I have...

I have a table which includes the following fields: Course (text) Attended (Yes/No) Exempt (Yes/No) Exempt Reason (3 values in value list: Already Done,...

I want to add an attachment (JPG photo) field to a table, but there is no "Attachment" option in scroll down of Datasheet/Data Type.

Hello All, quick question that may lead to other questions. Can you have more than one many-to-many relationships in one database? If so, is there any...

Hi there-- I need to store numeric data that should be able to handle up to 12 digits with up to 9 digits behind the decimal point. Thus, Currency is out and...

Table field values. I would like to populate table2 fields with table1 field values when a chosen field is entered. e.g. I enter a serial number in table...

Hi - I manage a glossary that is stored in Access. Each term can appear in multiple publications. Currently, all of the sources are stored in one field,...

I got a new job, where one quite simple Access DB was placed onto the server with shortcuts of the whole! DB being placed onto app 5 PCs. Of course one of...

I have 3 tables (Models, Check Items & Parts) Models Table has fields; , , (e.g. 120 records) Check Items table has; , , (e.g 40 records) Parts Table has;...

I have a table with 3 fields EntryId (Primary Key - AutoNumber) EmployeeNo EntryYear what do I need to do so that an EmployeeNo can have multiple entries,...

What is the benefit of converting my Access 2000 mdb files to the Access 2007 version? All of my users are using Access 2007, but I still don't know why I...

Can You Please tell me how to make an envelope label in MDE ? The envelope label works fine in MDB, but is not enabled in MDE! What do I do? -- EPS

I am trying to make an envelope label in "mde" but the label tab is not enabled in "mde" - it works fine in mdb, What can I do? Thank you for your help! --...

I'm creating a database for my financial planning clients. The primary key will be the client ID. I've begun with my Client as my first table which...

i would like to be able to move focus to a field depending if another field is ticked. i can do this on the same form but can't get it to work with a...

(Using Access 2000) I have a 3 tables. Client Table...ClientID(pk), first name, last name, address etc. Exercises Table...ExerciseID(pk), exercise name,...

Hi I am new to Access, is there any way to add a field in a table that stores the date the overall record is modified? Paul

How do I get ride of this error messgae?

I'm building a database for a construction database. The inventory items will have a category (10+ types) and also a sub category (10+ types). Would this be...