I'm working with an exsisting database in 2007.  I would like to add a
control(?) to a form that would display information from a different
table.
The form is a simple way of inputing information into a table called

I have an 2000 database that is getting corrupt many times a day. The
application is sittin on a network with about 5 users accessing it.
Most times I get a call with the user saying the application needs to
be repaired. I repaire the db and 8/10 times it will repair. Lately

I have a little odd problem trying to open a form with MS Access 2002:
I use the DoCmd.OpenForm command like this:  DoCmd.OpenForm
"frm_Salespersons".
and in return the error i got everytime is:

How can I in a MDE-file disable the "startup with Right Shift Key" ?
I tried it in Options --> Startup, but can't get it working.
Thanks,
Anne

As a relative Newbie, I'd appreciate a little assistance with an A2003
DB I'm trying to enhance.
This DB handles reports made by security staff on a shift by shift
basis based on two shifts per day. The two relevant fields are called

I send out a newsletter using Access 2003 which pauses for 60 seconds
before moving on to the next recipient in the list.  This works fine
for being able to have individual emails for each person in the
query.  However, it locks up the computer until all the emails are

I am trying to upsize to SQL for the first time.
Anyone have suggestions of FREE tutorials or online books/articles?
I have ordered "Microsoft Access Developer's Guide to SQL Server" (Sams)
by Andy Baron and Mary Chipman   (which received an outstanding review

A client asked for a code book (all fields, descriptions, tables, etc.) from
our Access database.  Has anyone had to do this?  It seems to me there must
be a way to extract all this information from Access.
Any assistance would be wonderful.

Re-launch of The Gadgets Forum
------------------------------------------------
Re-launch of "The Gadgets Forum - gadgets.pk" with new and stunning
categories, now you can find latest news and reviews about the

FileMaker Business Management Software
Free trial of FileMaker Pro 8 and Business Productivity Kit software.
Try FileMaker???s database and business software tools for managing
customers, contacts, projects, assets, and more.

I am using the countinous form. I want to Enable/Disable the some
fields for perticular records as per the following condition when
open the form. I have written this code in "On Current Event". I go on
the perticular record its enable/dosable the following field for all

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.