I have a parent form has a 'Reset' button, which sets data values (as
defined by value in Tag property) to "" by calling a function.
The function requires one argument: a form name.  The function works
correctly on the parent form, but not the child form.

I have two forms: form A and Form B. Form A has a button to open form B.  I
want to have form A close when I click the button to open form B. (so Form B
is open and Form A closes).  Is there an easy command for this?
TIA!

I have a text box bound to a memo field. My end users enter email
distribution lists into it and eventually click a button that sends an email
to these addresses.
Is there a "email address validation" routine?

I have a Dataentry form that allows add/modify/delete data into this form.
Then I copied this form, changed the name to Search. Changed the form
properties for edits, delete, modify to false.
But when I open up the Search form, I am still able to edit/modify/delete data

I am trying to set clear the contents of a textbox and set the focus back to
it if a condition exists.  It clears the box, but icant set the focus back to
it.  What am i doing wrong?
Private Sub txtEmpNo_Exit(Cancel As Integer)

I have a form open & i run code to append data to the underlying table of
the form.
The open form doesn't show that record unless i close the form and re-open
it. How can I refresh the data so it will be available without closing the

Hello all, I posted a question to the group last week, but for the life of
me, cannot find it. So, I apologize if this is a re-post, but I am not sure
if it even got posted!
Here is my dilemma. (And I apologize for not adhering to what appears to be

-- I am using a form to display a recordset of results which are derived
from a query.
I want the form to scroll through the recordset from top to bottom and then
return to the first value and repeat the process.

Table:  tblAccount
    Field:  TrackingNumber
    Field:  ClosedDate
Table:  tblAccountActivity

I have a main form and a subform. The combo box naming partno and Process in
the main form. The RejectCode Combo box in the sub form. The RejectCode
combo's row source property set to change with the contents of the the PartNo
and Process combo boxes in the main form.This works ...

Is anyone aware of a procedure that will calculate the first, second, third,
fourth and last weekday of any given month (e.g. the third Thursday of March
or the last Monday of August)?  Thanks in advance.

Hi, I need to set font name and size for Datasheet view of subform.
How to do it?

I'm trying to provide an option for either text or numeric entry; the form
in question has four columns, the last three of which are almost always
dollar values.  Rather than make them all text, I thought of creating a
second set of fields that were text, changing them to not ...

I have the following code in a txtLocation before update event:
If vbNo = MsgBox("Do you want to change to """ & _
       Me.txtLocation.Value & """ location?", _
       vbQuestion + vbYesNo + vbDefaultButton1, _

Dears,
how to round off a number e.g. 99.90 to 99 not 100 and 99.09 to 99 as well
i.e. it has to be round off to the least.
thanks