I want a control on a subform (on a Tab) to inherit a value under certain
conditions when two other controls on the main form are filled. The code is
in the After Update event of a third control on the main form. The code is
below. I have used the control name that contains the ...

I am working on Access 2003, and I am trying to figure out how I can store
historical dates of when a given record was edited/modified.  Any help you
provided would be greatly appreciated.  Thanks.

Hope you can help me.
I have a listbox that lists two fields from within a table.  The first field
(CentreNo) is the bound column.
I'd like the users to be able to 'jump' to a particular CentreNo by

I am a promotional products supplier.  I am trying to get my site
similar to http://www.cawholesale.com.  My site is
http://www.dallaspromotionalproducts.com.  I have a supplier
http://www.foractivewear.com that has several items that I would like

I am working on an Access 2k app. One of my forms uses a listbox to show an
employee list. I want to be able to add and delete names from this list.
Adding isn't so hard but deleting seems to be. So far I have...
Private Sub cmdDelete_Click()

G'day ppl
How can I filter NG's so that they only store messages say for the past
month, and not 2 years as I am getting now. I have over 50K messages
displaying.

Hi;
In a medical system we store all prescriptions in 2 related tables.The
parent Tbl has Fields like:PID (or PrescriptionID that is a unique Long
Number assigned to each new Prescription,and is the table's PK and the ONE

Hello - I'm trying to open a Master Form with subforms, and filter the
subforms based on the value in a menu form.  First I tried using a
Macro and opening the form with a where condition applied to the
subform. Then I tried to apply a filter to the subform.  When I apply

Ths is rather embarassing but here goes. When I open FormA, I want FormB to
close. What would be the OnOpen event syntax for FormA to close FormB?
Thanks.

I have a form with several date text boxes. One of the text box contains a
month end date.  I would like to have a separate text box where the user can
input next month/following month end date in the new text box and press a
command button that will update the current month end ...

I was wondering if anything in the record selector can be used?  I want to
you the number in record selector window.

Iterating through a listbox, I need to address the columns of the list and
put them into a table.  Is this possible?  The expression
ctlList.ItemData(varItem) will give me Column(0), where I need other column
data as well.

Let me give you a quick rundown of what I am doing...
Basically, the Form_Load function populates a ListBox with values as the
form loads up. These values are correct and appear in the listbox without any
problems.

I running a work order application. I have a counter field that contains a
letter, julian date and a counter number. Ok I have an A, B, C, D, E, F, G, X,
R company. Ok when I start my date and select B I have a counter beggining on
number 1. Then if I select A first of the day in ...

Hi, can't understand why this wont work:
=IIf(Not [dtmDateClosed] Is Null,[dtmdateclosed],"On Order")
I should show the dtmdateclosed value if it isnt Null, and the Words "On
order" if not.