I have a form with a subform.  I am doing a requery on a list box in the main
form based on the input in an object in the subform.  The object's text
length must be greater than 3 to requery the list box.  My problem is when I
requery the list box in the main form the object in ...

I would like to scan into a form and automatically advance to the next
control.  I have tried a me.nextcontrol.setfocus in all the events without
success.  Is there another way?  Thanks!!!

I am currently using combo boxes based on a query that displays a different
column than the one that is bound to the table column.
I want to allow the users to “retire” a value in the look-up table, so I
added a column named Active with a data type of Yes/No.  I then added

I am using Access 2002.
I have a main form with 2 sub forms.  I would like the user to not be able
to make changes to the main form or the subforms unless they are the
"Author".  I thought I figured it out, but.........  the UNDO action is

In Access 97:  I created a multi-selection list box.  I save the record, but
when I bring it back up, those selections are no longer hi-lited.  I hope the
answer is a simple one.  I'm not very savvy with programming language and
don't fully understand the "linking" process, so ...

Are there any tricks to using OpenArgs?  I am trying to pass a simple string
to a report I am opening and always get NULL in the report (Me.OpenArgs).
The examples in Help see pretty straight forward, but I can't see where I am
messing up.  Any suggestions?

My form includes a text box with Company names in it and two command buttons:
1.  Add new name  2.  Save data and close.  All possible errors are covered
except when the user presses "Add new name", begins typing in a name and
presses "Add new name" again.   The Run Time Error ...

I have this code in the Change event of a combobox:
Private Sub Location_Change()
'On Error Resume Next
If [Location].Text = "" Then

I currently have a combo box that pulls information from one of my master
tables. The combo box pulls citys but it also allows the user to pull the
state. Ex.
-----

I have the below Form_activate event running in a orderform.
From the orderform I open a payment form..when done I close the payment form
and the orderform activates again..running the below to set the paymentstatus
of the current order. It works fine...however when opening the ...

I'd just like to comment that Microsoft Access, or at least the VBA aspect of
it, is a steaming mountain of putrid pigshit.  I've been using it for years
and I'll keep using it because it's what my employers insist on, but...
Whoever designed it didn't know how to debug code, ...

I have a frame on a web page that is displays information I would like to be
able to harvest.  Someone said all I have to do is get the string from the
target frame and cut out what I need.  Please point me towards the library I
need to reference.  Thank you.

I have a continuous subform in Access 97 that I want to grow on the main form
as entries are added.  I set the Can Grow to Yes on both the subform itself
and embedded subform property where it is placed in the main form.
It works perfectly for the report that is generated but it ...

Does Nz work with a Date. I have a payment posting form that will take all
kinds of payments. In one situation someone may not be paying rent so the
paid thru date will not change. I'm trying to set the date field to Null in
this case. I've tried tmpPaidThru = Null and get and ...

Is it possible to change the mouse icon in code in the
mouse over event procedure?