I have a work order form that contains several fields/lookup tables. I want
to fill a text box with a certain procedure based on the location field and
the activity field..I've used the following code successfully
Private Sub ActivityCode_Exit(Cancel As Integer)

I have a form on which combo box cboCategory is followed by combo box
cboSubcategory. There are about 30 categories in cboCategory, and about half
of them have linked subcategories under cboSubcategory. I would like
cboSubcategory to be disabled if the user selects a category ...

I have a button on my form that copies the record, pastes it at the end, and
then goes to the copy.  It's in Access 97.  Here's my code:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
   DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70

Hi
Im trying link from one combo box another.  From the 1st combo box 1st
choice it will populate the second with values from one table and from the
1st combo box 2nd choice it will populate the second with values from another

Hi there! Using A02 on XP. Have been looking into the
Timer event. Found Idle Activity, Inactive Shutdown
something or other and think this could be what I need.
I have a problem with folks adding a record and walking

Microsoft Outlook object library is not in my object library list
I am using office xp 2002 sp3
how can i add it ?
thanks eyal

Windows XP, MS Access 2K
=====================
Hi,
I have a button on my form to save the current new record. I also have code

Hi, all
Could someone help regarding how this code works? Using Lebans Demo db and
frmcanGrow I can see the functions working however, unlike access when I add
a record with no data place into the ExtraInfo field the text box does not

I'm trying to simulate the record counter on the forms navigator. I have an
unbound text box which displays the count of records but I can't get my head
around displaying records x of y.
TIA

I am trying to transfer data from one text box to another and I have come
accress error runtime 2185, - you cant reference a propetry or method for a
control unless it has a focus.
please help me to resolve this issue.

I am trying to run a calcuation based on information in a subform and I would
like to use the For .. Each .. Next syntax.  My question is: how do I address
the records in a subform using the For Each command?  

I've been up and down these forums looking for a solution to this
issue, but so far have had no luck.
I need to automatically assign serial numbers starting from 1 and then
incrementing by 1 as each new record is entered.

I have a dropdown box, txtCall, that simply selects [CallNumber] from
tblCalls based on a previous field entered, txtCycle .  Each cycle has a
certain number of calls.  The values are 1 through 10.
However, I want this box to limit the items to restrict when a previous

My optical wheel mouse does not scroll when editing code in VBA for MS
Access.  This is a recent change in behavior after downloading.
Has anybody else experienced this and found a fix?

Hi to all, need some help with this Dsum function, the syntax seem to be
fine but when I run it it give me an error
this function is being used in a report.
my goal here is to be able to sum some totals in groups of 5 years period,