=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
&Forms!Form B_W Master Data!MachineID)
Could someone look at this formula and tell me where i'm going wrong....
Thanks in advance

I am using A97.
I am carrying out various measures to improve the performance of my db, and
one of these is to create more indexes in some of the tables. I understand
(I think!) that it is important to index those fields that are used in

I shared a database in the network. However, sometimes when a user (A) used
the database and met a problem, other users cannot open the database. I
discovered that this is due to the locking information .ldb file
The database need to close properly by user (A) so that the database ...

I have an mdb that links to tables in another mdb.  Relationships are
defined in both places and they are not the same.  
When running the program which does it follow?  Can I delete all
relationships of the mdb with the definition of forms/queries...?

I'm using access 2002 and I'm trying to automate a procedure using a macro.
The macro essentially exports a query as html, but asks me everytime if I
want to overwrite the old file?
How do I turn the overwrite confirmation off?

Is there a template for a database that would compile all of the answers from
a survey and possibly sort by location?  

I can't set default value now() in Ms. Access table.  It's always alert "
compile error in table-level validation expression"
How should I do to solve this problem.
Thank you in advance.

as i'm in australia i would like something to help me with GST

I am trying to link the database to the net work, I need to use the benefit
of using the user name as filter to restrict the information accessed by the
database user. in this case I will not have to creat a form asking the user
to logon or even I don't have to activate the ...

1.I have a table which lists clients who need medical attention by
professional carers.
2. I have a second table which lists available carers.
3. I am designing a third table which is intended to allocate a carer to a

I have a database with several 'master' tables and numerous 'support' tables.
I'm trying to create a SQL SELECT statement that will select the 'master'
record and pull in all associated 'support' tables.  For some reason, I can't
get ACCESS to allow me to have more than one JOIN ...

I would like a template that would help me design a web sight. From here I
could post items to sell.

I seem to have problems making different tables relate to one another.  
Monthly, I import trial balance information from an Excel spreadsheet into a
new MS Access table.  I let MS Access assign it a Primary Key.  We'll call
this the "TB" table.

Hoping to find a ready made access template that can track a fleet of
vehicles and also allow me to include a photo of each vehicle.

I am trying to get past this next step in the design, and that is when it
concerns an item to be purchased, yet have a couple of different vendors to
choose from.
tblItem