I have 2 tables, Table 1 has Name, NameID, and A, B, C fields.
Table 2 has Name, NameID, and D, E fields.
Several of the Names/NameID are the same in both databases.  I want my
merged the tables so each record looks like; Name, NameID, A, B, C, D,

I posted a question on 5/5/08 asking how to trap an error caused by
multiple users trying to access the same patient.  Here's what I
posted:
"Using A2003.  I've got an FE with a main form with a subform.  The

I am putting together a DB for the first time and need some guidance
as to what would be the best way to setup my tables. My database will
include employees (some who work at home), stores (where employees
work, and where things are mailed), regional offices (where employees

I have an Access 2000 mde application which uses ADO and pass through
queries to communicate with SQL Server 7, 2000 or 2005.
Some of my customers, especially those with SQL Server 2005, have had
pass-through queries fail due to intermittent connection failures.

I have a transactions table and a balance table that look something
like this:
tblTransactions
TransactionID (PK Autonumber)

I'm using a 2003 database in 2007. The database has a cutom toolbar,
which has been working fine, but now I need to add an item to it. Can
anyboy tell me how I do it?
Thanks

I am looking for VBA code that will work with Access 2003 to enable
dragging and dropping a file/folder name from Windows XP Explorer into
an Access form's text box.  This is a common functionality that most
Windows programs have, so I'm suprised it's not easier to implement in

When I try to count the number of checkboxes containing a check inside
I receive a negative number (-1) for each checked checkbox. This is in
a query.
What can I do to change my query so that a (-1) does not return as

Here is what I have so far, it loops while the PW is incorrect, or
until cancel is selected. I want it to lock the tables for adds,
deletes, and edits when cancel is selected, and if the PW is correct.
I want this to run when the DB is opened, I would also like the text

I, and some collegues of mine, are running into a weird problem with
Access 2003. If I want to define a new query (or want to add a table
or query to an existing query), Access shows a dialog with three tabs:
Tables, Queries and Both (the exact names may be off, I am using a

I have a small office (in a workgroup environment not a domain) that has a
number of DBs that reside on one XP PC and shared for everyone to use.  All
users have mapped drives to this share and when they tried to open a DB they
got the message:

I have recently moved from A97 to A2003.
I find it inconvenient that I can no longer double-click on the subform
to open it in full view.  I had a hunt around the newgroups and couldn't
find anything helpful.

I can't figure out how a report on a form (form contains two text
boxes for beginning and end dates of report) and a drop down combo box
also on the same form (that allows for selection of county) are
connected to produce a report sorted by county?

I am using VBA in access to perform some calculations. There is a
particular sumation that is wrong (barely).
this code is withing a loop.
       TDist = TDist + TempDist

I have an app on three different machines; front end on the PC, backend
on the network.
These are my results on loading the application when I press OK from the
Logon form (username/pw) to presenting the opening form and finishing