I am working with Access 2000 and need to add a NULL value to a validation rule to allow a specific field to be left blank in a table. I know I need to add...

Hi, I'm helping a local county office with a fairly big project. This county office does Assessment, Taxation, Survey, etc. We're just at the beginning stages...

I have a table here that will store currency values. I've been reading up on the differences between the datatypes available and there seem to be 2 viable...

Hello, I have a table in access which stores my customer information. It allows the customer to enter in a billing address and a shipping address (if...

I'm trying to figure out the best design for a new database for a composite primary key (CPK) where one of the fields may be a NULL - a violation of a primary...

I have a flat database that will not do.. and need to make it as relational as I possibly can. This is for a non-profit organization, and deals with coal...

I'm looking for some information on how to best design a transaction table for monthly payments in regards to rentals. The specifics things I can think of is...

Hello, I have an Access Aplication that I designed & it currently resides on a Server here in our office & has other offices from different...

Hello! The question could not be pacific, but I would like an indication, in case that it were linear. To manage 100 records in Access (without forms), what...

I am trying to build a one to many relationship where the One is a normal field named 'UserID' within the first table while the Many is a Primary Key named...

Hi, I have created an access database that keeps track of equipment. The database works great but I have forgotten to incorporate a certain part. When I...

Folks, Hi. I have an Access file that consists of a single flat file table. I'd like to create a series of tables that are normalized. I would like to do this...

I have an excel spreadsheet that has contact data in one colume as follows: name1 company1 street1 town, st zip 1 blank line name2 company2

Hello, I have updated a text field with one of a memo field. There are entries that have been truncated. Is there a way to search for all fields with 255...

I have a few simple questions: 1. How can I know the actual size in KBs of each table in my database? 2. Is there a way to force a database attached to a...

I have a table of customer journal entries (charges, credits)... I'd like the customer invoice to only show current fiscal year activity. What's the best way...

2 questions I have a field called flight number inwhich I place a carrier code and a 4 digit number Can I arrange the entry so that only a specific 2 character...

im facing some difficulty here, i got one field which is number data type, but i want to limit the digit enter into this field is limit to 8 digits. i dont...

Hi Experts, Here again as usual. :-) I'd like to get opinions and/or pinters to achive the following: I would like to query an mdb's/mde's MSysObjects from...

A little background: as you may know, I am attempting to "fix" my employer's existing database. We are a non-profit (i.e., NO budget for someone to help me...