In AccessXP I have a report, in print preview the report looks good,
when I choose Office Links - Analyze It With Excel the spreadsheet
opens and will have different values in a particular field for 6 of
the 45 records;  example, in the field NbrValue for one record the

I have some code in which I use Transactions. If there is a problem and the
Rollback method is called, only the statements which use db.execute strSQL
are rolled-back. The main-record duplication is not un-done. My thought is
because it uses Me.RecordsetClone. Should I instead use ...

Background:
I have a table of fields each field representing a month (Jan, Feb,
Mar...).  These are not a date field but more of a bucket to hold
labor actuals.  Along with the months their is another field for

1) Module1 has the following delcaration:
Public g_frmZZZ as Form
Public g_txtForm2 as Variant
2) app has two forms: form1 and form2

Hello.....
RE: Access 2003 / VBA Editor
Given the sample code:
Public Sub TestPayment()

Dear Group
Excuse my ignorance but I have never come across this problem and need
some advice. I have two copies of the same MS Access 2000 database.
One from about 6 months ago ond one recent copy. When I open up the

I guess I've been working with A97 too long.  That program seemed
cleaner than A2003.
Used to be, in A97, you'd have tabs at the top to select what you wanted
to work with; table, query, form, etc.  In A2000, MS for some unknown

I have a report in Access. I want to calculate with the DateDiff
function. Two questions.
1. How do I set up the Date Diff to subtract a date in the past from
today's date? I want this to be dynamic, automatically incrementing

I just talked to some big shot analysis people.
They want the data....ok do you want the database, you already have
access don't you.
NO we want the data.

Is there a way I can direct the cursor to a specific field (variable)
in a form by typing the field name while in form view?
I have a form with many fields, and it would be nice if there were
some method, similar to FIND RECORD (e.g., CTL + F ), where a dialog

I needed this for address labels that wouldn't wrap. Couldn't find the
function so I made one. Splits at space.
Function cvtWordWrap(Apl As String, Leng As Long) As String
Dim i As Long

Using A2000
When I click the save icon in form design, Access closes immediately. No
warning messges, nothing.
This happens on only one form. I deleted the form and recreated it. I could

Does anyone know how to convert an access table to a csv file with
either a macro or a module in an access database???  I can use either
access 2003 or access 2007.

I have a form with 2 fields on it, one for directorate and the other
for quarter's i.e. 1,2,3,4
if a certain directorate and quarter is selected go and get a certain
report, that I have built from a query.

I am developing an Access 2000 app that uses the Microsoft Rich Textbox
control. I asked the system administrator to add the line to register the
OCX to each user's Windows login script, as follows:
   regsvr32 "c:\windows\system32\richtx32.ocx" /s