PC Review


Reply
Thread Tools Rate Thread

Outlook Crashes: MS09.DLL

 
 
=?Utf-8?B?ZmVsdG9u?=
Guest
Posts: n/a
 
      25th May 2005
I have the following code, originally from Helen Fedema, to populate a combo
box on an Outlook form using data from an Access database.

It works to a point where it displays the data I want, but when I make a
selection from the list it displays, Outlook crashes with an exception fault
in MS09.DLL

Dim rst
Dim dao
Dim wks
Dim db
Dim nms
Dim fld
Dim itms
Dim itm
Dim strAccessDir
Dim objAccess
Dim StaffArray(200, 7)

Function Item_Open()
FillComboBox()
End Function

Function FillComboBox()
Set objAccess = Item.Application.CreateObject("Access.Application")
strDBName = "C:\ABCPartners\ABC_DATA_2K.MDB"
objAccess.Quit

Set dao = Application.CreateObject("DAO.DBEngine.36")
Set wks = dao.Workspaces(0)
Set db = wks.OpenDatabase(strDBName)

Set rst = db.OpenRecordset("tblStaff")
Set ctl =
Item.GetInspector.ModifiedFormPages("TimeTrak").Controls("cboStaffName")
ctl.ColumnCount = 7
ctl.ColumnWidths = "0; 0 pt; 0 pt; 0 pt; 200 pt; 0 pt; 50 pt"
StaffArray(200, 7) = rst.GetRows(100)
ctl.Column() = StaffArray(200, 7)
End Function

Sub cmdFillComboBox_Click
FillComboBox()
End Sub


I would like to be able to select data from the combo and have it display in
the field. I also need to use data from other columns in the combo to display
as read only on the form.

As an aside, after these two problems are solved, I need to post/export the
data back to Access: the first problems are in the preceding paragraph.

Any ideas would be appreciated, with thanks

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2003 Crashes, and crashes, and crashes... rtart Microsoft Outlook Discussion 1 21st Aug 2008 09:35 PM
outlook 2007 crashes on startup and wants to restart but crashes a James Microsoft Outlook Discussion 1 7th Feb 2008 04:24 PM
Outlook caused an invalid page fault in module MS09.DLL at 016f:30 =?Utf-8?B?VE1oYXJkMjIxNzA=?= Microsoft Outlook Discussion 1 20th Nov 2004 06:33 AM
MS09.dll Jason Microsoft Excel Crashes 0 3rd Aug 2004 08:56 PM
Mssg: Outlook unable to locate MS09.DLL D Laudermilch Microsoft Outlook 4 31st Jan 2004 07:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:22 AM.