Program Error - MSAccess.exe has generated errors and will be closed by Windows

J

June Macleod

I have a form with a listbox on it (the rowsource for the list box is a
query based on the same table that is the rowsource for the form, sans
current record). When the form loads it calls a procedure which selects
items in the list box based on the contents of a text box i.e. If [BASEDON]
contains "2,6,8" then the second, sixth and eighth items in the listbox will
be selected.

This all seems to work however when I close the form I get an error message:

"MsAccess.exe has generated errors and will be closed by Windows. An
error log will be created."

(error log entry is at bottom of this message)

I stripped everything out of the form and it would appear that it is the
call in the Load Event to the FillInWellList that determines if I am going
to get this error when I close the form.

The code is below.

If someone could tell me what I am doing wrong then I would be greatly
appreciative.

Thank you

June Macleod

'******************************************
Public Sub FillInWellList()
On Error GoTo err_fillinwellList
Dim ctlsource As Control
Dim intCurrentRow As Integer
Dim frm As Form
Dim thestrarray$
If [BasedON] > "" And Not IsNull([BasedON]) Then
Set frm = Me
Set ctlsource = frm.Controls("lstWells")
thestrarray = [BasedON]
Do While InStr(1, thestrarray, ",") > 0
x = InStr(1, thestrarray, ",")
thenum = Left(thestrarray, Len(thestrarray) - (x - 1))
For intCurrentRow = 0 To ctlsource.ListCount - 1
If ctlsource.Column(0, intCurrentRow) = thenum Then
ctlsource.Selected(intCurrentRow) = True
End If
Next intCurrentRow
thestrarray = Mid$(thestrarray, x + 1)
Loop
End If

Set frm = Nothing
Set ctlsource = Nothing
exit_fillinwellList:
Exit Sub
err_fillinwellList:
thiserr = record_errors(Err, Left(Err.Description, 255), "Project Header
Information - fillinwellList", gErrorName)
Resume exit_fillinwellList
End Sub


'***************************************************




Below is a note of the text in the error log.

Application exception occurred:
App: (pid=940)
When: 7/18/2003 @ 09:54:57.218
Exception number: c0000005 (access violation)

*----> System Information <----*
Computer Name: JUNE2K
User Name: june
Number of Processors: 1
Processor Type: x86 Family 15 Model 2 Stepping 4
Windows 2000 Version: 5.0
Current Build: 2195
Service Pack: 3
Current Type: Uniprocessor Free
Registered Organization: Allomax
Registered Owner: June

*----> Task List <----*
0 Idle.exe
8 System.exe
168 SMSS.exe
192 CSRSS.exe
212 WINLOGON.exe
240 SERVICES.exe
252 LSASS.exe
428 svchost.exe
460 spoolsv.exe
532 jrunsvc.exe
552 swagent.exe
564 jrun.exe
572 swstrtr.exe
580 swsoc.exe
624 DefWatch.exe
640 svchost.exe
664 ibguard.exe
744 Rtvscan.exe
852 regsvc.exe
868 mstask.exe
884 snmp.exe
932 WinMgmt.exe
984 svchost.exe
1000 inetinfo.exe
1636 ibserver.exe
388 explorer.exe
1912 sxgtkbar.exe
1920 CreateCD50.exe
1864 Directcd.exe
1936 VPTray.exe
1620 CMESys.exe
1376 evntsvc.exe
1824 msnmsgr.exe
1924 AcroTray.exe
688 svchost.exe
1992 WinCinemaMgr.ex.exe
448 GMT.exe
2140 OUTLOOK.exe
2160 MAPISP32.exe
940 MSACCESS.exe
1904 DRWTSN32.exe
0 _Total.exe

(30000000 - 30491000)
(77F80000 - 77FFA000)
(77F40000 - 77F79000)
(77E80000 - 77F31000)
(77E10000 - 77E6F000)
(77DB0000 - 77E0B000)
(77D30000 - 77DA1000)
(308C0000 - 30E1D000)
(77A50000 - 77B45000)
(37020000 - 370BE000)
(775A0000 - 77625000)
(779B0000 - 77A4B000)
(78000000 - 78046000)
(480A0000 - 480E0000)
(76620000 - 76630000)
(6C370000 - 6C462000)
(48120000 - 48137000)
(71710000 - 71794000)
(1B000000 - 1B16F000)
(1B5C0000 - 1B655000)
(65000000 - 65263000)
(65300000 - 65327000)
(1B7F0000 - 1B82A000)
(08D10000 - 08E59000)
(70BD0000 - 70C35000)

State Dump for Thread Id 0x88c

eax=028b76d0 ebx=3001a8b8 ecx=00000000 edx=0017db98 esi=0017db98
edi=00000000
eip=30024867 esp=0012de6c ebp=0012df2c iopl=0 nv up ei pl nz na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000202


function: <nosymbols>
30024848 81eca0000000 sub esp,0xa0
3002484e 53 push ebx
3002484f 56 push esi
30024850 57 push edi
30024851 8bf1 mov esi,ecx
30024853 e86c77ffff call Ordinal23+0x1bfc4 (3001bfc4)
30024858 ff7518 push dword ptr [ebp+0x18]
ss:00bab4fe=????????
3002485b 8b4d08 mov ecx,[ebp+0x8]
ss:00bab4fe=????????
3002485e 8b80d0000000 mov eax,[eax+0xd0]
ds:028b77a0=0000000a
30024864 ff7514 push dword ptr [ebp+0x14]
ss:00bab4fe=????????
FAULT ->30024867 8b4960 mov ecx,[ecx+0x60]
ds:00a7d5d2=????????
3002486a ff7510 push dword ptr [ebp+0x10]
ss:00bab4fe=????????
3002486d ff750c push dword ptr [ebp+0xc]
ss:00bab4fe=????????
30024870 ff7630 push dword ptr [esi+0x30]
ds:00bfb16a=????????
30024873 51 push ecx
30024874 50 push eax
30024875 ff1528fc3f30 call dword ptr [303ffc28]
ds:303ffc28=30024950
3002487b 33db xor ebx,ebx
3002487d 33c9 xor ecx,ecx
3002487f 3bc3 cmp eax,ebx
30024881 8bd0 mov edx,eax
30024883 0f9cc1 setl cl

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012DF2C 30024805 00000000 0012DF74 00000004 00000010 !Ordinal23
0012DF58 30150AED 0012DF74 00000004 00000010 00000000 !Ordinal23
0012E1A0 300D0B98 00000004 0012E20C 00000001 00000000 !FSaveActidHscr
0012E1E8 300C4BE9 0012E20C 00000001 00000001 00000001
!JETESLoadProjectTypeLib
0012E224 300C4CF7 08C10848 00000002 00000000 00000001 !AccessLoadString
0012EA84 300C4F00 00000000 0012ECE8 0012ECE8 00000000 !AccessLoadString
0012EA9C 300C413C 08C10848 00000000 00000000 00000000 !AccessLoadString
0012ECD4 3008AFC6 30106FBD 08C10848 00010356 0000800B !AccessLoadString
0012ED88 300888C8 00000000 30106FFD 0012EDB0 30106FF8 !AccessLoadString
0012EDC4 3008DB05 00000001 00000ACE 3008CE2C 00000ACE !AccessLoadString
0012EEE0 77E3A244 00010356 00000ACE 00000000 00000000 !AccessLoadString
0012EF00 77E16B21 3008CE2C 00010356 00000ACE 00000000
user32!SetWindowPlacement
0012EF24 77E24F4A 3008CE2C 00010356 00000ACE 00000000 user32!ScreenToClient
0012EF44 3008F6E7 3008CE2C 00010356 00000ACE 00000000 user32!CallWindowProcW
0012EFB0 77E3A244 00010356 00000ACE 00000000 00000000 !AccessLoadString
0012EFD0 77E16362 3008F5F0 00010356 00000ACE 00000000
user32!SetWindowPlacement
0012F000 77E17341 00474218 00000ACE 00000000 00000000 user32!IsWindowVisible
0012F020 30106E3C 00010356 00000ACE 00000000 00000000 user32!SendMessageW
0012F254 30191903 00000001 3006586F 00000000 0012F398 !Error
0012F320 300951F6 00000000 00000201 0012F398 00000000 !MSAU_ErrGetRegKeyInfo
0012F368 30094C76 0012F3F8 0012FD20 0012FD08 00000000 !AccessLoadString
0012F384 3009444E 0000003D 0012FD30 0012FD08 00008008 !AccessLoadString
0012F450 30042809 009C0092 00020340 00000201 00000001 !AccessLoadString
0012FCF0 3004229C 30026718 0012FE00 0012FE08 C0000000 !CreateIExprSrvObj
0012FD24 77E3A244 00000000 00000000 00000001 009C0092 !CreateIExprSrvObj
0012FD44 77E145E5 3004220D 00020340 00000201 00000001
user32!SetWindowPlacement
0012FDD0 77E1A792 0012FE00 00000000 30960072 0012FE00
user32!TranslateMessageEx
0012FE44 3000412F 00000000 00000000 004E002F 0053004F
user32!DispatchMessageW
0012FF34 30001C13 30000000 00000000 001326B8 00000001 !Ordinal23
0012FFC0 77EA847C 00000000 00000000 7FFDF000 C0000005 !Ordinal23
0012FFF0 00000000 30001AE0 00000000 000000C8 00000100
kernel32!ProcessIdToSessionId

*----> Raw Stack Dump <----*
0012de6c 10 00 00 00 00 00 00 00 - 00 00 00 00 98 db 17 00
.................
0012de7c b8 a8 01 30 00 00 00 00 - 00 00 00 00 00 00 f0 3f
....0...........?
0012de8c 00 00 00 00 09 08 00 00 - f1 de 12 00 00 00 00 00
.................
0012de9c 00 00 00 00 00 00 00 00 - 20 00 00 00 00 00 00 00 ........
........
0012deac 01 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
0012debc f1 de 12 00 01 00 00 00 - 00 00 00 00 00 00 00 00
.................
0012decc 7d e8 9d 77 04 df 12 00 - f0 de 12 00 20 00 00 00 }..w........
....
0012dedc e0 de 12 00 05 00 12 00 - 6b 63 09 30 00 00 00 00
.........kc.0....
0012deec 00 00 f0 3f 01 63 09 30 - 00 00 00 00 00 00 00 00
....?.c.0........
0012defc 04 00 00 00 00 02 00 00 - 01 00 00 00 ff 1f 00 00
.................
0012df0c 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00
.................
0012df1c 48 48 02 30 78 ea 12 00 - 5a 67 3b 30 ff ff ff ff
HH.0x...Zg;0....
0012df2c 58 df 12 00 05 48 02 30 - 00 00 00 00 74 df 12 00
X....H.0....t...
0012df3c 04 00 00 00 10 00 00 00 - 00 00 00 00 01 00 00 00
.................
0012df4c 04 00 00 00 10 00 00 00 - 00 02 00 00 a0 e1 12 00
.................
0012df5c ed 0a 15 30 74 df 12 00 - 04 00 00 00 10 00 00 00
....0t...........
0012df6c 00 00 00 00 02 00 00 00 - 01 00 00 00 0c e2 12 00
.................
0012df7c f1 0e 0b 30 b4 e1 12 00 - 48 08 c1 08 0c e2 12 00
....0....H.......
0012df8c 01 00 00 00 21 6b e1 77 - 02 01 00 00 00 01 00 00
.....!k.w........
0012df9c c5 00 00 00 00 00 bb 07 - 40 15 bb 07 78 01 bb 07
[email protected]...

State Dump for Thread Id 0x624

eax=77d424c2 ebx=00141820 ecx=00140044 edx=00000000 esi=001416d8
edi=00000100
eip=77f88a97 esp=0207fe28 ebp=0207ff74 iopl=0 nv up ei pl nz na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000206


function: ZwReplyWaitReceivePortEx
77f88a8c b8ac000000 mov eax,0xac
77f88a91 8d542404 lea edx,[esp+0x4]
ss:02afd3fb=????????
77f88a95 cd2e int 2e
77f88a97 c21400 ret 0x14
77f88a9a 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0207FF74 77D420D9 77D42528 001416D8 00000000 401411C8
ntdll!ZwReplyWaitReceivePortEx
0207FFA8 77D424DA 00141680 0207FFEC 77E8B2D8 00141820
rpcrt4!NdrConformantArrayMemorySize
0207FFB4 77E8B2D8 00141820 00000000 401411C8 00141820
rpcrt4!NdrConformantArrayMemorySize
0207FFEC 00000000 77D424C2 00141820 00000000 000000C8 kernel32!lstrcmpiW

*----> Raw Stack Dump <----*
0207fe28 85 22 d4 77 64 01 00 00 - 54 ff 07 02 00 00 00 00
..".wd...T.......
0207fe38 60 44 14 00 58 ff 07 02 - e0 f6 13 00 80 16 14 00
`D..X...........
0207fe48 20 18 14 00 1f 00 00 00 - 50 f7 0a 82 50 f7 0a 82
........P...P...
0207fe58 00 00 00 00 01 00 00 00 - b4 eb de ba 00 00 00 00
.................
0207fe68 b8 04 22 e3 78 eb de ba - 00 00 00 00 72 4f 41 80
...".x.......rOA.
0207fe78 50 f8 0a 82 00 c2 0a 82 - 68 ec de ba ca 08 45 80
P.......h.....E.
0207fe88 04 00 00 00 68 68 6f 81 - 66 41 4a 80 80 f3 12 00
.....hho.fAJ.....
0207fe98 00 00 00 00 48 f3 12 00 - 74 2f 0b 00 00 00 00 00
.....H...t/......
0207fea8 00 00 00 00 01 00 00 00 - 19 00 02 00 00 00 00 00
.................
0207feb8 19 00 02 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
0207fec8 ac 03 00 00 00 00 00 00 - 0c ec de ba 00 00 00 00
.................
0207fed8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
0207fee8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
0207fef8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
0207ff08 00 00 00 00 c8 28 50 c0 - a8 00 00 00 00 20 50 c0 .....(P......
P.
0207ff18 19 00 02 00 06 00 02 00 - a8 00 00 00 01 00 00 00
.................
0207ff28 00 20 50 c0 00 47 6f 81 - 20 fc 62 81 00 00 00 00 . P..Go.
..b.....
0207ff38 20 fc 62 81 b0 fd 62 81 - 64 ec de ba f3 da 42 80
..b...b.d.....B.
0207ff48 a4 da 42 80 d4 4b 06 80 - 80 fd 62 81 20 fc 62 81 ..B..K....b.
..b.
0207ff58 00 a2 2f 4d ff ff ff ff - 50 fe 07 02 ff ff ff ff
.../M....P.......

State Dump for Thread Id 0x628

eax=1b0034a3 ebx=06eaff0c ecx=77fb64f4 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=06eafef0 ebp=06eaff14 iopl=0 nv up ei ng nz ac po
cy
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000297


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:0792d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06EAFF14 77E8B32B 00000190 00000C26 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

State Dump for Thread Id 0x7ac

eax=00000000 ebx=00000000 ecx=00000101 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=06fafef0 ebp=06faff14 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:07a2d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06FAFF14 77E8B32B 00000190 FFFFFFFF 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

State Dump for Thread Id 0x4d0

eax=000000af ebx=00000000 ecx=028b07e0 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=070afef0 ebp=070aff14 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:07b2d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
070AFF14 77E8B32B 00000190 FFFFFFFF 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

*----> Raw Stack Dump <----*
070afef0 35 9b ea 77 90 01 00 00 - 00 00 00 00 00 00 00 00
5..w............
070aff00 ff ff ff ff 30 08 8b 02 - 7c ff 0a 07 90 01 00 00
.....0...|.......
070aff10 90 01 00 00 00 00 00 00 - 2b b3 e8 77 90 01 00 00
.........+..w....
070aff20 ff ff ff ff 00 00 00 00 - 7b 99 00 1b 90 01 00 00
.........{.......
070aff30 ff ff ff ff 43 99 00 1b - ff ff ff ff 7c ff 0a 07
.....C.......|...
070aff40 ac c3 e9 77 10 ae 8b 02 - 00 00 00 00 d0 fd 11 1b
....w............
070aff50 00 00 00 00 ff ff ff ff - d0 04 00 00 94 35 00 1b
..............5..
070aff60 7c ff 0a 07 ac c3 e9 77 - 30 da 12 00 ec ff 0a 07
|......w0.......
070aff70 d0 fd 11 1b 10 ae 8b 02 - b0 01 00 00 01 00 00 00
.................
070aff80 00 00 00 00 00 00 00 00 - a2 0d 43 80 00 00 00 00
...........C.....
070aff90 00 00 00 00 db 0d 43 80 - 00 47 6f 81 a0 cd 67 81
.......C..Go...g.
070affa0 ff ff ff ff 01 00 00 00 - 00 00 00 00 00 00 00 00
.................
070affb0 00 00 00 00 fd 9b f8 77 - d8 b2 e8 77 d0 fd 11 1b
........w...w....
070affc0 ac c3 e9 77 30 da 12 00 - d0 fd 11 1b 00 a0 fd 7f
....w0...........
070affd0 f4 64 fb 77 c0 ff 0a 07 - f4 64 fb 77 ff ff ff ff
..d.w.....d.w....
070affe0 6c 13 ed 77 98 2a e8 77 - 00 00 00 00 00 00 00 00
l..w.*.w........
070afff0 00 00 00 00 a3 34 00 1b - d0 fd 11 1b 00 00 00 00
......4..........
070b0000 00 00 00 00 00 00 ff ff - 00 00 00 00 fc 3e 00 00
..............>..
070b0010 b4 ee 01 30 00 ec 4a 00 - 18 00 00 00 60 aa 14 00
....0..J.....`...
070b0020 04 00 00 00 09 04 00 00 - 04 00 00 00 20 00 00 00 ............
....

State Dump for Thread Id 0x1e8

eax=650210a8 ebx=00000000 ecx=0012d244 edx=00000000 esi=77f882f8
edi=08bcff98
eip=77f88303 esp=08bcff84 ebp=08bcffa0 iopl=0 nv up ei pl nz na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000202


function: NtDelayExecution
77f882f8 b832000000 mov eax,0x32
77f882fd 8d542404 lea edx,[esp+0x4]
ss:0964d557=????????
77f88301 cd2e int 2e
77f88303 c20800 ret 0x8
77f88306 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
08BCFFA0 77EA9D5F 000000C8 00000000 650210B3 000000C8 ntdll!NtDelayExecution
08BCFFEC 00000000 650210A8 00000000 00000000 08BD0040 kernel32!Sleep

*----> Raw Stack Dump <----*
08bcff84 94 9d ea 77 00 00 00 00 - 98 ff bc 08 09 04 00 00
....w............
08bcff94 01 00 03 00 80 7b e1 ff - ff ff ff ff ec ff bc 08
......{..........
08bcffa4 5f 9d ea 77 c8 00 00 00 - 00 00 00 00 b3 10 02 65
_..w...........e
08bcffb4 c8 00 00 00 d8 b2 e8 77 - 00 00 00 00 09 04 00 00
........w........
08bcffc4 01 00 03 00 00 00 00 00 - 00 90 fd 7f 44 d2 12 00
.............D...
08bcffd4 c0 ff bc 08 44 d2 12 00 - ff ff ff ff 6c 13 ed 77
.....D.......l..w
08bcffe4 98 2a e8 77 00 00 00 00 - 00 00 00 00 00 00 00 00
..*.w............
08bcfff4 a8 10 02 65 00 00 00 00 - 00 00 00 00 40 00 bd 08
....e........@...
08bd0004 00 00 00 00 00 00 00 00 - 19 00 00 00 02 00 00 00
.................
08bd0014 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd0024 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd0034 00 00 00 00 00 00 00 00 - 00 00 00 00 52 0a bd 08
.............R...
08bd0044 00 00 bd 08 00 00 00 00 - 1a 00 00 00 19 00 00 00
.................
08bd0054 98 00 bd 08 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd0064 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd0074 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd0084 e8 15 00 00 98 00 bd 08 - 01 00 05 00 1a 00 00 00
.................
08bd0094 ca 01 00 00 07 00 00 00 - 90 cf 13 00 28 39 1f 00
.............(9..
08bd00a4 80 00 bd 08 00 00 00 00 - 00 00 00 00 00 00 00 00
.................
08bd00b4 00 00 00 00 00 00 00 00 - 60 00 16 00 01 00 00 00
.........`.......
 
J

June Macleod

I think I may have found the problem myself. With all my chopping and
changing I had my Listbox Multiselect Property set to None. As soon as I
changed it to Extended the error went away.

June (feeling a total fool <g>)


June Macleod said:
I have a form with a listbox on it (the rowsource for the list box is a
query based on the same table that is the rowsource for the form, sans
current record). When the form loads it calls a procedure which selects
items in the list box based on the contents of a text box i.e. If [BASEDON]
contains "2,6,8" then the second, sixth and eighth items in the listbox will
be selected.

This all seems to work however when I close the form I get an error message:

"MsAccess.exe has generated errors and will be closed by Windows. An
error log will be created."

(error log entry is at bottom of this message)

I stripped everything out of the form and it would appear that it is the
call in the Load Event to the FillInWellList that determines if I am going
to get this error when I close the form.

The code is below.

If someone could tell me what I am doing wrong then I would be greatly
appreciative.

Thank you

June Macleod

'******************************************
Public Sub FillInWellList()
On Error GoTo err_fillinwellList
Dim ctlsource As Control
Dim intCurrentRow As Integer
Dim frm As Form
Dim thestrarray$
If [BasedON] > "" And Not IsNull([BasedON]) Then
Set frm = Me
Set ctlsource = frm.Controls("lstWells")
thestrarray = [BasedON]
Do While InStr(1, thestrarray, ",") > 0
x = InStr(1, thestrarray, ",")
thenum = Left(thestrarray, Len(thestrarray) - (x - 1))
For intCurrentRow = 0 To ctlsource.ListCount - 1
If ctlsource.Column(0, intCurrentRow) = thenum Then
ctlsource.Selected(intCurrentRow) = True
End If
Next intCurrentRow
thestrarray = Mid$(thestrarray, x + 1)
Loop
End If

Set frm = Nothing
Set ctlsource = Nothing
exit_fillinwellList:
Exit Sub
err_fillinwellList:
thiserr = record_errors(Err, Left(Err.Description, 255), "Project Header
Information - fillinwellList", gErrorName)
Resume exit_fillinwellList
End Sub


'***************************************************




Below is a note of the text in the error log.

Application exception occurred:
App: (pid=940)
When: 7/18/2003 @ 09:54:57.218
Exception number: c0000005 (access violation)

*----> System Information <----*
Computer Name: JUNE2K
User Name: june
Number of Processors: 1
Processor Type: x86 Family 15 Model 2 Stepping 4
Windows 2000 Version: 5.0
Current Build: 2195
Service Pack: 3
Current Type: Uniprocessor Free
Registered Organization: Allomax
Registered Owner: June

*----> Task List <----*
0 Idle.exe
8 System.exe
168 SMSS.exe
192 CSRSS.exe
212 WINLOGON.exe
240 SERVICES.exe
252 LSASS.exe
428 svchost.exe
460 spoolsv.exe
532 jrunsvc.exe
552 swagent.exe
564 jrun.exe
572 swstrtr.exe
580 swsoc.exe
624 DefWatch.exe
640 svchost.exe
664 ibguard.exe
744 Rtvscan.exe
852 regsvc.exe
868 mstask.exe
884 snmp.exe
932 WinMgmt.exe
984 svchost.exe
1000 inetinfo.exe
1636 ibserver.exe
388 explorer.exe
1912 sxgtkbar.exe
1920 CreateCD50.exe
1864 Directcd.exe
1936 VPTray.exe
1620 CMESys.exe
1376 evntsvc.exe
1824 msnmsgr.exe
1924 AcroTray.exe
688 svchost.exe
1992 WinCinemaMgr.ex.exe
448 GMT.exe
2140 OUTLOOK.exe
2160 MAPISP32.exe
940 MSACCESS.exe
1904 DRWTSN32.exe
0 _Total.exe

(30000000 - 30491000)
(77F80000 - 77FFA000)
(77F40000 - 77F79000)
(77E80000 - 77F31000)
(77E10000 - 77E6F000)
(77DB0000 - 77E0B000)
(77D30000 - 77DA1000)
(308C0000 - 30E1D000)
(77A50000 - 77B45000)
(37020000 - 370BE000)
(775A0000 - 77625000)
(779B0000 - 77A4B000)
(78000000 - 78046000)
(480A0000 - 480E0000)
(76620000 - 76630000)
(6C370000 - 6C462000)
(48120000 - 48137000)
(71710000 - 71794000)
(1B000000 - 1B16F000)
(1B5C0000 - 1B655000)
(65000000 - 65263000)
(65300000 - 65327000)
(1B7F0000 - 1B82A000)
(08D10000 - 08E59000)
(70BD0000 - 70C35000)

State Dump for Thread Id 0x88c

eax=028b76d0 ebx=3001a8b8 ecx=00000000 edx=0017db98 esi=0017db98
edi=00000000
eip=30024867 esp=0012de6c ebp=0012df2c iopl=0 nv up ei pl nz na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000202


function: <nosymbols>
30024848 81eca0000000 sub esp,0xa0
3002484e 53 push ebx
3002484f 56 push esi
30024850 57 push edi
30024851 8bf1 mov esi,ecx
30024853 e86c77ffff call Ordinal23+0x1bfc4 (3001bfc4)
30024858 ff7518 push dword ptr [ebp+0x18]
ss:00bab4fe=????????
3002485b 8b4d08 mov ecx,[ebp+0x8]
ss:00bab4fe=????????
3002485e 8b80d0000000 mov eax,[eax+0xd0]
ds:028b77a0=0000000a
30024864 ff7514 push dword ptr [ebp+0x14]
ss:00bab4fe=????????
FAULT ->30024867 8b4960 mov ecx,[ecx+0x60]
ds:00a7d5d2=????????
3002486a ff7510 push dword ptr [ebp+0x10]
ss:00bab4fe=????????
3002486d ff750c push dword ptr [ebp+0xc]
ss:00bab4fe=????????
30024870 ff7630 push dword ptr [esi+0x30]
ds:00bfb16a=????????
30024873 51 push ecx
30024874 50 push eax
30024875 ff1528fc3f30 call dword ptr [303ffc28]
ds:303ffc28=30024950
3002487b 33db xor ebx,ebx
3002487d 33c9 xor ecx,ecx
3002487f 3bc3 cmp eax,ebx
30024881 8bd0 mov edx,eax
30024883 0f9cc1 setl cl

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012DF2C 30024805 00000000 0012DF74 00000004 00000010 !Ordinal23
0012DF58 30150AED 0012DF74 00000004 00000010 00000000 !Ordinal23
0012E1A0 300D0B98 00000004 0012E20C 00000001 00000000 !FSaveActidHscr
0012E1E8 300C4BE9 0012E20C 00000001 00000001 00000001
!JETESLoadProjectTypeLib
0012E224 300C4CF7 08C10848 00000002 00000000 00000001 !AccessLoadString
0012EA84 300C4F00 00000000 0012ECE8 0012ECE8 00000000 !AccessLoadString
0012EA9C 300C413C 08C10848 00000000 00000000 00000000 !AccessLoadString
0012ECD4 3008AFC6 30106FBD 08C10848 00010356 0000800B !AccessLoadString
0012ED88 300888C8 00000000 30106FFD 0012EDB0 30106FF8 !AccessLoadString
0012EDC4 3008DB05 00000001 00000ACE 3008CE2C 00000ACE !AccessLoadString
0012EEE0 77E3A244 00010356 00000ACE 00000000 00000000 !AccessLoadString
0012EF00 77E16B21 3008CE2C 00010356 00000ACE 00000000
user32!SetWindowPlacement
0012EF24 77E24F4A 3008CE2C 00010356 00000ACE 00000000 user32!ScreenToClient
0012EF44 3008F6E7 3008CE2C 00010356 00000ACE 00000000 user32!CallWindowProcW
0012EFB0 77E3A244 00010356 00000ACE 00000000 00000000 !AccessLoadString
0012EFD0 77E16362 3008F5F0 00010356 00000ACE 00000000
user32!SetWindowPlacement
0012F000 77E17341 00474218 00000ACE 00000000 00000000 user32!IsWindowVisible
0012F020 30106E3C 00010356 00000ACE 00000000 00000000 user32!SendMessageW
0012F254 30191903 00000001 3006586F 00000000 0012F398 !Error
0012F320 300951F6 00000000 00000201 0012F398 00000000 !MSAU_ErrGetRegKeyInfo
0012F368 30094C76 0012F3F8 0012FD20 0012FD08 00000000 !AccessLoadString
0012F384 3009444E 0000003D 0012FD30 0012FD08 00008008 !AccessLoadString
0012F450 30042809 009C0092 00020340 00000201 00000001 !AccessLoadString
0012FCF0 3004229C 30026718 0012FE00 0012FE08 C0000000 !CreateIExprSrvObj
0012FD24 77E3A244 00000000 00000000 00000001 009C0092 !CreateIExprSrvObj
0012FD44 77E145E5 3004220D 00020340 00000201 00000001
user32!SetWindowPlacement
0012FDD0 77E1A792 0012FE00 00000000 30960072 0012FE00
user32!TranslateMessageEx
0012FE44 3000412F 00000000 00000000 004E002F 0053004F
user32!DispatchMessageW
0012FF34 30001C13 30000000 00000000 001326B8 00000001 !Ordinal23
0012FFC0 77EA847C 00000000 00000000 7FFDF000 C0000005 !Ordinal23
0012FFF0 00000000 30001AE0 00000000 000000C8 00000100
kernel32!ProcessIdToSessionId

*----> Raw Stack Dump <----*
0012de6c 10 00 00 00 00 00 00 00 - 00 00 00 00 98 db 17 00
................
0012de7c b8 a8 01 30 00 00 00 00 - 00 00 00 00 00 00 f0 3f
...0...........?
0012de8c 00 00 00 00 09 08 00 00 - f1 de 12 00 00 00 00 00
................
0012de9c 00 00 00 00 00 00 00 00 - 20 00 00 00 00 00 00 00 ........
.......
0012deac 01 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0012debc f1 de 12 00 01 00 00 00 - 00 00 00 00 00 00 00 00
................
0012decc 7d e8 9d 77 04 df 12 00 - f0 de 12 00 20 00 00 00 }..w........
...
0012dedc e0 de 12 00 05 00 12 00 - 6b 63 09 30 00 00 00 00
........kc.0....
0012deec 00 00 f0 3f 01 63 09 30 - 00 00 00 00 00 00 00 00
...?.c.0........
0012defc 04 00 00 00 00 02 00 00 - 01 00 00 00 ff 1f 00 00
................
0012df0c 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00
................
0012df1c 48 48 02 30 78 ea 12 00 - 5a 67 3b 30 ff ff ff ff
HH.0x...Zg;0....
0012df2c 58 df 12 00 05 48 02 30 - 00 00 00 00 74 df 12 00
X....H.0....t...
0012df3c 04 00 00 00 10 00 00 00 - 00 00 00 00 01 00 00 00
................
0012df4c 04 00 00 00 10 00 00 00 - 00 02 00 00 a0 e1 12 00
................
0012df5c ed 0a 15 30 74 df 12 00 - 04 00 00 00 10 00 00 00
...0t...........
0012df6c 00 00 00 00 02 00 00 00 - 01 00 00 00 0c e2 12 00
................
0012df7c f1 0e 0b 30 b4 e1 12 00 - 48 08 c1 08 0c e2 12 00
...0....H.......
0012df8c 01 00 00 00 21 6b e1 77 - 02 01 00 00 00 01 00 00
....!k.w........
0012df9c c5 00 00 00 00 00 bb 07 - 40 15 bb 07 78 01 bb 07
[email protected]...

State Dump for Thread Id 0x624

eax=77d424c2 ebx=00141820 ecx=00140044 edx=00000000 esi=001416d8
edi=00000100
eip=77f88a97 esp=0207fe28 ebp=0207ff74 iopl=0 nv up ei pl nz na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000206


function: ZwReplyWaitReceivePortEx
77f88a8c b8ac000000 mov eax,0xac
77f88a91 8d542404 lea edx,[esp+0x4]
ss:02afd3fb=????????
77f88a95 cd2e int 2e
77f88a97 c21400 ret 0x14
77f88a9a 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0207FF74 77D420D9 77D42528 001416D8 00000000 401411C8
ntdll!ZwReplyWaitReceivePortEx
0207FFA8 77D424DA 00141680 0207FFEC 77E8B2D8 00141820
rpcrt4!NdrConformantArrayMemorySize
0207FFB4 77E8B2D8 00141820 00000000 401411C8 00141820
rpcrt4!NdrConformantArrayMemorySize
0207FFEC 00000000 77D424C2 00141820 00000000 000000C8 kernel32!lstrcmpiW

*----> Raw Stack Dump <----*
0207fe28 85 22 d4 77 64 01 00 00 - 54 ff 07 02 00 00 00 00
.".wd...T.......
0207fe38 60 44 14 00 58 ff 07 02 - e0 f6 13 00 80 16 14 00
`D..X...........
0207fe48 20 18 14 00 1f 00 00 00 - 50 f7 0a 82 50 f7 0a 82
.......P...P...
0207fe58 00 00 00 00 01 00 00 00 - b4 eb de ba 00 00 00 00
................
0207fe68 b8 04 22 e3 78 eb de ba - 00 00 00 00 72 4f 41 80
..".x.......rOA.
0207fe78 50 f8 0a 82 00 c2 0a 82 - 68 ec de ba ca 08 45 80
P.......h.....E.
0207fe88 04 00 00 00 68 68 6f 81 - 66 41 4a 80 80 f3 12 00
....hho.fAJ.....
0207fe98 00 00 00 00 48 f3 12 00 - 74 2f 0b 00 00 00 00 00
....H...t/......
0207fea8 00 00 00 00 01 00 00 00 - 19 00 02 00 00 00 00 00
................
0207feb8 19 00 02 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0207fec8 ac 03 00 00 00 00 00 00 - 0c ec de ba 00 00 00 00
................
0207fed8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0207fee8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0207fef8 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0207ff08 00 00 00 00 c8 28 50 c0 - a8 00 00 00 00 20 50 c0 .....(P......
P.
0207ff18 19 00 02 00 06 00 02 00 - a8 00 00 00 01 00 00 00
................
0207ff28 00 20 50 c0 00 47 6f 81 - 20 fc 62 81 00 00 00 00 . P..Go.
.b.....
0207ff38 20 fc 62 81 b0 fd 62 81 - 64 ec de ba f3 da 42 80
.b...b.d.....B.
0207ff48 a4 da 42 80 d4 4b 06 80 - 80 fd 62 81 20 fc 62 81 ..B..K....b.
.b.
0207ff58 00 a2 2f 4d ff ff ff ff - 50 fe 07 02 ff ff ff ff
../M....P.......

State Dump for Thread Id 0x628

eax=1b0034a3 ebx=06eaff0c ecx=77fb64f4 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=06eafef0 ebp=06eaff14 iopl=0 nv up ei ng nz ac po
cy
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000297


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:0792d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06EAFF14 77E8B32B 00000190 00000C26 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

State Dump for Thread Id 0x7ac

eax=00000000 ebx=00000000 ecx=00000101 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=06fafef0 ebp=06faff14 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:07a2d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06FAFF14 77E8B32B 00000190 FFFFFFFF 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

State Dump for Thread Id 0x4d0

eax=000000af ebx=00000000 ecx=028b07e0 edx=00000000 esi=77f88e68
edi=00000190
eip=77f88e73 esp=070afef0 ebp=070aff14 iopl=0 nv up ei pl zr na po
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246


function: NtWaitForSingleObject
77f88e68 b8ea000000 mov eax,0xea
77f88e6d 8d542404 lea edx,[esp+0x4]
ss:07b2d4c3=????????
77f88e71 cd2e int 2e
77f88e73 c20c00 ret 0xc
77f88e76 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
070AFF14 77E8B32B 00000190 FFFFFFFF 00000000 1B00997B
ntdll!NtWaitForSingleObject
00000000 00000000 00000000 00000000 00000000 00000000
kernel32!WaitForSingleObject

*----> Raw Stack Dump <----*
070afef0 35 9b ea 77 90 01 00 00 - 00 00 00 00 00 00 00 00
5..w............
070aff00 ff ff ff ff 30 08 8b 02 - 7c ff 0a 07 90 01 00 00
....0...|.......
070aff10 90 01 00 00 00 00 00 00 - 2b b3 e8 77 90 01 00 00
........+..w....
070aff20 ff ff ff ff 00 00 00 00 - 7b 99 00 1b 90 01 00 00
........{.......
070aff30 ff ff ff ff 43 99 00 1b - ff ff ff ff 7c ff 0a 07
....C.......|...
070aff40 ac c3 e9 77 10 ae 8b 02 - 00 00 00 00 d0 fd 11 1b
...w............
070aff50 00 00 00 00 ff ff ff ff - d0 04 00 00 94 35 00 1b
.............5..
070aff60 7c ff 0a 07 ac c3 e9 77 - 30 da 12 00 ec ff 0a 07
|......w0.......
070aff70 d0 fd 11 1b 10 ae 8b 02 - b0 01 00 00 01 00 00 00
................
070aff80 00 00 00 00 00 00 00 00 - a2 0d 43 80 00 00 00 00
..........C.....
070aff90 00 00 00 00 db 0d 43 80 - 00 47 6f 81 a0 cd 67 81
......C..Go...g.
070affa0 ff ff ff ff 01 00 00 00 - 00 00 00 00 00 00 00 00
................
070affb0 00 00 00 00 fd 9b f8 77 - d8 b2 e8 77 d0 fd 11 1b
.......w...w....
070affc0 ac c3 e9 77 30 da 12 00 - d0 fd 11 1b 00 a0 fd 7f
...w0...........
070affd0 f4 64 fb 77 c0 ff 0a 07 - f4 64 fb 77 ff ff ff ff
.d.w.....d.w....
070affe0 6c 13 ed 77 98 2a e8 77 - 00 00 00 00 00 00 00 00
l..w.*.w........
070afff0 00 00 00 00 a3 34 00 1b - d0 fd 11 1b 00 00 00 00
.....4..........
070b0000 00 00 00 00 00 00 ff ff - 00 00 00 00 fc 3e 00 00
.............>..
070b0010 b4 ee 01 30 00 ec 4a 00 - 18 00 00 00 60 aa 14 00
...0..J.....`...
070b0020 04 00 00 00 09 04 00 00 - 04 00 00 00 20 00 00 00 ............
...

State Dump for Thread Id 0x1e8

eax=650210a8 ebx=00000000 ecx=0012d244 edx=00000000 esi=77f882f8
edi=08bcff98
eip=77f88303 esp=08bcff84 ebp=08bcffa0 iopl=0 nv up ei pl nz na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000202


function: NtDelayExecution
77f882f8 b832000000 mov eax,0x32
77f882fd 8d542404 lea edx,[esp+0x4]
ss:0964d557=????????
77f88301 cd2e int 2e
77f88303 c20800 ret 0x8
77f88306 8bff mov edi,edi

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
08BCFFA0 77EA9D5F 000000C8 00000000 650210B3 000000C8 ntdll!NtDelayExecution
08BCFFEC 00000000 650210A8 00000000 00000000 08BD0040 kernel32!Sleep

*----> Raw Stack Dump <----*
08bcff84 94 9d ea 77 00 00 00 00 - 98 ff bc 08 09 04 00 00
...w............
08bcff94 01 00 03 00 80 7b e1 ff - ff ff ff ff ec ff bc 08
.....{..........
08bcffa4 5f 9d ea 77 c8 00 00 00 - 00 00 00 00 b3 10 02 65
_..w...........e
08bcffb4 c8 00 00 00 d8 b2 e8 77 - 00 00 00 00 09 04 00 00
.......w........
08bcffc4 01 00 03 00 00 00 00 00 - 00 90 fd 7f 44 d2 12 00
............D...
08bcffd4 c0 ff bc 08 44 d2 12 00 - ff ff ff ff 6c 13 ed 77
....D.......l..w
08bcffe4 98 2a e8 77 00 00 00 00 - 00 00 00 00 00 00 00 00
.*.w............
08bcfff4 a8 10 02 65 00 00 00 00 - 00 00 00 00 40 00 bd 08
...e........@...
08bd0004 00 00 00 00 00 00 00 00 - 19 00 00 00 02 00 00 00
................
08bd0014 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd0024 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd0034 00 00 00 00 00 00 00 00 - 00 00 00 00 52 0a bd 08
............R...
08bd0044 00 00 bd 08 00 00 00 00 - 1a 00 00 00 19 00 00 00
................
08bd0054 98 00 bd 08 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd0064 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd0074 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd0084 e8 15 00 00 98 00 bd 08 - 01 00 05 00 1a 00 00 00
................
08bd0094 ca 01 00 00 07 00 00 00 - 90 cf 13 00 28 39 1f 00
............(9..
08bd00a4 80 00 bd 08 00 00 00 00 - 00 00 00 00 00 00 00 00
................
08bd00b4 00 00 00 00 00 00 00 00 - 60 00 16 00 01 00 00 00
........`.......
 
T

Tony Toews

June Macleod said:
I think I may have found the problem myself. With all my chopping and
changing I had my Listbox Multiselect Property set to None. As soon as I
changed it to Extended the error went away.

June (feeling a total fool <g>)

No reason why you should feel like a "total fool". I know I've done
worse things. But Access certainly shouldn't have puked and died like
it did too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top