I have a main prospect table that I need to input info from another table that holds school information. How do I lookup the school information from the one...

I keep Receiving the error message that my I cannot designate a field as the primary key because it contains a null value. The field does not contain any...

I have a situation where I have quasi-duplicate data which looks like the following: Unique ID Name Location Color Revenue 1 A ...

i would like to build a simple, single table database, but i'm having some difficulty figuring out interactivity. also, i'm new to Access. 1) i want to...

i wanted to know who logged in into the database for access 2003. any help?

My dear friends: I am an MS access beginner. I developed a database and i created a date field. To fill that date frield in the form, instead of a single...

When I first created my db I encountered a problem after I split and moved it to a new location. I somehow manually modified my table links and it would work...

I am exporting the results of a query as undelimited text file. I have used the query to format some of the fields to "fill" the field with leading zeros...

I was talking to Ken Sheridan on 1/9/07 about my packing slip. I have made my packing slip but the information doen't automatically fill in from the...

I have a database with 2 date fields on my form Date from and date to If I want to view today's list I run a query I have setup with the criteria as...

I just created a form that opens and functions perfectly from the database window. When I try to open it from the switchboard,"error 3021, no current record...

I am writing a user manual for an Access project, and I keep using awkward descriptions like "click the upper-left square in the datasheet pane of the form,...

Can someone point me to a good line by line explaination of how to set securities on my DB. I downloaded a SECFAQ file and it is completely wrong. I've...

I have a serious criteria issue. This is what I have as of right now but it is too wordy. Between And Where is the scernario, this qery will beran every...

I have the following table and I think I need a on to many relationship. I have 2 tables Table 1: People Table 2: Communication People has fields , ,...

Hi. I'm trying to create a form in Access 2003 to enter data about the kinds of assistance patients need -- dressing, washing and so on. Patients will...

What connection is necessary to have a foreign key column fill automatically? table1 pk table2 pk fk I have a one to many relationship between Genus(1) and...

There's probably a simple answer to this, but I can't find it. I can tab through the mainform,subform and back to the mainform with no problems on the FIRST...

I want to be able to select from a combo box list in a form a product, and it's price to show up in a separate field in the same form. I can't seem to find...

I have a form linked to a table (Access 2003). The user selects one of two command buttons either AddNewRecIN or AddNewRecOUT. They both then disable other...