When I try to debug VBA code in Microsoft Access 2003, I keep running
into an issue. I'm trying to debug some code found in a module which
is accessed by a form. When I try to stop the debugger (and the form
from running), the whole application hangs. It doesn't do anything and

I'm using automation in Access to reformat several Excel spreadsheets within
a workbook I will be receiving on a weekly basis.  I have my code working
using early binding, but would prefer to use late binding as I expect we will
be migrating to Office 2007 in the near future and ...

Yes I know we're supposed to print reports, not forms, but my co-worker
manually prints a form with terrific graphics and it comes out looking great.
She doesn't want a report, she wants to print that pretty form and she only
wants to print the CURRENT record.

Some snippets of code I have:
    strWhere = "[IvSurvId] = " & Me.Parent![IvSurvId]
    StrWhere2 = "[IvSurvId] = " & Me.Parent![IvSurvId] _
    " And [IvPage] = " & Me![txtIvPage].Value

I have two forms
Form1  Pk SurveyID (autonumber)
          Seq1
Form2  SurveyID

Is it just that I never noticed its absence and that's the way its always
been, or is it a problem with my access installation? I can set the visible
property in VBA, but when I just looked for it in the properties list for the
form, I can't find it anywhere.

The following code compiles but when CmdButton is clicked I get an
error with DoCmd.RunSQL strSQL hilited in the debug window. Please
advise what I might be missing. Thanks as always!
Private Sub cmdDelete_Click()

I want to use a combo box with a list of months to set a date range to
two text boxes, txtStartDate and txtEndDate.
My combo box (cboMonth) has two columns, one with a number for the
month such as 1 (for January), 2 ( for February), 3 (for March), etc.

Is there a way to check with VBA if the database window is visible?  I have
seen code on how to show or hide the database window, but cannot see if/how
to check the status of the window.  What I am thinking of is something like
this:

Why does this work the first time and not the second?
I am trying to process records in a loop inside a loop – and it kind of
works. (i.e. it doesn’t!)
In the code shown below, the record set Sales Order Lines has two records,

This is a follow up from a post on 4.14.
OK, I have the original code working now EXCEPT I cannot select more than
one criteria AND after doing one search and I hit clear the results come up
blank.

I wrote following code:
Private Sub Stop_rit_AfterUpdate()
    If Me!Stop_rit < Me!Start_rit Then
        If MsgBox("Eind-kilometers zijn lager dan begin-kilometers",

When a user types in data in a form which is inappropriate, The Before Update
property has code to check the entry, and if it is not appropriate, I use
MsgBox to tell the user to re-enter the data.
The popup MsgBox has a Title "Microsoft Office Access".

I have a db in access 2003 and I am trying to allow the user to be able to
send a mass email to a list of people in a table by clicking a button. Is
there a way to do this?
thanks

I am stuck.
I have a form in which there are 3 variables (inbound/outbound shipment,
code of service of the shipment, Client)
The combinations of these 3 variables should show me only the correct rate