Generally in the progression of database building, should one crea
forms based on the tables, then create a switchboard based on thos
forms, or.. should one first create the tables, create queries in cas
of later use - then create the forms based on those queries?

While experimenting with security settings (I generally
work alone and don't use them) I managed to set a database
logon password. I thought I was just working with a copy
of an extra database so I couldn't screw anything up, but

I need help! I have a DB with 5 tables (Program, Director,Alt contact,Private Practice, hospital,and Paytype) These are the relationships between them.
There can be one program associated with one director, and program names can be very similar. There can only be on hospital ...

Hi. I have a database in access 2000. But my program that
is installed on my computor is from office xp.(I think
this is the same as 2002). How do I go about to convert my
access 2000 database to 2002?

Are there any plan for a version of Access for Mac?

Hi,
I tried to compile this:
Sub Test()
    strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")

I have a small donation tracking database with a tblDonors and a related
tblDonations.  Among other display/edit forms, it has a data entry type form
to facilitate batch entry of donations.  That form has a combobox for
selecting the [DonorID] (a required field in the donation ...

Hi, Does anyone know how to write a line of code to change
the background colour per line of infomation by 2
different text boxes in Report. I have a report with 10
different Feild text boxes. The ones I wanted to change

   I need to replace multiple characters in a Replace statement and can't
figure out how to do more than one.  Any advice?  My starting statement is
below (using & as the find string).
Ship-to Name: Replace([Sales Header].[Ship-to Name],"&","")

I have a table with 150 names address's etc what I need is
to have a query? that will enable me to search the database
for a particular name or other variables as I set them up
and place it on the main switchboard so people can lookup a

I appreciate having this vehicle available to me to ask my questions and I appreciate the knowledgeable people taking the time to answer them.
I have a very simple database that tracks the equipment numbers assigned to equipment located in my facility.  I would like to design the ...

What is the equivalent code in Access SQL for the following T-SQL block:
IF EXISTS (SELECT * FROM orders WHERE amt > 10)
BEGIN
   ...do something

The following will work in T-SQL:
DELETE FROM orders
FROM orders o INNER JOIN orderdetail od ON o.orderid=od.orderid
WHERE od.billitem='a2220'

I get following message:
The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)
when I try to connect to my db from another computer.
What should I do?

I've converted a database from 97 to 2000 and the =date()
function will not work.
It just doesn't work at all!
I get the following error message: Unknown function 'Date'