I don't know if this should go in VBA or forms area, so i'm going in general
of hopes of a response.
I have a program that creates new tables/table entries in a database.  In
the database there's a form open that would show information from a main

i have 8 separate tables and dont understand why they need relationships if
they are in the same db. im told the need relationships. i add a common field
to each and attempt to relate them. i am allowed to create my query and form
then. then i try to add data with my form, i get ...

In need of assistance generating a query that would return results based on
ethnicity of the population of my company.  
I need to (i dont know which is best) query/sort/filter/etc...) out the
first person in each designated race by the date they arrived here.  I want

Windows xp, Access 2000 Outlook Express 6
I am using DoCmd.SendObject to send emails - just sending a message text but no object.
I run the code -
SendObject works once - one email is placed in the outbox - but then does nothing (no error is generated)

Help.
I am getting this error after enetering new samples in to the databse. We
use an older version of Access (2000). I will not let me open reports or
sample lists in the months these sample are due to be tested. However, I can

I have a table that has sensitive data on it and Management wants me to
delete that piece of data after seven days have elapsed.  I have made a
select query to do what I want but when I change to an Update query I get
messages indicating my expressions that I am using are ...

Is there anyway to turn confirmation messages for record changes, action
queries and document deletions off at the database level?  Instead of going
to the Tools menu and then selecting Options on each PC that accesses the
database, is there anyway to program it into the database ...

I have a master report with 2 sub reports all tied together based on Employee
#. It is a report for payroll, it adds totals from all three reports for a
grand total. The problem I have is sometimes when a subreport is not created
for an employee my grand total shows Error.

In Access 2003 I could qickly scroll through form records with the mouse
wheel.  In Access 2007 the only way to advance seems to be Page Up or Down.  
The mouse wheel does not move to the next or previous records.  I can not
find a way to change setting to all this navigation ...

can one field within a record switch between two or more records to read
other fields within it using an IF statement?  How would I set it up?
example:
IF sectionnumber = 1 then

As we all know, rolling you're mouse wheel while in a form, will navigate
through records.
Rather than turn this off, can I just make it so that if I roll the mouse
wheel, then it brings me to the last record in a form?

Ok this is the problem, I will start from scratch.
Im making a database that multiple users will need to use to record there
actions, and i need to record the names of the people against every action.
For example, at present i have created a dropdown bow so the user can select

I have a button in a form that "on click" occurred
DoCmd.OpenQuery ("my_update_query")
How do I run this update query without any questions or messages ?  just to
do the update and that's all.

dear sir I am desperate I tried every combination of my used pass word and
am having no luck a computer  repair person who wants' $50 to do it which I
don't have right now so I have to waited please advise sincerely James up
Kearney

just checking on my order
customer #35497865
order#101278817