I've been told in another forum that I can apply a filter to a subform (from
a control on the main form) by using the following code:
   Me.sfrMySubform.Filter = "[intMyField] = 7"
I've tried this solution but it isn't working for me.  Here's my code:

I have a problem with err.raise
I write a class module, and I want to use this mechanism to indicate errors
when user set wrong values to properties
But it seems the error is never raised (although, when I exit from the

I am a newbie to Access and am having trouble doing a calculation. I have
created a form that consists of two tables, (which I think means that I have
a subform). On my sub form named Order Details Subform I added a text box
that I named Extension that multiplies = [Price] * [QTY] ...

In an access 2000 invoice database, I want to have the user write a
credit memo (Norwegian: Kreditnota), or returning invoice. However I'm
not sure how I should arrange the table structure (if I at all need
this table [tblCreditMemo]). Or could I use a text-file starting with

Thank you in advance for any and all assistance, it is greatly appreciated.
I have tables that have a field that I want to change from Dam to Female and
Sire to Male. Is there simple code to loop through records and change this,
instead of doing it all manually?

I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

Hoping someonce can tell me what compatibility problems I might run
into when I have to have my Access Project developed on Access2K run
in a user environment where users are using Access2003 as well as
Access2000.

Thank you for all your assistance, it's greatly appreciated.
I'm trying to programatically build queries in my program based on standard
table naming conventions of "tbl".
I have used the code so graciously provided in this newsgroup referencing DAO

I tried to change the field name in a query using "New Name: [Field
Name]".  It did not work at all and just display the caption of the
Field Name.  Is it possible to change the field name or use a new
caption in query?

First I would like to apologize for not being able to provide an
informative subject for this message.
I am new to MS Access. I got two versions of the same Access
application. In the first version, I can browse all the properties of

I've been developing an Access database for our small office for several
years now so I am not a newbie. However, I have a need for which I am not
finding a mechanism to accomplish in the material that I have read.
We use an antique BBX/BASIC accounting program which we use to ...

I've got a TreeView on the left of my screen.  As the user navigates the tree, I
load corresonding detail info into the rest of the screen.
Works ok, but when the user clicks on a detail field, the TreeView's selection
rectangle goes away and the user is left wondering what happened ...

I imported several .dbf's from another application to use as the basis for
my form.  In addition to displaying the records that were created with the
original application my users will be adding new records.  I have one
field - "Request_Type" - which determines what appears in field

Design is as follows:
A form for the user to input criteria to be used as the where part of
the report's recordsource. This includes a multiselect list box as part
of the criteria selection.

Hi and TIA!  I was wondering how to use condition formatting to place arrows
in an unbound control.  So if I compare a value on my form with another
value, and the new value is >then the old value I would like to show an
arrow pointing up, if it's less an arrow down, etc.  Is this ...