This should be a fairly common scenario, but I haven't yet found a solution
on google.
(On WinXP Pro SP2 / Access 2003 / Excel 2003)
The following code, when run from Access, leaves a copy of Excel.exe hanging

Using Access2000, WinNT.
Using the Immediate Window, I can view the results of my VBA code as
it performs operations/calculations on my data.  Now that I have all
the bugs worked out, I want that same debug.print information sent to

BlankI'm really a greenhand on Access.  Wondering if I can do calculations
in the design view of Reports. There is one output variable (Y) whose value
needs to be calculated using 3 other variables (a, b, and c). However, the
value of b that will be plugged into the formula are ...

I am attempting to change the background properties of a rectangle in
the code, and have been stuck now for a day and a half.  This is my
first access app.  Please be gentle with my steaming pile of code:
If I include the following in a subroutine, the rectangle properties

A Quick question if someone could help, im sure this has been asked
before, but googling is getting me now where slowly.
Is it possible to get an unsigned 32 bit integer field in Access.
Im storing IP address in their integer form (ie. 32 bits) and Long

I tried posting once already, but Google crapped out and this posted
under a different topic.
I'm trying to take three columns from one table, insert them into
another existing table, but match the values (of the three columns) up

I am new at setting up a database and requesting info from groups so
please excuse any mistakes that I inadvertently make.
I have set up a table with client info including a ClientID.  The
ClientID is made up of the first letter of the client name plus a

I have a problem that I could swear I have worked out, but it's just
not working so I need some help.  I have the task of creating a
Conference Management database for a small non-profit organization.  I
am using the Event Management Database as the template, but it's

Help, I'm really out of my depth here (not unusual I hear you say :-).  I
have just installed HTML Help in an application.  I told it in the Project
Properties the path to the help file.  I then type in a command line that
runs the help in the correct Context from a button on ...

This should be simple but I can't figure it out!  I have a form bound to a
query.  On this form is a combo box that is bound to the same query.  When
the form loads the combo box is blank.  If you click on the dropdown in the
combo box the records are there.  What I want is that ...

I added two columns to my database but they aren't showing up in the
description of my linked tables and they are throwing an error on my
form.  Do I have to relink the tables?  Anyone recognize this
behavior?

I have a field "TerritoryID" on a subform. It has a Dbl Click event as
follows:
 Private Sub TerritoryID_DblClick(Cancel As Integer)
 Forms!FmDealer5!Text152 = DealerID              '**Retrieves DealerID and

    I have not seen this question addressed in older threads.  I am
wondering about the practical limit for code size in Access 2000 on a
project I have been working on for five years that runs a factory
here.  It contains all the expected functions like Employees, Time

If I run my Update query on its own it does the job but if I run the
same query in a Form it does nothing. Can any one tell me what I'm do
wrong; below the type of code I have tried
Example1

I would like to number the records in a query.  If I have 10 records, is
there a way
to assign numbers 1 - 10 to those records?