Hi, I have been successful copying a vba code from one of your posts on
how to copy and paste a record by declaring the desired fields that
needs to be copied in form's declaration and creating two button "copy"
and "paste". Works like magic.

I am trying to figure out how to lock a record at the point it is
opened in a form. The Access file is going to be stored on a Shared
drive for 3-4 users to access. I need the capability to allow the first
user to enter into the form to allow edit capabilities but if another

I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible
if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is

I have a query that produces an output similar to the sample shown
below.  These records are based on certain criteria and a date range
selected from a form.  I need to create some kind of calcualtion or
record manipulation to do the following:

In an AccessXP application I have a vba process which creates a
document on the users 'c' drive and then opens and attaches that
document to the users mail client which in this case is Groupwise. This
process works fine for all users except one, the one user gets the

I need any one's advice/imput on this...PLEASE!
My company will now begin the process of taking all the MS Access (Native
Jet Engines - x30 total  in departments) and put the tbles/BE on SQL Server
2005

I'm creating a series of forms, each with with around 15-20 text boxes.
The text boxes will show data from tables, but are unbound to make them
more flexible.
I want the form to be used for both adding new data and modifying

Is there any way to refresh a calculated control in a smooth fashion,
that is without having the control "empty" for - if only - just a split
second? I use a lot of them on my forms, but when they get refreshed
their contents flicker, because they briefly disappear before being

Hello All Database (Access) Guru's,
I am a novice when it comes to databases and I know enough to get
simple information for my needs.  With that said, I was given an
opportunity for improvement a database.  

I have security set for an Access 2002 db. I am trying to pull data
into Excel using the "new database connection" option in Excel. I
finally got this to work by creating a new ODBC and setting the correct
login and password needed to connect to the Access db and everything

I have created a recordset built from scratch, based on data from an
external, non-database source. I want to append this recordset to a
table in an Access database without using a loop to traverse through
each record and add to the table.

I have a continuous form which shows meetings that consultants have booked
for certain timeslots. The text of the field displays a short description of
the appointment and I want to set the backcolor of the field depending on
what 'meeting type' the appointment is. A user can ...

I want to create a form that will allow the user to select from a list of
available reports and based on a filter limit the records displayed in the
report. I have figured out how to access the reports collection to populate
a list box containing the report names. The filter I ...

I've been reading the newsgroups and most of the solutions for this
message are simple and obvious but unfortunately don't solve my
problem.
I have an MS-Access 2002 ADP application that connects to SQL server.

It used to be possible to send email (with the DoCmd.SendObject
acSendNoObject, , , "nickmcm@btinternet.com", , , "Email", "Enquiry",
False command), however since 2000, Microsoft has put a restraint on
this, so each email that goes out you have to confirm that Access is