Combo Box Usage Shuts Down Application

[Henry Stockbridge]

Hi,

I have a combo box on a form whose purpose is to add a record to the
form's underlying table. There are several (16) fields that the combo
box carries with it, only a few that are visible to the User. When the
User selects a value from the combo box, the application shuts down.
Here is the code for the combo box that may lead to the problem.
=============== =============== =============== =
Private Sub cboAddPhysician _AfterUpdate()
On Error GoTo PROC_ERR
Dim DB As Database

Dim rst1 As Recordset
Dim rst2 As Recordset

Set DB = CurrentDb
Set rst1 = DB.OpenRecordse t("tblProduct_P roctoree_DFU",
dbOpenDynaset)
Set rst2 = DB.OpenRecordse t("tblProduct_P roctoree_Device Training",
dbOpenDynaset)
rst1.AddNew
rst1!LinkID = Me.cboAddPhysic ian.Column(0)
rst1!ProctoreeF ull_LF = Me.cboAddPhysic ian.Column(1)
rst1!PrimaryIns titution = Me.cboAddPhysic ian.Column(2)
rst1!PrimInstID = Me.cboAddPhysic ian.Column(3)
rst1!ProctoreeF ull_FL = Me.cboAddPhysic ian.Column(4)
rst1!PrimaryIns tAddress = Me.cboAddPhysic ian.Column(5)
rst1!PrimaryIns tCity = Me.cboAddPhysic ian.Column(6)
rst1!PrimaryIns tState = Me.cboAddPhysic ian.Column(7)
rst1!PrimaryIns tZip = Me.cboAddPhysic ian.Column(8)
rst1!ProctoreeL ast = Me.cboAddPhysic ian.Column(9)
rst1!ProctoreeF irst = Me.cboAddPhysic ian.Column(10)
rst1!ProctoreeM I = Me.cboAddPhysic ian.Column(11)
rst1!ProctoreeS uffix = Me.cboAddPhysic ian.Column(12)
rst1!ProctoreeL ongDegree = Me.cboAddPhysic ian.Column(13)
rst1!ProctoreeD FUSpecialtyID = Me.cboAddPhysic ian.Column(14)
rst1!ProctoreeD FUSpecialty = Me.cboAddPhysic ian.Column(15)
rst1!Created = Now()

rst1.Update

rst2.AddNew
rst2!LinkID = Me.cboAddPhysic ian.Column(0)
rst2!PrimaryIns titution = Me.cboAddPhysic ian.Column(2)
rst2!PrimInstID = Me.cboAddPhysic ian.Column(3)
rst2!ProctoreeF ull_FL = Me.cboAddPhysic ian.Column(4)
rst2!ProctoreeL ast = Me.cboAddPhysic ian.Column(9)
rst2!ProctoreeF irst = Me.cboAddPhysic ian.Column(10)
rst2!ProctoreeM I = Me.cboAddPhysic ian.Column(11)
rst2!ProctoreeS uffix = Me.cboAddPhysic ian.Column(12)
rst2!ProctoreeL ongDegree = Me.cboAddPhysic ian.Column(13)
rst2!TrainingCo mpletion_HospNa me = Me.cboAddPhysic ian.Column(2)
rst2!TrainingCo mpletion_HospID = Me.cboAddPhysic ian.Column(3)
rst2!Created = Now()

rst2.Update

Me.Filter = "LinkID= " & Me!cboAddPhysic ian.Column(0)
Me.FilterOn = True
Me.Requery
Me!cboAddPhysic ian.Value = ""
Me.Refresh
Me.cboFindMD.Vi sible = True
Me.cboAddPhysic ian.Visible = False
Set rst1 = Nothing
Set rst2 = Nothing
Set DB = Nothing

Exit Sub

PROC_ERR:
MsgBox "The following error occured: " & Error$
Resume Next
End Sub
=============== =============== =============== ========
Private Sub cboAddPhysician _Exit(Cancel As Integer)
On Error GoTo PROC_ERR
Dim DB As Database
'Dim dbs As DAO.Database
Dim sSql As String

Set DB = CurrentDb()

' 1) Delete and append records
sSql = "DROP TABLE tblDFU_Hospital s_Product"
DB.Execute sSql
sSql = "SELECT qryDFU_Hospital s_Product.PrimI nstID INTO
tblDFU_Hospital s_Product FROM qryDFU_Hospital s_Product;"
DB.Execute sSql

Set DB = Nothing
Exit Sub

PROC_ERR:
MsgBox "The following error occured: " & Error$
Resume Next
End Sub
=============== =============== =============== =======

Any help you can lend to help with my troubleshooting would be
appreciated.

Henry

[deluxeinformation]

Henry Stockbridge wrote:

Hi,

I have a combo box on a form whose purpose is to add a record to the
form's underlying table. There are several (16) fields that the combo
box carries with it, only a few that are visible to the User. When the
User selects a value from the combo box, the application shuts down.
Here is the code for the combo box that may lead to the problem.

Set a breakpoint at the first executable statement in your combo box
afterupdate event and then step through one line at a time until your
app crashes. This should give you some more information to go on (and
us too if you should require further assistance).

HTH,
Bruce

[Henry Stockbridge]

de************* **@gmail.com wrote:

Henry Stockbridge wrote:

Hi,

I have a combo box on a form whose purpose is to add a record to the
form's underlying table. There are several (16) fields that the combo
box carries with it, only a few that are visible to the User. When the
User selects a value from the combo box, the application shuts down.
Here is the code for the combo box that may lead to the problem.

Set a breakpoint at the first executable statement in your combo box
afterupdate event and then step through one line at a time until your
app crashes. This should give you some more information to go on (and
us too if you should require further assistance).

HTH,
Bruce

Thanks for your answer. I neglected to say that the code
runs error free on my computer and one other workstation.
The procedure fails on all other computers. I am not that
adept at performance related issues, so could this be a
system (OS or MS Access) issue?

Nonetheless, I took the code and tested three iterations of
the procedure:
1 All code running in the After Update procedure (moved
the OnExit code to AfterUpdate)
2 RST1 procedure only
3 RST1 & RST2 procedures only

All work fine on my computer, the other workstation, and
crashes on all others. Any other ideas I should investigate
and test.

Thanks again,

Henry

[Bob Quintal]

"Henry Stockbridge" <hs***********@ hotmail.comwrot e in
news:11******** **************@ h48g2000cwc.goo glegroups.com:

>
de************* **@gmail.com wrote:

>Henry Stockbridge wrote:

Hi,

I have a combo box on a form whose purpose is to add a
record to the form's underlying table. There are several
(16) fields that the combo box carries with it, only a few
that are visible to the User. When the User selects a
value from the combo box, the application shuts down.
Here is the code for the combo box that may lead to the
problem.

Set a breakpoint at the first executable statement in your
combo box afterupdate event and then step through one line at
a time until your app crashes. This should give you some
more information to go on (and us too if you should require
further assistance).

HTH,
Bruce

Thanks for your answer. I neglected to say that the code
runs error free on my computer and one other workstation.
The procedure fails on all other computers. I am not that
adept at performance related issues, so could this be a
system (OS or MS Access) issue?

Nonetheless, I took the code and tested three iterations of
the procedure:
1 All code running in the After Update procedure (moved
the OnExit code to AfterUpdate)
2 RST1 procedure only
3 RST1 & RST2 procedures only

All work fine on my computer, the other workstation, and
crashes on all others. Any other ideas I should investigate
and test.

Thanks again,

Henry

Go to one of the crashing computers.
Modify your procedure by adding the word stop in the location
shown

Private Sub cboAddPhysician _AfterUpdate()
stop 'add this command here, for testing.
'remove after the problem has been fixed

On Error GoTo PROC_ERR
Dim DB As Database

Run your process. when the event fires the program will stop and
display the code editor. Press the F8 key to execute one
statement at a time. the line to be next executed will be
highlighted (yellow on most computers). Press F8 and note which
line is highlited. Continue until the problem occurs. You will
have found the problem. Once we know what the problem is, we can
try to fix it..
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[deluxeinformation]

Greetings Henry,

Thanks for your answer. I neglected to say that the code
runs error free on my computer and one other workstation.
The procedure fails on all other computers. I am not that
adept at performance related issues, so could this be a
system (OS or MS Access) issue?

Nonetheless, I took the code and tested three iterations of
the procedure:
1 All code running in the After Update procedure (moved
the OnExit code to AfterUpdate)
2 RST1 procedure only
3 RST1 & RST2 procedures only

All work fine on my computer, the other workstation, and
crashes on all others. Any other ideas I should investigate
and test.

The next things I would try are copying the working file from a machine
where the code executes correctly to one that doesn't, i.e., make sure
you are using identical versions of your program. Next make sure that
all machines are up to date with respect to service packs for
Office/Access (go to officeupdate.mi crosoft.com and click the 'check
for updates' link). Finally make sure that Windows on each machine is
also updated with the current service release. Although it is remotely
possible that you have some kind of hardware problem (i.e. bad RAM) it
is far far more likely to be a software issue.

Bruce

[Henry Stockbridge]

de************* **@gmail.com wrote:

Greetings Henry,

Thanks for your answer. I neglected to say that the code
runs error free on my computer and one other workstation.
The procedure fails on all other computers. I am not that
adept at performance related issues, so could this be a
system (OS or MS Access) issue?

Nonetheless, I took the code and tested three iterations of
the procedure:
1 All code running in the After Update procedure (moved
the OnExit code to AfterUpdate)
2 RST1 procedure only
3 RST1 & RST2 procedures only

All work fine on my computer, the other workstation, and
crashes on all others. Any other ideas I should investigate
and test.

The next things I would try are copying the working file from a machine
where the code executes correctly to one that doesn't, i.e., make sure
you are using identical versions of your program. Next make sure that
all machines are up to date with respect to service packs for
Office/Access (go to officeupdate.mi crosoft.com and click the 'check
for updates' link). Finally make sure that Windows on each machine is
also updated with the current service release. Although it is remotely
possible that you have some kind of hardware problem (i.e. bad RAM) it
is far far more likely to be a software issue.

Bruce

Hi,

First, thanks for all your comments. They have been extremely helpful.
Well, I looked at the computers where the application crashed and
compared them to the working application computers, and alas, the
Access versions are different! The application does not crash on
Access version (11.6566.8036 - SP2), but it does crash on version
(11.5614.8036.) I will work on getting the latest service packs
installed, and see what happens.

Henry