I am about to split a large Access 2000 DB. The BE end will reside on a file server with 4 versions of FE distributed to a variety of users on their desktops....

on a form I have two fields. the first is ssn and the second we'll call mmm. mmm is 90% populated with the same data entry as ssn but not 100%. so the user is...

Hi all, I'll try and explain this as best I can to make it easy on you. My database is for keeping track of documents, drawings and action items all relating...

I am having difficulty with normalizing data. I am creating a client call center database. Currently, when a call comes in from a Client Contact, the users...

I have 3 tables which are in a many-many-many relationship: tblMSDSs - a table of Material Safety Data Sheets which describe the chemicals in a...

Hi all :-) - Access 2003 - XP Pro SP2 I need to filter data in a table by one or more criteria, such as parcel number, zip code, map number, etc. either one...

I have a yes/no field and a text field. I want the text field to be null if the yes/no field is no and required of the user to enter data if the yes/no field...

If I have table student and table classes (1) What is your favorite naming convention to creating the many-to-many table that holds the foreign keys for...

How do I write a program to CRUD (create, read, update & delete) comment fields in columns, tables and other entities? Thanks Sieg

Firstly can somebody please tell me if it is possible to do a database design change on a separate copy of my database and then bring it on to update the one I...

I have two tables in a database designed to store exam questions. One table has the text of the question and answer choices, along with other textual fields...

I have a table TBL_Tech that has its PK as the TechID. This is the FK for two other tables. I just found out that after a tech is terminated, the supervisor...

I am in the process of designing an access file to sort and analyze data from a survey. There is one survey question that has multiple answers (respondent can...

the ingredients of my situation consist in three tables a) Audit Reports (parent): PK = "IRB Number" b) Evaluations: PK = "IRB Number" and "Date of...

I would like to print selective information about a table. Will this utility or another like it print selective info? Where can I download this? Thanks Dave

I need to set up a table/query system that will allow me to enter daily information about several different units. Example: unit data info etc.. 1 .... ...

I'm in the midst of designing a comprehensive database for archaeological materials including tables for reports, notes, and photographs, but also integrating...

I have used the Database Splitter utility to create a "_be" version of my database and moved that to the server. Other computers have code version with tables...

I need a table that can record an unknown set of records for testing. For example, I want the user to record test results. But, until the tests are created,...

I am starting a db and I have recently heard that naming conventions are no longer recommended. This goes against any traditional understanding I was aware...