[AccessD] Unknown Jet Error

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Jul 27 12:01:46 CDT 2010


The only message I get is "Unknown Jet Error"
When stepping through the code the message appears after completing the line
DoCmd.Maximize. 
I.e. Next line is highlighted.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, July 27, 2010 11:48 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Unknown Jet Error

What error and which line?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, July 27, 2010 9:17 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Unknown Jet Error

Why does this code cause an error? Compact and repair is of no use.

Private Sub Form_Open(Cancel As Integer)
    Stop
    DoCmd.OpenForm "frm Plant Pressures Scatter"
    DoCmd.Maximize
    Me!chtPlantChart.SetFocus
    Dim frm As Form, ctl As Control
    Dim varItm As Variant, intCnt As Integer
    Dim MaxY1 As Single, MaxY2 As Single, MajorUnitY1 As Single 
    Dim MinorUnitY1 As Single, MajorUnitY2 As Single, MinorUnitY2 As Single
    DoCmd.SetWarnings Off
End Sub. 

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list