Hello.  I would like to change the following from
If inlist = IsNull(DLookup("[CreditorName]", "tblCreditorName",
"[CreditorName]= " & "cbocreditor.Text")) Then
to

I have A2K on my computer (XP Home) to support a couple of A2K datbases.
Now I have to support some AXP databases.
Can Access2000 and Access XP live and work on a single computer?
TIA

I have a database that we have been using for 2 or so years.  The original intent for this database was only to keep track of one thing.  After that one thing was such a huge time saver, I have added bits and pieces and now the thing is quite large.  Now, I am currently re-making ...

Could somebody please help me. How do I link to databases (access) together
so that when I change something in one it will automatically change in the
other.

I have browsed this site many times and have posted a couple of times
and find most of the information helpful. However, I am still new to
Access and don't understand many of the advanced functions of Access,
so please bear with me...

When creating a button to open a form, how can I link multiple fields that
looks up matching data?

I have a table that I want to split.  I want to put some of the feilds in a
separate table.
I need to write a routine to examine each record to see if I need to create
a record in the new table, then transfer the needed data to that new

I have a table with some linked, relational values from other tables.  I
created a report based on the first table (NOTES), grouped by category (ID's
stored from a linked table).  I want the report to sort by
category/subcategory, rather than by the CategoryID which is the data ...

On windows 2000, how do i log on to my computer as local administrator in
order to have sufficient privelages?

I wonder if anyone can offer me a few suggestions on how I might go about
designing a travel and absence list/calendar. Perhaps someone has already
written a program to do this and can let me have some code to work on, or if
anyone knows of software out there that might do what I ...

I have a form based on a single query. qryThree
The query is based on another query, qryTwo  which links data from two
sources. One table, one query. tblOne and qryOne
I am prevented from changing the data in qryThree. I know that this is

I'm building my first database, and I couldn't find info on this through the
search engine here.  I have a list of records accessible through a main form,
and for each record, I want to have a button/link/something to click on that
will open up a .pdf document specific to that ...

I am running macros in database #1 by calling them from database #2.
Database 1 is never opened.  Is there a way to compact and repair database
#1 from database #2 without having to open #1 manually and use the "Database
Utilities" menu option?

I have a membership table [tblMembers2004] and another table
[tblMembersNov2004] that has the current information for many of the
members in [tblMembers2004]
I need to superimpose, ( or replace the complete record), of  the

Help! Such a simple question! I need to email a document to someone. How can
I find out what size it is, so that it does not overload their in-box? (I
can't believe finding this out is SO difficult: getting to here has taken me
three days). And while I am here,