Am I right in believing I do NOT need to clear rem'd code (preceded by ' in
case I have used wrong term) in my origin mdb file before making a mde file -
I wish to keep rem'd code in my original mdb master?  
Is my reasoning correct that if an mde file contains no code (as it is

Please help, I have a message box for an OnClick Event for a button:
RetValue = MsgBox("Are Details Complete?", vbOKCancel)
How ever, whether the user ticks Ok or Cancel the button still runs the
query. Any idea on the If statement that I'm missing?

I'm having problems with writing an Access 97 database running under XP Pro.
When I try to use the .Form property of a subform control, I keep getting
"run-time error '2455': You entered an expression that has an invalid
reference to the property Form/Report".

I am trying to make a control my subform requery.  In the Form_Close section
of frmTransaction I have this code:
Forms!frmCustomers![Card Subform].Form.txtTotal.Requery
It seems as though it works, but the value on the subform does not change

one more chart question...
I want to show two axis by enabling them on the chart:
me.chart.HasAxis(xlValue, xlPrimary) = True
me.chart.HasAxis(xlValue, xlSecondary) = True

I am trying to set the color of my dataseries 1 from VBA.
The code below is from an example in VBA-help:
me.chart.SeriesCollection(1).Interior.Color = RGB(255, 0,
0)

i am working on access-2000. my problem is :
i have a form in which i have a combo box. the user has to select a value from the combo box, which i have captured in another textbox. now i wish to run a sql query based on this value cpatured in the text box. this i am not able to do ...

I have a form that has a lot of code behind it and even more in a module
that is called when the form loads.  Because of the large of fields and code
associated with the form, I assume, it takes a while to load.   If I take
the code in the module called from the form and put it ...

i have one form and five checkbox namely chk1,chk2,chk3 and so on..
i want to check value of all checkboxes in for loop...
code snippet
for i = 1 to 5

I recently activate the label wizard using code and it works correctly.
However, I noticed that the wizard always stores a copy of the report format
in the report section.  The problem is that the default name always assumes
an incremental version of the same report.

this is what i am trying to do.
i have a form called order and subform called order details.
i have a combo box on order form which has names of customers.when i select the customer ... it should display the related products in another combo box in subform order details.
i am ...

I would like to create a DB properties called "version" and have it written
in the header of the project and/or  each form and/or report ?
Anybody could help
FRED

The object type, name, or output format is invalid. Unable to send message.  
Microsoft Access Error
Using Outlook 2000 & Access 2000

I have created the query below that generates a sum that I am looking for:
SELECT Sum(tblPayments.PaySalDLCDPor) AS SumOfPaySalDLCDPor
FROM tblGrantSum INNER JOIN tblPayments ON tblGrantSum.[DLCDGrant#] =
tblPayments.[DLCDGrant#]

I have a form with two buttons: PRINT and CLOSE. The form also has the X in
teh upper right hand corner of the form.
I would like to create a function that validates all of the field
information prior to either one of these actions to happen.