Automation Error???

[Guest]

Suddenly something has gone wrong with my database. I tried re-compacting it
and removing and re-adding the OLE Automation library to no avail. Each time
I try to run a DLookup it returns the following error: "runtime error
'-2146500594 (800f000e)': automation error

When it does not return the error it returns a Null value where I know there
is no null. For example: =DLookUp("[LastName]", "Employees", _
"[EmployeeID] = " & Forms![Orders]![EmployeeID])

returns the automation error or tells me that there is a null value in the
form control when I know damn well there is not.

Any ideas???

 

[Alex Dybenko]

Check project references (menu tools-references), all checked should be in
place
Try to decompile:
http://www.mvps.org/access/bugs/bugs0008.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

I'd like to not jump to decompile. Everything was working well. I have a form
by the name "FormJournalID". There is a control box on it named "cboSelInv".
If I type ?Forms!FormJournalID.cboSelInv at the immediate window in VBA while
the form is open and not in design view with some data item selected I figure
that I should get a returned result of the selected data item. Instead, I get
the automation error. I cannot get the result of any textbox input either.
Does this mean I'm at the point where I should try to decompile?

Check project references (menu tools-references), all checked should be in
place
Try to decompile:
http://www.mvps.org/access/bugs/bugs0008.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Suddenly something has gone wrong with my database. I tried re-compacting
it
and removing and re-adding the OLE Automation library to no avail. Each
time
I try to run a DLookup it returns the following error: "runtime error
'-2146500594 (800f000e)': automation error

When it does not return the error it returns a Null value where I know
there
is no null. For example: =DLookUp("[LastName]", "Employees", _
"[EmployeeID] = " & Forms![Orders]![EmployeeID])

returns the automation error or tells me that there is a null value in the
form control when I know damn well there is not.

Any ideas???

 

[Brian Wilson]

I'd like to not jump to decompile. Everything was working well. I have a
form
by the name "FormJournalID". There is a control box on it named
"cboSelInv".
If I type ?Forms!FormJournalID.cboSelInv at the immediate window in VBA
while
the form is open and not in design view with some data item selected I
figure
that I should get a returned result of the selected data item. Instead, I
get
the automation error. I cannot get the result of any textbox input either.
Does this mean I'm at the point where I should try to decompile?

If you do the decompile on a copy, then you're only risking 30 seconds work!

Check project references (menu tools-references), all checked should be
in
place
Try to decompile:
http://www.mvps.org/access/bugs/bugs0008.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Suddenly something has gone wrong with my database. I tried
re-compacting
it
and removing and re-adding the OLE Automation library to no avail. Each
time
I try to run a DLookup it returns the following error: "runtime error
'-2146500594 (800f000e)': automation error

When it does not return the error it returns a Null value where I know
there
is no null. For example: =DLookUp("[LastName]", "Employees", _
"[EmployeeID] = " & Forms![Orders]![EmployeeID])

returns the automation error or tells me that there is a null value in
the
form control when I know damn well there is not.

Any ideas???

 

[TC]

Have you checked all these?


http://groups.google.com/groups/search?q="-2146500594"++OR++"+800f000e"

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Alex Dybenko]

Try to run ?Forms!FormJournalID!cboSelInv instead

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

I'd like to not jump to decompile. Everything was working well. I have a
form
by the name "FormJournalID". There is a control box on it named
"cboSelInv".
If I type ?Forms!FormJournalID.cboSelInv at the immediate window in VBA
while
the form is open and not in design view with some data item selected I
figure
that I should get a returned result of the selected data item. Instead, I
get
the automation error. I cannot get the result of any textbox input either.
Does this mean I'm at the point where I should try to decompile?

Check project references (menu tools-references), all checked should be
in
place
Try to decompile:
http://www.mvps.org/access/bugs/bugs0008.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Suddenly something has gone wrong with my database. I tried
re-compacting
it
and removing and re-adding the OLE Automation library to no avail. Each
time
I try to run a DLookup it returns the following error: "runtime error
'-2146500594 (800f000e)': automation error

When it does not return the error it returns a Null value where I know
there
is no null. For example: =DLookUp("[LastName]", "Employees", _
"[EmployeeID] = " & Forms![Orders]![EmployeeID])

returns the automation error or tells me that there is a null value in
the
form control when I know damn well there is not.

Any ideas???