Below is code behind a form that allows users to select from a list of names
which creates a mailing label list.  When the form is opened, the following
error message appears "Compile Error.  Error in Loading DLL".  When I debug,
the word "Connection" is highlighted.

Access 2003, 2000 format, SQL Server 2000
I have a stored procedure that works perfectly in SQL Query Analyser.  I
want to be able to create a recordset of the results from within Access.  I
am using ADO

Good Day,
I have a form that I use for my order entries.... I have three types of
orders: Custom, Program, and Sample. If the order is a custom or sample
order, the user will input all order details... (design name, design number,

I have imported a flat text file with some information missing in Access 2000
The data is stored in a table where there are blank entries for "dates" but
the date is the same as the leading date:
i.e.

I have an existing database and have recently created a form for staff to add
data to it easier than before.  I'm having trouble finding code to import
this data as most are for new forms going to new databases. I've found the
code below and don't know if it's a case of just ...

Hi all again!
I'm sure there's a way that users can be informed, via a MsgBox, that one or
more fields are incomplete, but searching the group archives doesn't seem to
be able to pinpoint what I want to do... which is reproduce something like

if a value is enterd into a field on a form which is a reqired,unique
indexed field in the underlying table, how can messages from db be supressed
when it is maybe already in ?
I trap these wrong inputs and wrote my own stuff but I would like to handle

does anyone know how to set a validation rule based on the answer to a combo
box...
eg - customer provides a phone number in one answer then is asked "do you
want an SMS notification" - a yes is only valid if there is a mobile number

Hi
I am building one application in ms access 2003.
what basically does is it execute some function of other database. to achieve this i had put all functions in startup of other database...
(i.e. function is called in form loading event and form is setup as startup object)

In another thread, I've had a single discussion about
reading e-mail addresses from the Windows Address
Book. That discussion led to the discovery of a
kWAB.dll found by Dirk Goldgar at:

  I have a combo box that I use for my order entries, the combo box is
based on the values that I have entered:
   Column 1 > Order Type > I want to save this to field ordertype in my
tblorders

 this is what I am trying to do. I have an orders form that my employes use
for entering new orders. I want the users to be able to enter the form
without having to enter a password to enter a new record, but only if they
wanted to edit a record... is this possible? if so can ...

Group
Problem:
I have a form with a subform on it. From the parent or main form I open
another form using a command button is it possible - from this form that I

   I have a table with the autonumber field. I need to override the
autonumber field and enter some old values. How do I temporarily switch off
the autonumber field for these values. Then restore the autonumbering
functionality after these records are written?? What I need is ...

I need to account for every variation of date (complete, incomplete and
blank).  The date/time fields only allow for a complete entry (ie 2/2/02)  
and not (unk/unk/94).  Is there a different format field I could use that
will allow me to enter in some incomplete dates?