Form/Subform Visual Basic Error?

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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?

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
on my machine to do this? I do have the database open in exclusive mode.
JDA

"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?

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" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?

What references do you have?

Have you disabled Name AutoCorrect and compacted?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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" wrote:

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


"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive
mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?

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" wrote:

What references do you have?

Have you disabled Name AutoCorrect and compacted?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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" wrote:

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


"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive
mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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" wrote:

What references do you have?

Have you disabled Name AutoCorrect and compacted?


"JDA" wrote in message
...
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" wrote:

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


"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive
mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?

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


"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JDA" wrote in message
...
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" wrote:

What references do you have?

Have you disabled Name AutoCorrect and compacted?


"JDA" wrote in message
...
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" wrote:

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


"JDA" wrote in message
...
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
on my machine to do this? I do have the database open in exclusive
mode.
JDA

"Allen Browne" wrote:

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


"JDA" wrote in message
...
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?