1. I have set up a DB in access 2003 (ac200 format). I have split the db to front/back end. Installing a new version of the front end is easy. Copy - paste -...

Hi I have been going through the At Your Survey template (thank you Duane) and have a question. I would like my 'RspnsType' to be various things, some...

If what I am considering is poor DB design I don't want to do it,,so if someone could give me clue I'd appreciate it. I have a particular table that I'd like...

I am new at this so please have patience with the ignorant. I do not understand what is happening and hope someone can explain. I have two tables: Table 1...

Is there a way to export a pivot chart to an html in chart view instead of datasheet view? I have been successful at exporting in datasheet view, but I'd like...

Hi all I'd like advice on the following issue: I have a "Categories" table with fields (*CatID, CatName), and in my "Items" table I need to have the necessary...

I am trying to put a unique constraint on three fields of a table, but in the Index dialog it complains that I have three rows with the same name. So, when I...

Hi, Basically I have a Database that keeps a log of all call monitoring sessions (where you listen to someones phone calls and give them marks if they fulfil...

I am trying to create a database for my wife for Mary Kay. I need to be able to input product info, customer info, and use those databases to create orders. ...

I've got a form based on a table in my application, and I have a command button that does some processing after filling in the fields for a record. When the...

I have multiple queries that have data which was accumulated. I was able to calculate the totals of each field at the bottom. However I now need to...

I just started using access created table with number fields. Set the number fields to long integer, fixed 2 decimal places. Everytime I put a number in it...

I am looking to have my query to pull info from a table and not to return any duplicate values. In my table I have a date column and I want to populate (from...

I have a MS Office 2000 Access program that I would like to clear the data out of. The problem is that I did not write the program and it has data (approx...

Hello I have a collection of qualitative information on a large number of investment funds. For each fund there is a manager (lots of related...

I have inherited a database which is split and containes linked tables. I need to obtain the file path to the linked tables to source the backend data tables.

I'm designing an employee evaluation program. Most of the items being evaluated at rated as either Satisfactory or Unsatisfactory (e.g. Employee is punctual),...

I want to have Access add the next number in a sequence to the Next Record automatically. My format is D-2467 and I want Access to add the next number which...

I am a coordinator for the local AARP tax aide program. I want to create database for the local sites that I run. Site table. How can I construct the Site Info...

I need to link tables, or queries so that an existing table which contains names, and address information can be linked to another table where information...