On my Form I have a Print Preview Control
My Form / has a Text Box  [tbHorseID] Control Source [HorseID]
My Report/ rptHorseInfoOwner Control Source is a query that has Field
[qHorseNameSourceAddMode.HorseID]

I'm quite a newbie. I've created 2 tables and now I want to find
duplicates between these 2 tables. The first table have 1 field while
the other have  7 fields. I already did relationship between these 2
tables and did Find Duplicates Query but I don't seem to get

I have a query with calculates production for a machine in terms of
tonnes/hr.  A use will input the starting engine hours, starting
tonnes, ending engine hours, and ending tonnes for each day.  I have
an expression in a query which will subtract the starting and ending

I have a field on my form that is required for all new records created. This
is the code I have in the BeforeUpdate event on my form.
Private Sub Form_BeforeUpdate(Cancel As Integer)
  If IsNull(Me.RequestedBy) Then

I have a small sized text box in a form called frmMain. This text box may or
may not contain a large amount of text. If the text box does contain alot of
text I want to open up a new form called frmLargeText that contains a larger
text box to allow the user to easily see and edit ...

I'm working with an Access2000 database.  I have a form with a
subform.  In the subform I have some code in the Form_Current event,
and in the main form I have code in the Load event, Before_Update, and
a few other spots.  All this was working fine and I was tweaking the

If you enter something other than a number , I want a message box to
apperar:
MsgBox "You Must enter a number from 0-100", vbApplicationModal +
vbInformation + vbOKOnly

I have a subform on another Form, The subform has a Textbox/Control Source
[ClientID] what would I need in the Textbox/Control Source [Name]  On Click
event to go to frmClientInfo,that has the same ClientID
(AutoNumber)................Thanks for any Help.....Bob

We have a multi user database which is FE/BE.  Every so often I have to make
a change to the database code or whatever, and then re-create the MDE file.  
I then copy that into the 'public domain' for the users to access, and
everything's fine.  Once or twice I've forgotten to ...

When trying to open a Word document attachment in Outlook Express, or
sometimes just double clicking on a desktop document, Access fires up and
unsuccessfully tries to open the file.
How do I correct that problem?

I have a table that has codes like C345, B34B, C34A, and so on.
The last character is significant in that he identifes the plant location
that a part was produced.
I have done a query adding a column called LastChar using the Right function

To give me the elapsed time between 2 sets of dates and associated times, I
used a calculation and the following function to calculate it. Unfortunately,
I would like to have it formatted in DD:HH:MM instead of "x Days y Hours z
Minutes".  Can anyone help with this?  Thanks!

I have 2 tables which are absolutely identical
On top of these tables I have forms, queries and reports
I am looking for a method that I can use one version of the above for both
tables

i cannot send out emails from my outlook I've already tried adustiing account
settings & all the tips suggested on the how to/help need help with this

I'm having a hell of a time making my data access pages act the way I want.
For example, I need my page to refresh the data in several combo boxes when
a user wants to add more options to it.
I also need my page to remember what record it was on, unfortunaly my server