Form/Subform Visual Basic Error?

[Guest]

Hi,

I have created a form/subform with the form wizard - the form being a date
and train, and the subform being a log of delay events for that train (a
one-many relationship). When I try to add an event in the subform, access
returns the following error:

An Error Occured while referencing the object
you tried to run a visual basic procedure that improperly references a
property or method of an object.

I click the OK button and continue to enter data, and the records are
entered and related properly...this doesn't happen when I go to the table and
enter the delays there - any thoughts?

Thanks in advance,

JDA

 

[Allen Browne]

Press Ctrl+G to open the Immediate Window.
Choose Compile from the Debug menu.
Does this take you to a particular line of code where there is a problem?

If it does not, you may have a problem with References:
http://members.iinet.net.au/~allenbrowne/ser-38.html
or you may have a corruption caused by Name AutoCorrect, in which case you
could probably rescue the database by following the 6 steps for the first
symptom in this article:
http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[Guest]

When I press Ctrl+G, my immediate window only shows a blank "immediate"
window...I cannot find any modules to open...do I need administrator rights

 

[Allen Browne]

When you have the Immediate window open, are you able to get to the menus?

 

[Guest]

I can see the menus, and I can see my DB in the project window - the compile
(and most other) option is greyed out...there are no modules in the DB...?

 

[Allen Browne]

What references do you have?

Have you disabled Name AutoCorrect and compacted?

 

[Guest]

Visual Basic for Applications
MS 9.0 Object Library
OLE Automation
MS Active X Data Objects 2.1 Lib
MS DAO 3.6 Object Lib

I have run the Compact & Repair, and I have turned off AutoCorrect....?

 

[Allen Browne]

Okay: no code. Standard libraries. Compact/repair doesn't work.

Try creating a new (blank) database:
File | New
If the problem occurs there also, then you need to reinstall Office/Access.

 

[Guest]

Allen,

Thanks for the suggestions...I am going to try to start over, but I think
there's something cooking "uner the hood" - we run a custom build XP where I
work, and I have more trouble with permissions...IT paranoia I guess.

Thanks again,

JDA