Hello, This is a continuation of an earlier thread about Parsing strings from one field into many. I making a database,that contains five fields of overlap and...

I was under the impression that a field should always be formatted as text if the contents were not going to be used in calculations, so I formatted fields...

Hi all, I have a product table where each prod can have from 1 to 10 suppliers What is the correct way to build those tables? tblProd tblLink ...

I need to set the Allow Zero Length property of a column to true programmatically. Is there a way to use an ALTER TABLE query to modify an existing...

Hello, I have a table called Company_Locations. There is a field named Is_Main. For any given COMPANYID, i want that only one Location can have the...

I had a field in one record that suddenly changed into boxes and characters indicitive of encryption. Now when I change the field it immediately crashes the...

We are trying to design a table that has a look up field. We want it to look up from another tables look up field, which is a list. Can we do this?

Hello, I would like to obtain a sum total on reports for billing codes that identify patient charges.I have various codes so i want to specify them by their...

I want to design a table to store data on labtest aquisitions, to print out labels later. It will be a list with 100 different tests, every test with its own...

Hi, I'm wanting to set this up but am unsure of the best way to go about it. All I have is basically a 'service' which will belong to particular areas...

I am making a simple database and I was wondering how can the information from a field containing strings of both numbers and characters be broken and entered...

My company is in the middle of XP deployment, including Access 2002 upgrades. Part of the people have Access 97, part Access 2002. My problem is that the...

When I originally designed my table, I used one field for the Witness name, called . Now, I would like to divide that field into two fields: , . Is there a...

I am trying to set up a field in a database i'm creating to generate a specific format the same way Autonumber will generate a 1 then a 2 and so on. I want my...

Hi, How can i query/get the following in an MS Access 2002 Database: - 1. List of Indexed Fields in the MDB 2. All the Primary Key Fields in the MDB 3. List...

How do I have Access automaticaly insert info into one field after I have entered info into another field. Example - I want to enter an "Employee Name" in a...

Does any one know if there is any bug in Access that makes some of its tables lose their relationship to one another? this happend to me couple of times...

I would like to setup an inventory data base. This is how we run the business. We have inventory tags. The information on the tags needs to be entered. The...

Hello, On my form, i have tried the steps with the command button to open an excell worksheet on event but the results are it opens a workbook and then i...

I have a question about table design (in conjunction w/ form design). Although this question is focusing primarily on table design, I'd like to start out...