I have a table of imported word docs, I am opening a recordset of this table
and trying to find a no match against a directory of files which if no match
is true will convert the file to html (prior to importing).  I can't seem to
get the rs.findfirst to work, seems to hang.  If ...

Thanks for taking the time to read my question.
I am currently using docmd.sendobject to send e-mails from my DB.  Works
great.  How can I add attachements (external files, not db objects like
tables, forms, reports ect.)  I'd like to attach 2 Word docs.

I'm trying to create a search form, which can be called by multiple forms.
I pass in the calling form name through the OpenArgs and create a
recordsetclone for searching accordingly.  This works fine, if the calling
form is a main form as (Case "Courts") follows, however, if I ...

I'm importing a file into a temporary table and after some updates to the
data, I append it to another table.  What is the best way to check if data in
Field1 in TableTemp is already in Field1 in TableAppend.

I have a project to add a several records automatically from user's prompt.
The user has to input the range of field 'Ahhoc#' to add on 'Table1'
automatically. The prompt looks like this:
From: 10101

I have an db which contains code to connect with another app (QuickBooks).  
Not all users have it installed on their machines.  For some reason the db
generates a runtime error stating a hiddden module (that I've never heard or
seen).  I assume that it is liked to the fact that ...

I have an Access 2007 application that needs to resemble a LOTUS Approach
implementation of the application.
I have been able to reproduce most of the look and feel of the Approach DB
app except for the following.

I have this code for the KeyPress event of all my combo boxes:
Private Sub <ControlName>_KeyPress(KeyAscii As Integer)
If Len(ActiveControl.Text) = 0 And KeyAscii <> 9 And KeyAscii <> 27 Then
ActiveControl.Dropdown 'dropdown on first character unless it is TAB/ESC

This seems very basic, but I can't do it:
I have a primary table with an autonumber field [Program ID] and a field
called Net_Savings.  I have a sub-table [subtblsav] with a field [Savings]
that can have multiple entries linked to each [Program ID] in the main table.

I have inherited a VBA file that uses the command: DoCmd.SendObject
acSendReport, "EmailReport", acFormatRTF, [Emailaddress], , , "ACH Deposits",
, no.  We are using Outlook 2003 and Access 2007 running an Access 2000 file.
I am told that the request for permission to send the ...

I have a computer with Vista Home Premium on it and installed Access 2003,
one of my databases opens and looks fine but not a single drop down box is
working correctly.
For Example on a customer form the address of a customer etc will appear but

I have performed a datediff on two dates / time values giving a result into
seconds and I wish to extract the day, hour and minuite portions in three
variables.
For example

I am converting an Access back end to SQL Server.  Along the way I wanted to
add two options to an Execute statement.  The second is to make it run under
SQL.  Is it possible to have 2 options and what is the correct syntax
qdf.Execute dbFailOnError dbSeeChanges

Why won’t this work? There is possibly a better way to do this. I’m a beginner.
Private Sub LandDescription_Click()
On Error GoTo Err_LandDescription_Click
Dim TmpTractFull As String

I i got a dilema i am working on, i have main form and some look-up forms, i
want to be able to open look-up form from main form using button, make some
selections and store them to variable than get data back to main form and
write it to db. Any idea on where to start ?