The msaccess doesn't stop running when I close my application.
The problem occurs when I open a specific subform and is only occuring since
I've added a new subform to said subform.  If I remove the newly added
subform the problem goes away.

I have a continuous form with an unbound text box that has a DSum function as
it's control source. It is used to display the sum of a field in a query. It
works fine except that the last line of my form (the one for a new record)
displays #Error in this text box. My DSum function ...

I don't understand why the following code generates a 'Type mismatch' error:
Dim rs as DAO.recordset
dim varTemp as variant
'(rs opened and moved to a record)

Using Office 2003 and Windows XP;
I can embed an MS-Excel file as an OLE object that appears as an icon on a
user form manually.
Is there a way to programmatically export this file back out of MS-Access

I'm working with a form that displays all records, but has a filter button to
show only a certain year, or all (*).  Once prompted for the year in the
messagebox, hitting cancel returns me to the form but with NO records showing.
How can I hit cancel and have it go back to the form, ...

I am questioning my design of the form. I am doing a call tracking form for
customers. I have it set up to search for the customer in a couple of ways 1)
a combo box with all the phone numbers 2) a combo box with Last Names. The
Combo Boxes are recordset cloned on AfterUpdate.

Using Office 2003 and Windows XP;
Is it possible to code a few buttons on a userform so that when the mouse
hovers over each one, a one line description of the button appears below the
row of buttons?

I have this code that runs a (SQL Server) stored procedure using a
passthrough query.  Is there a way to change this code so that it creates an
Access table with the results in it?
Private Sub btnAccessAssocDemoVol_Click()

I have a bound form with an unbound combo box. The query behind the
combo returns 6 fields and when I "hide" the first column which is the
bound column, access just crashes and goes away. I have narrowed it
down to if I set the width of the first column to anything other than

please advice me how to remove home page for adult friend finder which i
wrngly click and also added as home page. how to remoe display

I am executing:
DoCmd.RunCommand acCmdDeleteRecord
and getting message:
"The command or action DeleteRecord isn't available now"

I have a form with 6 check boxes. Box1 has a default of True. If ANY other
boxes are checked, I would like to automatically uncheck box1. Can you tell
me the best way to do this?
Thanks,

I have built a database to handle revisions of our manuals.  Currently when
you want to list items being revised, you select the manual and then choose
one document at a time from the list and enter it's new revision number and a
description of what was being revised.   This is ...

I have an application in MS Access. I have e Module. One is for GetCurent
UserName and second for OpenFile. When I run it I get this error
"The expression On Open you entered as the event property settings produced
the following error: Constants, fixed-length strings, arrays, ...

I thought I had posted this, but can't see it...
When send an email with at RTF attachment, all is well.
DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName, ,
, "Member List", "Attached is an updated Member List"