[AccessD] Very Strange Problem with Access

Hi Rocky

Very clever!

If you can't move the mountain, go to the mountain.
Or here:
If you can't move the mountain away, leave the mountain.

/gustav


> You know Gustav, that might be the problem.  The user was talking about MDAC
> versions but I don't think that they can modify the user's machine in any
> event.  It's a military installation.

> But I disabled the problem.  I tracked it down to any use of that combo box.
> If the combo box wasn't accessed while the form was open, the form closed
> correctly.  So right before the DoCmd.Close I had the user insert
> cboBuilding.RowSource = "" and the problem went away.

> I'll forward your idea to the user, though.

> Thanks again.

> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com


> ----- Original Message ----- 
> From: "Gustav Brock" <gustav at cactus.dk>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Friday, September 24, 2004 9:28 AM
> Subject: Re: [AccessD] Very Strange Problem with Access


>> Hi Rocky
>>
>> Check - or just go ahead and update/reinstall - the MDAC.
>>
>> /gustav
>>
>>
>> > It runs fine on every box its ever been on.  But on this one box, when
>> > the user exits from frmRoom and the Main Menu is displayed, they get an
>> > "Enter Parameter" box prompting for
>> > Forms!frmRoom!txtClusterID as if the combo box is being requeried.  But
>> > at this point the form frmRoom is closed. I've stepped through the code and
>> > the parameter prompt appears AFTER the .Close.
>>
>> > qryBuildingByCluster is only used in one place in the system - as the
>> > row source of the Building combo box in frmRoom.  We checked references and
>> > they're identical to the client's laptop on which
>> > the program runs fine - can't duplicate the error.