Inputting should happen via forms so you can validate the input before making it effective -----Original Message----- I have a table in access with a few...

I am creating a table, which includes a field titled Problems. This field needs to handle multiple entries, e.g., 1. Called vendor 01/02/03 2. Called vendor...

I am trying to use the template for Order Entry supplied, but when I try to complete the first customer order, I get a pop-up box telling me that a required...

Does it really matter what width text columns are set to so long as the length is long enough. I've seen systems where every text column was set to lengths of...

Hi Folks, I have a table with an 'attainment' column and a 'numerical value' column. When an attainment value of say 'P1' is entered I want the 'numerical...

I split my database but know we need to put it back to what it originaly was. How do you do it? I deleted all the split tables and then imported the tables...

HI I want to add the current month to my table each time a record is added so I can query by calendar month is this possible if so how I can add whole date but...

Anyone Know how to Change Table field captions using VBA code.

Hi, I have been trying to figure this out myself but just can't figure out the best way to track employee availability. Employees dictate their schedule so I...

Hi, I've had a look around in some of the questions here and especially the ones from Tina, Allan and Rebecca - but I'm a bit stuck; I need a little sparring...

Does anyone know where I might get a list of States(US) and countries of the World that I can pull into a tracking database I'm building.

Is there a way to change the line color so when someone opens a table the color of each row alternates (say between yellow and white) in other words the row...

When I append one table to another through a query I am losing data in some of my fields. I'd like to know why this is happening and how it can be prevented...

Hi, Let's say my access database is created with forms, tables, reports etc. It is working great in MS Access but now I'm ready for transfer it to a really...

I flicked from table view to design view to make sure that all the fields were correct and when I tried to flick back to table view, it asked me to save my...

created a database firstly tables then queries then templated forms, now i have added more fields to the form but when i try to retreive that info back on the...

I need to revise the structure of a data base application that I have developed, so that the application can be "validated". One part is that I need a way to...

I am creating a form using a calander and trying to link the date back to the table in the database. the problem I'm having is access is creating a time for...

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

I'm fixing an existing database. The primary key is a numerical field, consecutive, and the owners would like the next number in line to auto-populate in that...