Is there an easy way of turning these off in Access 2000?
It would be ideal if I could turn them off for specific action queries I
want to run when particular forms are opened or closed.
Steve

I have a form which has a control bound to a hyperlink
field in a table.  I want to be able to click on the
hyperlink and have it open a word document to a bookmark.  
I can select the file for the hyperlink okay and it opens

We have an array of data, all doubles.
The array lengths vary...
from a possible length of 1 to 132 ...
we have done the path of each record contains 12 elements

Is there anyway to suppress this message box from opening
and instead
to code the command button to exit the form in the event
of an error ?

I have this code on one form
Private Sub Owner_DblClick(Cancel As Integer
On Error GoTo Err_Owner_DblClic
   Dim lngOwner As Lon

I need to do a query to display records where the qcdate field is within the
past 5 work days.  Does anyone have some ideas for me?  I stuck good on this
one
Thanks in advance,

Do you want to attend a LIVE Internet classroom with us?
www.velocitystudy.com is offering 100 IT students a free introductory
training session. Please visit www.velocitystudy.com to register for you
introductory session.

I am very new to Access and have been working forever to try to get a simple form together for my boss.  It's a form which tracks incoming work orders on vehicles complete with a work order number, date incoming, date expected back, date sent out for service, where and a few ...

This is one of my blind spots.
I've three tables:  tblCustomer, tblOrder and tblOrderDetails.
I've joined tblCustomer and tblOrder on CustomerID and tblOrder and
tblOrderDetails on OrderID.   One customer places many orders and one

How can I open my access database automatically when
Access is started.  I have specified the folder where my
database resides in Tools/Options/General/Default
database folder.  I have also tried to put the database

i have an order form and a sub form for the order details ...
i want the user to enter a product number in column 1 on the subform and
in column 2 on the sub form i want the description of the product that
has been entered to show up ... what type of control should i use for

I am having trouble trying to manually add a row to a list
box.  In all the help doco I can find it says to use
the .AddItem method.  Well there is a major problem here.  
I don't have a .Additem method for my listbox... I try to

A2K
While opening a form with a subform I keep getting a small Enter Parameter
Value dialog asking for an ID value on another form. If the other form is
open, no dialog shows. Either way, the resulting opened form is the

Where do u get an image on ticks and deers

I've been asked to help automate a Traditional Chinese Medicine
practice.   Parts of it are going to be very like Northwind, with a
tblPatients, a tblTreatmentSessions (similar to Orders), a
tblTreatmentDetails, and a tblNeedlings (like Products).