Problem: A Word doc contains words (usually in a footnote, but doesn't have
to be), which are keys to records in an Access database. How can these Access
records be displayed when the Word items are clicked, or selected and
clicked?

Hello, I have the following code which keeps telling me that I don't have an
"End If" defined, but I have the right amount of Ifs and End Ifs.  I think
the problem is in the "Exit For" statement because if I remove it and do a
regular If test then it doesn't error out.  Am I ...

Instead of Debug.Print rst.fields(0)
how can i open a new Excel workbook and print the field in the first cell?

I have an application which is complied at Ver 9 (Access 2000) as an mde
database. I have another application also complied at Ver 9 (Access 2000) as
a mdb database.
If I open the second 2K mdb database using Access 2003 it opens fine but

I am trying to associate very short audio files with command button "click
events". Is there a way to open the Windows Media Player or some other audio
softare to'play' a short *.wav file when the user clicks a command button?  I
can code something behind the click event if I ...

How do i test a recordset before using the fields?  Can you simply test for
If not (rst.eof) and not (rst.bof) then
      debug.print rst.fields(0)
End If

I have the following situation:
In a Form, I have an Unbound Control whose Default Value is equal to a Bound
Control in the Record Source, but when I change from record to record, the
Unbound Control does not update (though the Bound Control does).  It stays on

How do I write code in a module that will act like an AutoExec macro?  
Basically, I need the same results that "sub Auto_open()" would give in
Excel.

I have 80 fields in a recordset and need to print them all.  Is there an
easier was to do it than this?
Is there some sort of command that where you say something like
debug.print      rs2.allFields  ????

I want to detect if a user has not been active and quit the application. I
have read the article Q128814 - "How to Detect User Idle Time or Inactivity"
from Microsoft.
It talks about using a form with a timer and to detect what form or control

I need to be able to get some properties from files stored on a server (in
particular the date modified and size).
I've come across the FileSystemObject on the TheAccessWeb web site, but it
requires installing and registering dll's and VB runtimes and the like.

I have an automated email code and have replaced the line
.send
with
.save

On a form with tabs, Tab1 and Tab2, with both enabled for editing.
If I set a value from 1 to 2 somewhere, how do I get Tab2 to disable to read
only state?  It is set to open the form from a VB command.

In my main form I have a subform to hold job titles. In the main form I have
a combo-box that uses the titles from the subform as a criteria for a query
to produce a job description report.
Once I have entered a new job title, how do I automatically update the combo

I am using Office 2003.
I have an Access database that opens Excel to insert data into a series of
workbooks. The subroutine containing this code is called from within a loop
of another routine. The problem is that when the loop is finished, Excel