I create 2 unique indexes on 2 fields: Field1 and Field2.
What is the way generate custom error message independent of each
field?ex.:
"Duplicate value in Field1" or "Duplicate value in Field2".

I have a database that users may email a certain report to each
other.  One of the users, all of a sudden, was not able to attached
the report via email functions normally.  What's happening was when
she choose "send to" > "email recipient (as attachment)" > no matter

A client of ours is having problems using our email interface.  Our
application is written in Access 2003 and the client is using
Microosft Outlook Express version 6.  We use the DoCmd SendObject
syntax and they are receiving the error "The command or action

i am a bear of very little brain so please don't use too many
abbreviations or technical jargon or it might melt alltogether... I
have created a database with Access 2007 and saved it, via the
'microsoft button' thingy as a 2003 file so it would work on the

We use an Access front-end to run reports by linking to our SQL
database.  The end users get to the Access file over Citrix and I have
a local copy on my hard drive.  The problem that I'm running into is
that queries that take seconds to complete on my local copy, end up

I have an access application that i would like users to be able to
automatically check the contents of a "version number" flat file from the
internet using a URL of my website. I need to do two things... for the user
to confirm that the currently running access application is the ...

EISWT-09 call for papers
The 2009 International Conference on Enterprise Information Systems
and Web Technologies (EISWT-09) (website: http://www.PromoteResearch.org
) will be held during July 13-16 2009 in Orlando, FL, USA. We invite

Our system has a bound form with a combo box, whose AfterUpdate event
requeries the form.  When the user manually types in a value into this
combo box, then mouses to and attempts to click on a command button,
the focus boomerangs to the first record on the form, and the button's

I'm a novice access VBA programmer. I’m trying to write a nested query
to explode the bill of material. But the BOM table has more than 20
levels. It’s really redundant  and annoying to write all those nested
queries in access. my question is, how do I approach this problem to

test
Have a nice day. ldpoos@NOPANTS.juno.com
Remove NOPANTS. To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects

Dear reader,
Under | Tools | Options | the form Options will open.
Under the tab [General] you find the field "Default database folder".
By opening the form this field shows I:\.

I have a program built in Access 2000.  There is
    a "FrontEnd.mdb" with all the main tables, and
    the "User.mdb" database that has all the forms, queries, reports,
modules, etc.

I have a database called RADB.mdb.  I am working in Access 2007, but
have to create a db in Access 2000 as some users don't have Access
2007.  Everytime I setup an ODBC link in my database, Access creates a
new database in Access 97 version and puts the link there.  If I open

We are pleased to make available a free icon collection:
http://www.1stlogodesign.com/forms/free_icons.htm
Enjoy,
1st Logo Design Team

Sorry for posting my question about linking to spreadsheets twice.  I
got an error on the first one, so thought I needed to post again.
Cheers,
Franc.