All,
I was wondering if there was a way to open a form based only on the current record in focus...
I have a table that has a number of fields one of those fields is a Notes/Memo field.  I don't have a unique ID that refers to that specific record, instead I have an ID that refers ...

behind a command button click event, I have this code
(where manufacturer and catalogno are valid fields on the form):
   ...
   Dim strOpenArgs As String

After giving focus to a combo box, I've not been
successful in getting the combo box to dropdown.
Me.MyCombo.SetFocus
Me.MyCombo.Dropdown

This is just a minor question, but it's one that has me stumped:
I have a control that I would like to make invisible after the user leaves
it. However, I also know you can't disable a control when it has the focus,
so I can't use the OnExit or OnLostFocus events of this control. ...

I created an access database that I would like to save data to a number of
directories. I created the directory via access 2000 and now I would like to
be able to change directories once I am using the database (through the
database). Example  in DOS Command, is CD to change ...

I’m having a little problem with my loop.
My aim is for it to keep the first record, delete the next 19, keep the next
record, delete the next 19 etc, until there are no more records (there are
500).

Below is the event for a combo box.
If I enter the name with Caps Lock OFF,  it works fine.
If I enter the name with Caps Lock ON, it doesn't work.
I'd like it to work whether Caps Lock is On or Off.

I have a form whose Recordsource is a query
that includes a numerical field signifying a
ranking value from 0 to 5 by .5. Correspondingly,
I have a set of images that pictorially represent

So I have a kind of help form built because I do not understand how to create
an HTML help file. The form loads from a user making a selection from a
previous form of help topics. I have each line designated as a label and a
case statement depending on which topic they chose that ...

I have master form and subform which is continues form.
On each subform there are two buttons that appear on each record.
According to the data on the form and acccording the entering data to the
form the buttons should be enabeld or not.

I have a form whose Recordsource is a query
that includes a numerical field signifying a
ranking value from 0 to 5 by .5. Correspondingly,
I have a set of images that pictorially represent

Using Office 2003 and Windows XP;
I have a combo on a form with a SQL string in its RowSource. It works great,
but how can I change my SQL to include an "All" choice as the first item in
the drop down list?

What is the syntax for an sql command to get the following.
I want to pull in a handful of fields from a table but one of the
fields needs to be unique.
For example, if I have a customer table and I want to get each unique

I am using the me.dirty property of a form to enable a save button to
highlight changes have been made. This seems to work fine except on the first
record shown by the form. When the form is opened at the first record any
change will make the button enabled and this will continue ...

I have a form that I created some navagation command buttons - Next,
Previous etc.  My question is what is the coding for having the current
record number in a text box displayed.  Any tips will be appreciated.  Thank
you in advance.