Thanks in advance.. if somebody can point me to right direction.
 I have main form which contains 4 subforms....
 I am trying to find out if at all any of the subform (field or field )
been edited

I have an option group with radio buttons Yes/No with a textbox next to
Yes
I need to add a Before Update event to say:
if txtbox <> "" then

Hi, i have a Parent form (Contract Profile) and about 12 subforms (Contract
Review, Vendor Assessment.... etc). The way it setup currently, i have the
main parent form and at the bottom i have tabs setup for the other forms.
Everything is working perfectly except the design looks ...

I have subforms that I am trying to tab through from my main form.  I have
set up the "txtjump" field in all subforms to set the focus on the next
subform.  My problem is, if the main form is FrmProjEntry_Renaissance I need
it to jump to subform FrmSUBContacts_Cities.  Otherwise ...

I have a form with a header that is a Text box with a piece of text and the
user’s name. The Control Source looks like this:
="Diary Information for " & [Forenames] & " " & [Surname]
The Text box has a Special Effect of Shadowed.

I have the error code 2501 appearing when I Cancel a form closing (which I
believe is to be expected). To prevent the message showing I have wittten an
error handler routine:
If err <> 2501 Then

I am converting my Access applications from Access 2000 to Access 2003.  I am
comming up with a miss reference for "Microsoft Windows Common Controls-2 6.0
(SP4)".  The file name is MSCOMCT2.OCX.  This is causing problems with my
apps.  What is the name of the reference in Access ...

Is there a way to force CAPLOCK on an entire form and have it store the data
as well without having to set it on each and every control?

User clicks a cmd button.  The cmd runs a series of coding.  At the end it
runs a macro to append and then delete the current record.  The problem is a
dialogue keeps poping up stating "Record is deleted".  Then the user has
click "OK"  then code keeps running.

I am using Access 2003.  I have a main form (frmAnalysis) based on a table
called tblAnalysis.  FrmAnalysis has a bound control called EquipmentName.
The main form also has a button that opens a subform (subHazard) based on a
table called tblHazard.  TblAnalysis and tblHazard are ...

Greetings everyone, we have a couple of Access applications and we were
wondering if there was a way (perhaps with FrontPage or Dreamweaver, we
are not that web-savvy) to host them or convert them to a web
accessible format so people could access them through the internet.

Can anybody help untangle this syntax, please?
I can specify either the strSQL or the strDir, but want to do both
Private Sub cmdMergeAllLw_Click()
  strSQL = "Select * from qryNotifConcat WHERE CaseID =" & [ContactID]

I am trying to run the following query in module that exports the data to an
Excel sheet. The module works correctly when I use the first statement with
the literal for the MONYR
 sSQL = " SELECT qryConsolidatedPerp.*, qryConsolidatedPerp.LOC FROM

On a form, some buttons display the tooltip while others do not. My
descriptions are not very long; any ideas as to why and how to fix this?
Thanks.

I am able to refer to a Treeview control on the main form using its
control index in the controls collection of the form; but I can not
refer to it by name. i.e. :
In the load event for the subform: