error

[igg via AccessMonster.com]

i have a module that loops thru number of lines, parses them and updates or
inserts into tables.
for k = 0 to Ubound(Lines)
if ..
currentdb.excute "Update ..."
elseif ..
currentdb.excute "insert ..."
next k
if i replace the Ubound(Lines) with 1 or 2, after the for loop is finished i
get the "Object Invalid or no longer set" error.

 

[John Spencer]

I don't see anything in the posted code that would cause that. It would help
if you posted the actual code and not something you have typed into the
message window.

For instance, it is CurrentDB.EXECUTE not CurrentDB.excute.

Also, it helps if you can tell us the exact line where the error occurs.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[igg via AccessMonster.com]

i use dcount and dmax and they are slow. any simple custom module to speed up
the search for count and max. i tried some online custom functions which are
really good but in my case they cause crashes. Some codes or ideas that an
give me better understanding.

I don't see anything in the posted code that would cause that. It would help
if you posted the actual code and not something you have typed into the
message window.

For instance, it is CurrentDB.EXECUTE not CurrentDB.excute.

Also, it helps if you can tell us the exact line where the error occurs.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

i have a module that loops thru number of lines, parses them and updates or
inserts into tables.

[quoted text clipped - 6 lines]

if i replace the Ubound(Lines) with 1 or 2, after the for loop is finished i
get the "Object Invalid or no longer set" error.