References Errors and generally other weird behavior

[ChristimeS]

I'm having a problem with access 2000 on my system. I have uninstalled and
reinstalled it several times and occasionally the problem is fixed for a
short time and then reoccurs. I have code that runs at my clients and on my
laptop and was running perfectly on my desktop but now doesn't. I am using
the following line of code on doing a resize of forms based on the screen
size.
strName = frm.Parent.NAME
the error I get is "The expression you entered has an invalid reference to
the Parent property.
I'm also having other problems like when I use on error resume next doesn't
skip to the next line after the error but returns the error.
Also my help files are missing for some of the properties of recordsets and
if I press F1 on one of them I get an error to fix my help files but they
never get fixed. This is very frustrating and I know it relates to my
references but I can't see anything wrong with them. Sorry for the length of
this message but would really appreciate it if someone could point me in the
right direction. Thanks Chris

 

[Alex Dybenko]

hi,
if you are using subforms and resize event - could happen that main form
with subforms is not loaded yet, when you run this code.
I would suggest you to put On Error Resume next - I think this is a good
solution for resize event

 

[ChristimeS]

My problem is more about the fact that there is something wrong with my
Access probably with the references. The on error resume next does not work
and the code I'm using works everywhere except on my computer. There is
something wrong with my installation but I have uninstalled and reinstalled
and can't make certain of my help files, etc. work correctly. Thanks
Christine

 

[Alex Dybenko]

Hi Christine,
well, then have you checked your references?
make sure you only have ones you really use, then try to decompile
http://www.mvps.org/access/bugs/bugs0008.htm
and compile again

one more approach = to use form variables in your code as:

dim frmParent as form
frmParent = frm.Parent.Form
strName = frmParent.NAME