I am trying to preview my form and the message keeps coming up " The specified field 'PostalCode' could refer to more than one table listed in the FROM clause...

Assume in my Sales Form that I have 5 Fields labeled Name, Address, City, Country, and Zip - the other fields about quantoty and sales don't matter at this...

I am making a horse show database. Setting up one to many relationships between the tables. The problem is that when I try to add records in data sheet view...

Using Access 2003 - all screens (forms, reports, etc.) opened maximized until I performed Compact and Repair. Now the opening main screen (switchboard) opens...

I have tried using the current formula online ...namely... =DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format( , "mmdd") ) but the program ...

On one of my forms I cannot add new records even though the allow additions, etc., properties are all set to yes. The new record button is dimmed on my toolbar...

I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See...

I have a table, tblPatientV1, and a table, tblStatusV1. tblStatusV1 has two fields; ID and Status. Status has Active, Inactive, and Discharged entered as...

Ref "Why is my text being stored as Numeric" 13-Sep-05 Tina provided final solution to my question/need with this code. SELECT Count(tblPatientV1.ChartNumber)...

How can I use DLookUp or other function in a Form to display data (say a persons name) as soon as the person's ID is entered in the transaction form? Or is...

I am making a database that is meant to calculate the commissions for our salesreps from several sources of income. I have a master form with subforms for...

I am making a database that is meant to calculate the commissions for our salesreps from several sources of income. I have a master form with subforms for...

Hi, I am trying to create a database in Access 2003 to get rid of my excel spreadsheets and enhance reporting. I work for a non-profit and have to track...

Okay, so I'm using Access 2000 and I'm not a programer so please speak in plain english. I have a table of all donations made and a table of all checks cut...

I'm creating a form and while going and back and forth I can no longer view my form!

I set up a temporary table to be able to copy names & values via the internet to excel and then into my database. I only used it once, and now whenever I...

How can I protect the design of my objects in an Access 2003 database? I want my users to be able to insert, delete, and modify data, but I do not want them to...

Hi all 1) I am rank ameture at Access 2) I am having trouble getting started with a particular database project 3) Words are all I have to express my...

While using Microsoft office access 2000 program I tried to close it down and it would not close the file I had created. the computer would not let me close it...

I have a main table that when you open-you can open other info with the +. I have the main table with one to one relationship to each table such as: Main...