I sent this question in yesturday but no one responded.  If it's not
something that can be done, can someone at least tell me that, please?
I have a subform named Silvsub that is based on my S table and it displays in
datasheet view.  I have 2 text fields (Category and Activity) ...

I have three listboxes on a form whenever I click o the first one,
related info comes up in the second, so on and so forth.  The problem is
that whenever I click on the first one (or the second) the records come
up an the first one is always selected (Just appears that way, ...

I've just read the ten commandments and most of which I agree with whole-
heartedly, but a couple of them I had questions about.
1. what is anormalized table? all my tables look pretty normal to me :)
2. why are look-up fields evil?

Hi gusy, I have two forms: CategoryForm and CategoryResults, and there are
'opt1, opt2, and opt3' in CategoryForm, how can I use the opt1,2,3, in form
CategoryResults?
Thank you.

Any help would be greatly appreciated.
Can someone tell me why I am getting a "Run time error 2342"
message at the "DoCmd.RunSQL mkMkID" line in the code below:
Private Sub cboMake_AfterUpdate()

Hi to everybody,
on certain occasions I have programmed StatusBarText
(Screen.ActiveControl.StatusBarText = "xyz") in my Forms which works fine.
But once shown, how do I eliminate that text and go back to normal (showing

I have created a DB in Access 2000. There is a form with a custom
"BrowseButton" which opens an "open file" dialog box. It works fine in Access
2000, but it doesn't in Access 2003. Even the error handler reports nothing.
Here is the code for the "BrowseButton" on-click event and ...

I am using Access 2002 and I have a form which contains the following
fields:  Claim agent, which is a 4 digit code and another field called
weekly production, which is a date field.  Each Friday the user will input a
pre-define 4 digit agent code and enter the date  for weekly ...

I am using Access 2002 and I have a form that use a table called claims and
another form that uses a table called inventory. Both tables have the same
fields called:  PolicyNumber, Insured.  The claims table will have an
additional field called claim date.  The form Claims uses ...

I have command buttons (Edit, Save, Cancel) switch back & forth (to enable &
disable)
This was working great until I change my Record Source #1 to #2.  The record
source is from the 2 tables and now the “cmdEdit” button is NOT working.   If

I have a table that hold various variable so to say for the environment
of my application.
What I am trying to do is allow the user to set a standard directory as
to where images may be stored.

I'm struggling with identifying the active form in an access
application. There are functions called from shortcut menus that need
to determine the key value of a record displayed in the form when the
shortcut menu control is activated. The method I've been trying to use

Is is possible to make a treeview's background transparent or at least
select a desired color?  I don't see that property anywhere...

Situation: from the main screen where you have all the combo boxes & list
boxes to build the (select, filter, and where string).  User selects values
and I build the "where" string.  I'd like to display the "strwhere" text box
on 2nd scr but with no success yet.  Any suggestion?  ...

I have a  Form with two sub forms. The first sub form is displayed as a
Datasheet. The datasheet consists of a set of columns. I have it set so that
the user can quickly tab across to the next column. By default when the user
hits tab while the last column is in focus the cursor ...