I have 3 tables titled "Dept", "Event", Student",
Table Dept Fields are: DeptID (Autonumber) & Dept (text)
In Tabel Event I have the field : Dept
In Table Student I have the field: DeptID

Okay - I have ensureed that the fields are set to double.  I have 2
different forms because the information has to be calculated different ways
for different customers.  I can see in my detail form that the decimals are
correct (going to tenths) but in the summary form it constantly ...

Does anyone know if access provides online documentation for dlookup?
I am using access 2002
What follows my name below is all I get (with no reference to dlookup) when
i search for dlookup.

    I have created a switchboard that link to mulitple report.
Example: First page is the main menu with 3 buttons...i name this page(Main
Menu)
              Second: When i click on button 1, 2, or 3 it take me to the

I have a MS Access database prepared in Access Office 2003.  The database is
used in a forensic science lab to sort scanned images of handwriting.  I can
easily print the reports with the scanned images.  
How can I either e-mail the reports with the scanned images or save them in ...

I have 5 different buyer levels. All can purchase the same products but each
Buyer pays a different price according to their buying level. I am totally
lost on hbow to set this up without having 5 different Databases.

I can't seem to find the horizontal Ruler.  Please help.

Access Newbie needs help with QBE grid...
My DB has fields for CompanyName and Status. The Company name does not have
an ID or reference number, it's just chosen from a drop down I've provided
from a choice of about 80.

How do you make the macros warning appearing on opening a database in 2003
revert to the way 2000 handles it? There is no warning in 2000 and a warning
always appears in 2003 (albeit there is no macros or code in modules):
security is set to medium in both.

I always need to use the Find and Replace to locate records in Access tables
of which are related to a Excel file. All I need to do is to copy a key word
from the Excel file and paste it to the Find What text box of the Find and
Replace. The corresponding records will come out. ...

Hi, all,
I have a problem while creating a Access databse. In this db, there is an  
"Employee" table linked to other Access database. In this db, I also have
table "Team A Member" and table "Team B Member" generated by make-table query

I am very new to this, so this may be the stupid question of the day
but I've searched and can't quite find the answer I'm looking for
1.  I created a table and a form, then in order for two of us t
utilize the form to populate the table, I split the database, wit

I have a checkbox that, if ticked, a couple of other text-boxes are
enabled... and disabled if not ticked.
While the contents are bound to a field in my table, the enabled/disabled
property is not, therefore if I tick the box and enable the text boxes in one

We have a database with a mailing address and ship to address.  We want the
mailing address to automatically populate to the ship to address but we want
to be able to change the ship to address, if needed, without having an effect
on the mailing address.  The Northwind DB sent ...

I want to the words "Heartland Resources" to be in the shape of a heart.  I'm
in Publisher 2003.