All,
I am trying to export one of my query result to an excel spreadsheet using
the "docmd.transferspreadsheet" option. Everything is working fine except for
this issue. Whenever I export the data, it just overrides any previous data

I am trying to update a field in a different table and having no luck with my
code shown below,  does anyone know why this is not working.  I get a
Run-time error '3219' "Invalid operation".
Private Sub cmdSave_Click()

i need some help to correct the below code. Thanks
Public Sub Check_Records()
Dim dbs As DAO.Database, qdfCurr As DAO.QueryDef, rst As DAO.Recordset,
strSQL As String

Is there a way I can set the caption of a label in a form in another
database? I am trying to use DoCmd.SetProperty
(filename.Form_Main_Menu.Label8,acPropertyCaption,"new value") but it won't
work.

I have a form with a "nature" combobox.
I want to have different comboboxes appear based on the selection in the
"nature" combobox.
I suspect, I need to have an "after update" macro for the "nature" combobox

I have a simple form with 2 buttons and text box. When the user clicks
the "Select File"  button this allows them to browse their hard drive
and select a csv file. The patch to the csv file is in the text box.
The second button is "Import File" which the user would click and

I was hoping someone could elaborate on how to automate compact and repair on
a db.  I have a db that i wish to implement for a charity.  It is split
(front-end ... Back-end...).  the db is half way around the world and on a
network that I cannot access so I need it to operate ...

I have two tables in my Access database.  One table is named Cases and the
other table is named Subpoena.  My objective is to look up a CasFileID in the
Cases table and make sure it matches the field File_ID which is a field
located in the Subpoeana table.  When the user types in ...

I am trying to use the imagelist control to store pictures that I can use to
animate an image control on a form.  I cannot figure out how to assign one of
the images in the imagelist to the image control.
Does anyone know how to do this?

In previous databases I've used the following:
Using a form (called frmEnquiryForm) I'm attempting to look up a table that
has peoples names and addresses:
In the table and placed on the form is a field "ID" which holds the names of

I'm looking for some wisdom on a technique or method that lets me keep track
of incremental saves to a database as I write code to automate database
functions.
Looking for anything you all have done or currently do in order to keep

I am trying to change the table that a combo box is populated based on a user
selection.  Basically, I am just changing the variable 'strKits' and
executing the following code:
   obj.cboKit_PN.RowSource = "SELECT [" & strKits _

I'm trying to to delete a single record.
Using the following:
----code-------
SaleNo As Long

I have an application where I email a person data from a form. On that form
is a combo box which shows the second field of a table ( field 1 is the ID
and field 2 is a name). When I include the contents of the combobox in the
mail I always get the first field. Is there a way to ...

i have a database used at work to track certin accounts.  recently, we have
decided to monitor these accounts heavily for 30 days, after which they will
be retained but there will no longer be a need to review on a daily basis.  
All i want my code to do is take the date entered ...