This is a strange one--
I have an Access 2K database with a split front end/back end.  There
are two tables in the back end - RFile and RLine.  There is a one to
many relationship from Rfile.Rnumber to Rline.Rnumber.  Originally I

I have a form that has a list box (unbound) which lists all the survey
names. the data is retrieved from Survey table that is made of compound
key SurveyID and SurveyEditionID (both number fields). The list box
displays both the fields. Could some one help me with the code where if

I need help anybody knows how to group a query so I can get a count of
all the same record in a field like a subtotal in excel.

718.03, 414.32 __ 1020.83, 1976.1, 352.5, 947, 718.03, 366.98
Their IDs were as
        ----------------------------------------------

I have a Back end database on a network drive.
The copies of the front end are located on individual pc's (in their C
drive). The problem arises when a laptop user naturally hooks up to the
network but then the link from the front end (in the C drive of the laptop)

HI,EVERY ONE
first problem,
i have create a database in access 2003 it worked fine untill i have
format my laptop .

       I have noticed that when I move my database onto a different
computer, I often get a message about some reference missing.  So I go
into the reference list, and find the one that says "Missing," and I
uncheck it.

Dear reader,
Is there a possibility to close a form with a dissolving effect.
It gives a nice effect instate of the hard close of the form.
Thanks for any suggestion.

i have a quick question. i have a table where we use autonumbers to
catergorize it, and another table where we use those autonumbers not as
the primary id, but still have them in the table.
is it possible to develop a query between the number and the

Is it possible to attach a SQL Server table to Access without using a
DSN?  Thanks.

Well, I sure could use some advice (& sympathy). In my Access program I
have a small table (200 entries) linked to a main table of over 35,000
entries. While trying to enter a small amount of data into a new table
(linked to the main table), I deleted the Zip code column. As you can

Anyone know how we can open the add table dialog in an Access 2000 ADP
that's using a SQL Server back end?
We've got the toolbars and menus locked down and are using custom ones.
When they open a view in design view (via a query manager form), we run

I've got the following tables
tblMaster
  masterID
  etc

I'm new to Reports, so please bear with me.
I have a query that produces a list of participants by project.  It
also produces a list of files by project (participants and files are
both many-to-many joins with project):

Is there a simple way to allow someone to access a backend on my
computer with another person over the internet?