I am trying to change forecolor in a label. This is what I am doing in
vba.
   MsgBox label1.ForeColor
   label1.ForeColor = 10

I have a form called FormA.  It is bound to TableA.
In FormA, I want to reference one of the fields in TableA, lets say FieldA.
Nornally I would have a text box control in the form and it's control source
would be FieldA and any code that I would use would reference the text box

Access 2003
I have a popup/modal window that serves as a status display for a lengthy
report pre-processing.  At the end of the pre process the code performs a
Docmd.close acform “PreProcessForm”

Simple Question:
Could you please show me the code to Maximize this report??
---------------
Private Sub Report_Open(Cancel As Integer)

I have the following code in an Access 2003 form:
 Dim i As Integer
 Dim rstHrngLossFctrs As New ADODB.Recordset
 Dim arrHrngLoss() As Variant

I am hoping someone will check my logic here.  I can post my code, but I am
concerned that what I am trying to do may be better done with another method
entirely.
I have a master list of items which may need to be submitted on any given

WindowsXP Pro, Access 2003.  Wedge scanner with auto carriage return.
I have a form 'frm BARCODEDESTROY' based on a query 'qry BARCODEINPUT'.  On
the form I have an unbound control 'BARCODEINPUT' with the following code:
-------Code Start-----------

Does anyone know if it is possible for data to be copied to a form
automatically when it is opened by a button on a form?
Cheers
Colin

I am having problem with the following codes for some reason and I
cannot figure it out where the problem is. However, what I'm trying to
achive is to have a auto number generator for my quote form, so
basically this generator would create a quote number that will change

I have an unbound main form with a single subform.  The sourceobject
for the subform is changed to various forms using command buttons on
the main form.
One of the subforms is a search, and another is a detailed view of the

I have a form with a "yes/no" field (field1) and a text field (field2). I
want to change the font and colour of field2 based upon if field1 is set to
yes or a different font and colour if field1 is set to no.
How do I do this?

I have code behind a button that temporarily switches the printer from
default to another printer, prints a report, then switches back to the
default. The trouble is that, for the printer I am temporarily switching to,
some machines have one driver and others use another. I would ...

I've seen several post going by referring to the lebans website and the
conditional formatting sample db. It looks really interesting, but as I
am just a newbie in access programming I don't really understand the
code and how I could get it to work in my own database. I am building ...

Can someone tell me why the following code is not filtering properly?  My
subform opens okay but there are no records showing and I know that there are
matching records.  Both link fields, "CDT_Contract_No"  and "Contract_No" are
text fields.  I'm baffled!

I knw this question gets asked alot but i've tried looking for a suitable
answer but nothing seems to work on my form!!
I have a Form (frm_pt) with a subform (frm_pt_sb)
When a user enters info in the parent form, i'd like user to be prompted to