Hello, I'm trying to set up a form in which if a user types a product code
into one text box, in the next text box the product's description is returned.
Here are the fields and controls involved.
[EXCEPT PROD CODE1]...control name is Text260 (I'm very new at developing

I have a table that has two fields that I want to work with.  The fields are
called Distributors and Group Number.  There are many Distributors and many
Group Numbers.  The Distributors have many listings with the same group.  
There are some Distributors that have no Group ...

I have a many to many relationship that I'm trying to use an append query on:
tblContacts - ContactID (primary key), name, etc...
tblMailingList - ListID (primary key), list name
tblMailingListLINK - ContactID & TableID (one to many relationship from

I am using a select query off of a linked table (cannot change destination
table properties) and using TransferDatabase to convert query to dBase 5.0
file. I am using Left function on a double to return left 8 characters.
Problem is, conversion sets this field to 255 characters, ...

I have 8 large, complex queries:
q1, q2, q3, q4, q5, q6, q7, q8
Each one queries its own respective table:
t1, t2, t3, t4, t5, t6, t7, t8

I've had a look through the forums, but can't seem to find out how to d
this:
I'm setting up a digital register for my local school, in access.
Currently I have a linked table, with a student ID, from the schoo

I am trying to do an update query but when I run it it says double the number
of records in my table and when it updates the information, it updates the
required records with the same record ie I have about 6 records in my table,
it says you are about to append 12 records when i ...

Thanks so much to Giorgio and Michael who replied to my posting yesterday.  
I was given an excellent suggestion yesterday on how to streamline my
queries and was given the following suggestion to run the following 6 queries
in my code:

I am having some difficulties merging records together. I have a table
with this kind of data (extract of 5000+ records):
event    | F0
---------------------------

i have been getting this error window before i can get on aol...i always have
"x'" out of this..aol office cannot be started due to an error in accessing
the aol office configuration data "get storage nemt "no content""...this has
been going on for about 4 months!

hellow, how can drow information from a spesific row in an mdb file, to drow
information from a database i usually write
while (results.eof=false)
The_variable.code = Results.fileds.item(TheCode)

When I export a query, I want one of my fields to be exported in
uppercase. I've used the ">" criteria in the format and input mask fields for
my table. The field appears in uppercase when I view the query, but when it's
exported, some of the data is lowercase.

How do I create a query that uses multiple fields to do the linking between
tables when sometimes some of the values in one or two of the fields have
zero length values in them?  I cannot set a rule that will not allow zero
length because we are using a table from someone elses ...

I hit a something while typing on my keyboard now on my new messages I get
symbols while typing and dots in between words. How can I clear it?  

I have an Access 2000 database which which has one particular update query
which, from  time to time gives me problems.  It can come up with a message
saying that it can't update all the records in the query due to x number of
lock violations - but it doesn't do it all the time.