Is there any advantage (or disadvantage) to putting a very large lookup table in a separate mdb file? This table currently has over 8000 rows and I am being...

When creating table, got error 3191. All my field names were different. Why error?

Hello, I'm trying to see if it is possible to have a table with a look up field that updates all records when the linked table data is changed. For...

I would like to receive your feedback about my table design for forecast. The forecast is set at product customer level. What do you think about the...

I am trying to set up a database to track Girl Guide leaders in my Region along with their training and awards history. Each leader has another leader as a...

Been self-studying Access07 at home with test data from work. All databases are presently in Excel 07 format. Now I feel am ready to show my boss how...

Hello, I am getting caught up in a big logic circle and I need some help to resolve the table and relationship structure. I work for a charity. We have...

Hi! As I am entering data, a message pops up "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less...

Hi, thanks in advance for the help. I am trying to design a relatively simple database (or so I think so) in Access 2003. I have to data contained in 2 Excel...

Is it possible to change the back ground color of a filed in a table according to its value. I want this to happen when the table is in datasheet view. I...

Hi, I have read through the posts but am unclear on how I would create the above database. I am creating a database with ID,Name,Date,Time. A need to track...

I have set up a database to hold data and test parameters. Currently I have two main tables, one is a catalog of samples including a catalog number(primary...

I have a form with a text box that I use to enter dates used by queries to append information to tables and reports. I need to append a linked table that all...

I have fairly complicated database set up for construction management. I am having a problem with one new report that I need to generate. One of my tables...

I have a database that tracks projects. One project may have several appointments related to it. I have a check box to mark a project as being complete. All...

I hope my question isn't too confusing. I have many tables belonging to 3 inventory categories (Computer, Hard Drive, and Monitor). While Comp & HD...

Is there a way I can have my BE Database periodically dump all its information into an excel spreadsheet, or better yet, another access DB?

A drop down for "Manager" wasn't working on a form, so I checked the logic and the table. The table showed the Manager ID in the Manager Name field, and the...

I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current...

Hello, I'm in a position of having to develop some type of training db for my company. I must admit I'm not the most enthusiastic MS Access person but have...