I have some code which tests for the name of an active form (i.e.
Screen.ActiveForm.Name). If there is no active form, an error occurs which at
the moment I have to use error handling to deal with.
Is there a way I can test if there is a form active, rather than relying on

I have about 10 Yes/No columns in table.  In my form when I go from record to
record I want to count the number of yes for per record.  So if the 1st row
has 4 yes, then on my form I will see the total of 4.
How can I get this done?

I have this code placed in on Current in my form:
Private Sub Form_Current()
If Me!Text287 = "0" Then
Me!fcdeed.Visible = True

Normally, when a run-time error occurs, a dialogue box appears giving the
error number and description. A button called ‘Debug’ takes you to the code,
highlighting the line where the error occurred.
If you use error handling (On Error Goto….) you no longer get this dialogue

I want to use the treeview control in an Access 2000 app I am working on. I
have never really used this control before - but after seeing what I can do
with it - I believe it is the right fit for one of my forms...
Question...  I have been playing around with it but have a few ...

I have a combo box with two options: "AS1" and "AS2".  The combo box is
bound to a text field and whenever the user types in "A" or "AS", "AS1" pops
up as the default. Is there anyway for the user to just hit "1" and then
"Tab" (or "Enter") and the combo box will recognize it as ...

Is it possible to have a calculated date field that can also be overriden if
user wants to provide a user inputted date instead?
My formula in the control source is currently:
Contract_end_dat

I’m using BeforeUpdate code in a text field with Number data type to prevent
duplicate entries. However, the code doesn’t fire when a duplicate entry is
entered. When the user leaves the field, instead of getting prompted, nothing
happens - no error message, no anything. The code ...

I have a backend mdb and a frontend mdb. I have added a field to a table in
the backend using code. Now I need to update a query in the front end that
feeds a form to include the new field added to the table in the backend.
Can this be done through code thus the adding of the ...

I'm using office 97 and would like to use some of the extended characters ?
?  ?  ? .  The character map refers to these as U+215B: Vulgar Fraction one
eighth,  . . .U+215E: Vulgar Fraction seven eighths.  When I try to use them
in forms or reports I get just the undisplayable ...

(Access 97) I have an update form that can be called from multiple forms in
my app.  I would like to be able to just have the update form refresh/requery
the calling form, whichever form it was.  I've searched this forum and tried
using the OpenArgs property in the calling forms to ...

Using Access2000,
I have a form with two subforms attached.  I would like to create a button
on the main form that would duplicate the entire record displayed including
the information in the two subforms.  I was able to use a wizard to create a

I have a helpdesk application that records customer calls.
The main form (which selects the customer) has a subform
(FRM_Log_Entry_Subform) showing all calls. This subform has a subform showing
actions against the call.

By clicking on a button in a form, I want to view the page of the report
related to that member.
The codes are below.
I get an error message : Type de données incompatible dans l'expression

I'm trying to code my form to allow a text box to become visible only after
an option button is chosen. I also want the text box to be hidden again, if
the user changes their option. There is a different text box for each of my
three options.