Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
addnew
I have a program that has rs.addnew as one of the first lines of code, even
if there are no records to be added. When exiting Excel, an error comes up that states "memory counld not be written." I believe it is because I cannot perform an rs.Close command because rs.Update is not executed. Is there a way to "cancel" the rs.addnew? Or is this a source of a different problem? Thank you. Brent |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
addnew
To what does the rs refer? It is obviously a variable of some type, so it
must be declared somewhere as a worksheet, shape, range or what? You could comment it out of the execution with an apostrophe and see if the code runs ok. 'rs.addnew "Brent" wrote: I have a program that has rs.addnew as one of the first lines of code, even if there are no records to be added. When exiting Excel, an error comes up that states "memory counld not be written." I believe it is because I cannot perform an rs.Close command because rs.Update is not executed. Is there a way to "cancel" the rs.addnew? Or is this a source of a different problem? Thank you. Brent |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
addnew
the rs is an object for a recordset. I am loading data from excel to oracle,
so I think I have to keep it. Brent "JLGWhiz" wrote: To what does the rs refer? It is obviously a variable of some type, so it must be declared somewhere as a worksheet, shape, range or what? You could comment it out of the execution with an apostrophe and see if the code runs ok. 'rs.addnew "Brent" wrote: I have a program that has rs.addnew as one of the first lines of code, even if there are no records to be added. When exiting Excel, an error comes up that states "memory counld not be written." I believe it is because I cannot perform an rs.Close command because rs.Update is not executed. Is there a way to "cancel" the rs.addnew? Or is this a source of a different problem? Thank you. Brent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Addnew | Excel Programming | |||
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks | Excel Programming |