I have a user that migrated from MS Access 2000 to 2003.  When they launch
their database the get an error in their code:
Compile error:
Can't Find Project or Library

I would like to be able to have my combo box have an item at the top and be
the default selection.  Something like "[Add New Item]".  The row source is a
query to a few tables.  I can't see a way without have a record in the source
table.  

I have posted a couple of times in the DAP group, but have received no help
to question - there is also a lot of ads and testing posts there.  I'm
hoping someone here can help.  I need a command button set up on the DAP
like in a form where you have an "if" statement to open a ...

I have a form, based on a query.  However, there are a couple of fields on
the form, not in the query, that I have set the ControlSource = to a field in
a table.  I want the user to be able to change the value in the field,
therefore updating the data in the table.  Is this doable?  ...

I have a form with several subforms that help create a formal report for
control board directives.  I am trying to find a simple way to "supersede" a
record so that the administrator can revision (the original revision number
is bumped up by one) the directive with the original data ...

Hello I'm building an App that uses the switchboard functions of access.  I
have a form that can be opened from the switchboard.  This forms recordset is
a query with the criteria on one field set to "is not null".  I would like to
have a second button on the switchboard that ...

I have a working combo box that allows the user to select a value, and
the rest of the form populates with data from query results. A few
fields are editable, and I disabled the rest. This is working, but I'm
wondering what the easiest way is to make the form be blank when the

I'm sure someone's already answered this but I don't know how to classify
and/or search for the response, so I'll just ask the question. In fact, I'm
having trouble accurately describing the issue.
I have forms with command buttons that are relatively small and centered on

I am setting up an e-mail confirmation for folks who register for a retreat.  
I have all but one part working just fine.  What I would like to do is insert
a recordset into an e-mail message.  I can do one record at a time with no
problem, but when it comes to a list, I am not ...

I am using the SendObject method to e-mail a series of reports, as follows:-
DoCmd.SendObject acSendReport, stRptName, acFormatSNP, stRecipient, stCC, ,
stSubject, stMessageText
where the variable string elements are passed as parameters.  This should

I have a command button on a form that opens a report. Here is my code
Private Sub Command3_Click()
On Error GoTo Err_Command3_Click
   Dim stDocName As String

"You've used the ListIndex property incorrectly" message
Any idea what causes this message to come from code:
Me!lstReplace.ListIndex = i
i is a long

I initially passed a value to a chart via this SQL statement:
SELECT Format([Extract AAPL Interval Data].[Date],"0.00000") AS Datefmt,
[Extract AAPL Interval Data].Open, [Extract AAPL Interval Data].High,
[Extract AAPL Interval Data].Low, [Extract AAPL Interval Data].Close

I have some VBA/SQL that updates a value in a table when a user
changes a value in the form. Right now, the user's changes are
reflected in the right place. However, the data they're typing in is a
date, and what shows up in the table is 12:00:10 AM, 12:00:13 AM, or

Hello.  
I have a request from the engineers that they would like to see the changes
made in some fields similarly to what ms word does with the different colors
and lines thru what is changed.  An example would be a description that would