Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes during a module execution
doesn't work...
"AA2e72E" wrote: You might try replacing .Fields.Append "QtÃ*", adInteger by .Fields.Append "[QtÃ*]", adInteger "Renato" wrote: Hi all, I'm using inside Excel2000 a VBA module where at a certain point I use a temporary ADO recordset : when I recall the open method (see the code below) Excel crashes with the following error : The instruction at "0x1f4474b6" refers to the memory at "0x00000530".The memory could not be "written". This happened on a Windows2000prof sp4 machine (MDAC 2.8). I tried the same code on a Windows98-2ED machine and everything works properly! Why? Thank in advance for any help. Renato Debiasi ... dim rsteventi as New ADODB.Recordset ... Set rsteventi = New ADODB.Recordset With rsteventi .Fields.Append "Ev", adBSTR, 10 .Fields.Append "St", adBSTR, 1 .Fields.Append "T", adBSTR, 1 .Fields.Append "Num", adInteger .Fields.Append "CliFor", adBSTR, 20 .Fields.Append "RifCli", adBSTR, 10 .Fields.Append "Val", adBSTR, 3 .Fields.Append "ValTot", adInteger .Fields.Append "QtÃ*", adInteger .Fields.Append "Disp", adInteger .CursorType = adOpenStatic .LockType = adLockOptimistic .Open End With .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - VBA Code execution in Excel | New Users to Excel | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Excel to Powerpoint Slow Execution | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |