I have a recordset and I'm attempting access the fields using a variable
name.  The following doesn't work:
myItem = rs!Left(listItem, InStr(1, listItem, "(") - 1)
How would I accoumplish this?  Not sure is this matters, but the recordset

How would i go about writting code that can print a list of all the
tables/queries used within a database.  The purpose is to be able to location
tables that are no longer needed (those that were used for 1 off requests).  
I already have code that can list all the objects (tables ...

I have a table with 3 fields; I'll call them Time1, Time2, Time3.  For
different users these three fields represent different times.  For example
for User1 - Time1 represents "24 hours" and for User2 - Time1 represents "48
Hours".  These values are set in another table "Time ...

First of all, I am not a bonafide developer, so please forgive what may be a
very basic question.
i have been tasked with developing a management database that will interface
with multiple Word documents.  Using VBA, I have achieved success with Office

Im using Access 200. I have made a database for machine maintenance. How can
I set up a task generator to tell me what is due for a desired time period?
Example: I come to work on Monday and I want to see what tasks are due that
week, month, whatever. If I say a weekly task is to ...

I''m getting a syntax error on the following line:
DoCmd.RunSQL "UPDATE[Table1] set[InUse] = '" & str9 & "'   WHERE [Stock Num]
=   '" & str1 & "'"
The error message is saying:

When a report has no data, I would like to give the user a message and then
close the report.  I tried the 'On No Data' event of the report, but I can't
close the report from there, at least not with DoCmd.close acReport.
Would appreciate any help/ideas?

A report is generated from user input.  However, if there is no data in the
report, I have it set up so that a message box appears  saying there is no
data for the query and then the report closes.  To determine that the report
has no data I use the report's 'On No Data' event.  ...

Is it possible to 'freeze the screen' while it performs some functions on a
form, so that when it unfreezes, all the operations are complete.
Just looks messy at the moment and i'm wondering if its possible to do
this??

Is there a way to create an option group using VBA?  I am trying to
dynamically  create a form and I need to use an option group, but I can't
seem to figure out how to create the option group using VBA.  I can create
the option buttons, but they don't work as an option group.

I'm writing a 2003 version dbase in which I need specific PO numbers for
individual purchases.  I would like a format such as mmddyy000, i.e.
101005195, where every day the system would reset back to the current date
plus 000, would autonumber, and would have the potential for ...

I have code in my db which generates an email using
   Set objOutLook = New Outlook.Application
   Set objMail = objOutLook.CreateItem(olMailItem)
Is there a way to add an Outlook signature to the email, eg a disclaimer? I

Is there a way to trap this event (however caused - close button, file menu,
quit etc.), so that vb code or a macro can run before Access closes?
The database in question is already set to compact on close, so Access knows
how to do it!

Where can I get copies of directory ACCRT (MS Access RunTime) and
setupacc.exe?  I've purchased licenses to Office 2003 Pro and Access 2003
Developer Extensions, but I still can't find that directory and file.

I am trying to send an Access report in the body of an Outlook email rather
than as an attachment.  I find I can create a Word document using the
following code:
DoCmd.OutputTo acReport, stDocName, acFormatRTF, stOutputDocName & ".rtf",