Okay, I have relied on these forums quite a bit for the old version of the database I have created, but I now need to expand it. I'm going to attempt to start...

Hi Im trying to create a seating chart that is visible on a booking form and is updated everytime a booking is made for a performance (using that...

I am busy with my database at the moment and where I initially thought that I will have 1 Table for e.g all Personal Information I am realizing that if I do it...

Hello, As far as a Primary Key is concerned (for an Employee Table) I have read numerous times on the boards NOT to use the Auto Number feature, I'm not sure...

I have two fields in one of my tables that should only be populated if they're both populated. If either one is null, they must both be null. The fields are...

Can someone please tell me if this is this a six of one situation or not? A db is now set up with one main table housing ID numbers, names, and grade...

I have an IT-generated database with a non-duplicating primary key that is a text field- unique inventory part. I now need to design an expanded database on my...

I have a db in access 2003 to track our clients, the realestate contract's info, the jobsite (where we are building) the lender, etc. Now I need help. I...

What I need to do should be the simplest thing in the world, but I have scoured the training pages, the help files, faqs, technical articles and sample...

I am trying to get a DB together that includes information about employees. Some of the employees are in multiple departments. I am wondering how to set up...

Hi all, In a 5000 records table i need a string field that will be less than 255 char. Most of the time a record is around 130 char 1. Is it better to use a...

Could you please give me the design reasons for splitting a database - ie front end back end. I am building a database as it is being used (not ideal but life...

Hi: I'm not new to database design, however, I am inexperienced with Access. I'm trying to build the classic Many to Many application for Students...

I understand that I need to build table relationships based on IDs, not on text values that may change over the life of the database. I have read in this...

I'm a trainer and I need to delete the custom input masks that the students build.

Hello, I was builiding a database for co-worker of mine. I have a form with drop down box with usernames, Status and when status changes to "Complete" it...

I'M TRYING TO SETUP A DATABASE FOR OUR REAL ESTATE RENTAL BUSINESS AND I AM BRAND NEW TO ACCESS. I NEED TO SHOW WHICH PARK THE UNITS ARE IN, THE ADDRESS,...

I need to create an Access field with a fixed length of 2000 characters. This field is part of a fixed length flat file of billing data that will be uploaded...

Hello. If I link a table to my Access DB from another Access DB the absolute path to this DB is used. When I upload the database to the server, where I...

I have a field where a date of completion for a project is entered. I want the system to automatically switch the field where open/completion is indicated...