A terrible mess

[Valerie]

Oh what a mess I've made! I started with a skeleton
database that was a modified version of the inventory
control template in Access 97. (I'm using it in 2000 and
it has apparently converted itself.)

I renamed some of my fields to make them better suited to
my application, and covered my tracks every way I knew
(and I know next to nothing about Access - this is my
first rodeo). I've cleaned up most of the mess, but I
still have one problem that's giving me fits.

The Parts form has a click box (I don't know what you
call it) where you can click it to go directly to the
purchase order form. Much to my horror, I found the
underlying code, then did a search and replace
changing "Product" to "Part". That's all. I have checked
the previous and revised versions over and over -- even
did a comparison of the two documents in Word -- and
that's all that's been changed. But I keep getting the
error message "Object doesn't support this property or
method" and then which I click ok I get "Microsoft Access
can't find the field 'Parts Subform' referred to in your
expression".

In replying, please keep in mind that I know NOTHING
about code so I'll need you to go V E R Y S L O W L Y.

Thanks in advance,

Val

 

[Roger Carlson]

The second error message is because there is a form named [Product Subform]
that you need to rename to [Parts Subform]. You changed the reference in
the code, but this refers to an acutal form, so you have to rename the form
as well.

I can't duplicate you first error. Maybe if you posted the code we could
spot it.

 

[Guest]

Thanks, Roger, but I found it. I can't remember where, but
somehow I got it fixed. Now onto the next challenge.

Thanks again,

Valerie

-----Original Message-----
The second error message is because there is a form named [Product Subform]
that you need to rename to [Parts Subform]. You changed the reference in
the code, but this refers to an acutal form, so you have to rename the form
as well.

I can't duplicate you first error. Maybe if you posted the code we could
spot it.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Oh what a mess I've made! I started with a skeleton
database that was a modified version of the inventory
control template in Access 97. (I'm using it in 2000 and
it has apparently converted itself.)

I renamed some of my fields to make them better suited to
my application, and covered my tracks every way I knew
(and I know next to nothing about Access - this is my
first rodeo). I've cleaned up most of the mess, but I
still have one problem that's giving me fits.

The Parts form has a click box (I don't know what you
call it) where you can click it to go directly to the
purchase order form. Much to my horror, I found the
underlying code, then did a search and replace
changing "Product" to "Part". That's all. I have checked
the previous and revised versions over and over -- even
did a comparison of the two documents in Word -- and
that's all that's been changed. But I keep getting the
error message "Object doesn't support this property or
method" and then which I click ok I get "Microsoft Access
can't find the field 'Parts Subform' referred to in your
expression".

In replying, please keep in mind that I know NOTHING
about code so I'll need you to go V E R Y S L O W L Y.

Thanks in advance,

Val

.