I am just learning to use Access 2003 and understand the basics.  To practice
with it, I made a database for the Olympics results with two tables - one
listing which nations won which events (Fields: Sport, Event, Gold, Silver,
Bronze, Event Date) with Event as the primary key; ...

Okay, so am I correct in that you should only update data in the Replica and
not the Design Master?
When I try to synchronize from the Design Master to the Replica, I get an
error message saying both items have the same ID.

I have a query which uses dlookup to looks up a value for one of the fields
in another table if it would otherwise be null. It  works fine for displaying
the data, but when I try to sort or filter on the dlookup field I get the
following error:

I try to write VBA to display data from when I click a record in datasheet
subform to textbox in form. I try to write some code on On_current( ) event as
form.text1 = subform.text1
it doesn't work.  

Hey All,
I seem to be having trouble with something that seems pretty routine. I have
one listbox (multi-column) that has Multi-Select enabled and it is based off
a query. I want to be able to select items from that listbox and then click a

I want to set up a spare computer in my store for customers to use to sign up
for our email list. The simple way would be to use Excel, but the information
would not be private.
So I'm thinking about using a database with a form they can fill out. I

2003
The routines which follow work fine with 15,000 records.
When the file size gets larger I do get overflow errors.
Background:  The VBA routines up to this point have read text files into two Tables.

I have a data entry form where the combobox looks up data from a library &
stores libraryID (autonumber from library table)
I want this combox to only select from 'current' library items in order to
limit selections to most popular items - which I do via simple tick box &

I'm really confused, why do the checkboxes in Access 2002 only return -1 and
0.  I really need 1 for "yes" and could use "n/a".  Any suggestions for an
"easy" fix without going into VBA?

i have a table that contains names of files and the hyperlink to the
file
i open the file from a combo box this has worked fine until the server
was updated

In my database I've designed in Access 2003, my reports all generate two
copies of each.  For example, if a report is 2 pages long, then the report is
actually 4 pages with the last 2 pages identical to the first 2.  
This has never been a huge problem for me, but now in a report ...

I am trying to evaluate a string by using an IIf function:
=IIf([WhoPaysCarriage]="Receiver",0,1)
ie if the contents of the field WhoPaysCarriage contains the word Receiver
then a 0 is returned etc

I'm trying to write a query that will allow me to look up the dollar amount
greater than $350 or the Number times used greater that 10. Right now for the
Amount i have ">" Amount but when I do ">"Number time used, it doesn’t show
me the record for when it less than $350 but ...

My database is a record of CDs (programs and others) I have in CD hanging
sleeves. I designated the Auto Number field as Primary Key. I had 244
sleeves of CD records and cleaned out a lot of obselete programs to trim my
database; thinking I could use the new vacant sleeves for ...

So a few months ago I i bought Office 2007 for students through a website
that gave college students a discounted price, but I never received the cd to
download it, it was all done through the site.  My computer as since had work
done on it and office was deleted.  I still have ...