Hello.  I recently converted an Access 2003 database to 2007 and had a
macro that had conditions built in.  These worked in 2003 but do not
work in 2007.  The example:
Conditions:

I need to hide a subform if any of the fields on the main form are being
edited.
I can't get that to work
The subform can be shown ONLY after the Save Record button is clicked.

I have code to handle the deletion of a record that appears on a form.
Deleted the current recordset on the form and then either moved to the next
record, or the previous, depending....   Worked great in 2003. Now getting an
error of type mismatch when setting the variable rst ...

So far I have helped my users search for records by building search forms
that will allow them to check a few boxes and build a query for them.  It
has always been "Find orders for Customer X", "Find closed orders", "Find
shipments over X dollars", etc.

I have a form that queries a table based on multiple filters, such as Part
Number, Part Type, etc.  Currently the search code is enabled to search for
one part number entered in a text box, and the search results are displayed
in a subform.

HELP Please!  I have a continuous form based on a qry called qry2009PO.  I
want to be able to filter the records based on State (cboState) and County
(lstCounty) -which lstCounty is populated via an after update on cboState.  
Both are text fields.  Here is the code that I have.   ...

I have a drop down box that lets a user select IDs of the records. After they
choose the one they want I want the rest of the information (such as name,
address, etc.) to be populated for them. Any suggestions would be great!

Hello,
I have another question. I have the following code in the after_update event
of a check-box and it works fine. The problem is that if I click/unclick and
then click again it keeps adding one to  PossiblePoints. PossiblePoints

In Access2003, I need to know if a user is in the process of adding a NEW
record as opposed to modifying a current one. The latter I have covered via
DIRTY, but I really need to know if it's a new rec.
Can someone please throw out a few ideas?

Is there a way to add the input mask for the password in this code?
Dim stPasswd
   Dim stDocName As String
   stPasswd = InputBox("Enter Password", "Restricted Report")

I amtrying to extract the first letter and only the first lette from
cboClassification to use in an text box.
The properties of cboClassification are
RowSource: SELECT tblClass.ClassIDPK, tblClass.classification FROM

I'm using vba automation to write to an Excel file. Everything works fine
except that I can't seem to quit a temporary instance of Excel that I'm
opening. Here's some of my code (also read the rest of my question after the
code):

I'm trying to find something like a list that will tell me what number
to type into VBA when I want to see what color. The following code
works, but I need a darker green:
If Me.[status].Value = "Achieved" Then

I have a few forms one is for software and the other is for equipment.
When equipment goes to surplus we check a box so that it no longer shows on
a report the db generates.  On the software form if the software is no longer
in use we check a box so that it is only showen in the ...

I've got a loop running, however it always seems to miss off the first date,
so any help would be greatly appreciated.
So, the fields/data I have are:
[startdate] = 18/01/2009