<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns:st2="urn:schemas:contacts" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Message</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas:contacts" name="Sn"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="time"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="stocktickeruk"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="stocktickerca"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="phone"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="date"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }st2\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-footer-margin:.5in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I asked a similar question last year.
Here is my question and the response I got:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>My Question:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I recently ran into a situation where an Access 2002
database FE was converted back to an Access 2000 version. This was originally
done in Access 97 and converted to Access 2000 and Access 2002, but as we keep
hearing that Access 97 is being phased out they decided to go with just an
Access 2000 version and an Access 2002 version. <span DEFANGED_STYLE="mso-spacerun:yes"> </span>They
decided to continue development using Access 2002 and convert down to Access
2000. The downgrade is successful (everything works as expected) but I have
now noticed something really strange. I can view the tables, queries, forms,
etc as Large Icons, Small Icons, and as a List, but I cannot see ANYTHING when
I try and view as Detail.<span DEFANGED_STYLE="mso-spacerun:yes"> </span>Has
anyone else experienced this?<span DEFANGED_STYLE="mso-spacerun:yes"> </span>Or
am I just ‘lucky’?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Response from Mark Plumpton</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>That happened to me once - all the column
widths in the details view were set to zero. Just try opening the columns
up from the left hand side.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Jeff <st2:Sn w:st="on">Barrows</st2:Sn><o:p></o:p></span></font></p>
<p class=MsoAutoSig><b><font size=5 color=navy face="Times New Roman"><span
style='font-size:16.0pt;color:navy;font-weight:bold'>Outbak Technologies, LLC<o:p></o:p></span></font></b></p>
<p class=MsoAutoSig><st1:place w:st="on"><st1:City w:st="on"><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Racine</span></font></st1:City><font
color=navy><span style='color:navy'>, <st1:State w:st="on">WI</st1:State></span></font></st1:place><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Phone: <st1:phone phonenumber="2626340653"
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
w:st="on">(262) 634-0653</st1:phone><o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Mailto: jeff_developer@hotmail.com<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'><a href="http://www.outbaktech.com">www.outbaktech.com</a></span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> John Ruff
[mailto:papparuff@attbi.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> <st1:date Year="21" Day="21"
Month="5" ls="trans" w:st="on">Wednesday, <st1:date Year="21" Day="21" Month="5"
ls="trans" w:st="on">May 21, 2003</st1:date></st1:date><st1:time Minute="50"
Hour="12" w:st="on"> 12:50 PM</st1:time><br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>On another newgroup one person asked the
following:</span></font><o:p></o:p></p>
</div>
<div>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>"When I am working on a form and then close it, the Form
list is blank. If I click Reports, Tables, etc.. and click back, the Forms are
once again listed. The same happens with Reports and Tables, etc.. It does not
happen every time, but very often. It is mostly annoying. And it happens in
multiple databases not just one. I have Office SR-3 loaded.</span></font><o:p></o:p></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>Has anyone every come accross this before? How do I stop
it."</span></font><o:p></o:p></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>A number of peopele responded stating they have the same
problem but don't know why it happens. I also have the same
problem. When I have created a number of tables, forms, reports, etc in
the database; if I go from say, form design view, back to the Access main
window, I have to move to another object and then back to the forms object
again to see all the forms that I have already created.. I have never
found an answer for this, so I just live with it. I don't believe memory
has anything to do with it as I have 512mb and it happens if I only have Access
open or if I have a couple of other programs running. It happens with
Access 2000 and Access 2002 and in Windows 2000 Pro and Windows XP Pro.</span></font><o:p></o:p></p>
<p><font size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:blue'>Does anyone else have this annoyance? If so, does
anyone know why this occurs, and a solution (if there is any).</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<p><b><i><font size=4 color=blue face="Times New Roman"><span style='font-size:
13.5pt;color:blue;font-weight:bold;font-style:italic'><!-- Converted from text/rtf format -->John
V. Ruff</span></font></i></b><b><i><font size=4><span style='font-size:13.5pt;
font-weight:bold;font-style:italic'> – <font color=teal><span
style='color:teal'>The Eternal Optimist</span></font></span></font> </i></b><b><i><font
size=4 color=purple face=Wingdings><span style='font-size:13.5pt;font-family:
Wingdings;color:purple;font-weight:bold;font-style:italic'>J</span></font></i></b>
<br>
<i><span style='font-style:italic'>Always Looking For Contract Opportunities</span></i>
<o:p></o:p></p>
<p><font size=2 face="Times New Roman"><span style='font-size:10.0pt'>Home:
253.588.2139</span></font> <br>
<font size=2><span style='font-size:10.0pt'>Cell: <st1:address w:st="on"><st1:Street
w:st="on">253.307/2947<font size=3><span style='font-size:12.0pt'> <br>
</span></font>9306 Farwest Dr</st1:Street> <st1:City w:st="on">SW<font
size=3><span style='font-size:12.0pt'> <br>
</span></font>Lakewood</st1:City>, <st1:State w:st="on">WA</st1:State> <st1:PostalCode
w:st="on">98498</st1:PostalCode></st1:address></span></font> <o:p></o:p></p>
<p><b><font size=2 color=navy face="Times New Roman"><span style='font-size:
10.0pt;color:navy;font-weight:bold'>“Commit to the Lord whatever you do,</span></font></b>
<br>
<b><span style='font-weight:bold'> </span></b><b><font
size=2 color=navy><span style='font-size:10.0pt;color:navy;font-weight:bold'>and
your plans will succeed.” Proverbs 16:3</span></font></b> <o:p></o:p></p>
<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-bounces@databaseadvisors.com [mailto:accessd-bounces@databaseadvisors.com]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Don Elliker<br>
<b><span style='font-weight:bold'>Sent:</span></b> <st1:date Year="21" Day="21"
Month="5" ls="trans" w:st="on">Wednesday, <st1:date Year="21" Day="21" Month="5"
ls="trans" w:st="on">May 21, 2003</st1:date></st1:date><st1:time Minute="24"
Hour="10" w:st="on"> 10:24 AM</st1:time><br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Sorting an
array from a calback function</span></font><o:p></o:p></p>
<div>
<div>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Neil,<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Thanks, I
modified one of the routines and it works splendidly.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>I put
this in the LbInitialize of the callback<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Set rst =
dbCur.OpenRecordset("qryreportname", dbOpenSnapshot)<br>
Set Cnt = dbCur.Containers("reports")<br>
<br>
rst.MoveLast<br>
rst.MoveFirst<br>
intCount = rst.RecordCount - 1<br>
intRows = intCount<br>
intCols = 2<br>
<br>
ReDim arRptName(intC! ount, 2)<br>
<br>
If rst.RecordCount > 0 Then<br>
For intI = 0 To intCount<br>
arRptName(intI, 0) = rst!Name<br>
arRptName(intI, 1) = Cnt(rst!Name).Properties("description")<br>
'Debug.Print arRptName(intI, 0); " "; arRptName(intI, 1)<br>
&nbs!
p;
rst.MoveNext<br>
Next intI<br>
End If<br>
"YOUR STUFF
HERE- <br>
Dim i As Integer, J As Integer, Low As Integer, Hi As Integer, Temp1 As String,
Temp2 As String<br>
Low = LBound(arRptName) + 1<br>
Hi = UBound(arRptName)<br>
For i = ! Low To Hi - 1<br>
For J = i + 1 To Hi<br>
If arRptName(i, 1) > arRptName(J, 1) Then<br>
Temp1 = arRptName(i, 0)<br>
Temp2 = arRptName(i, 1)<br>
arRptName(i, 0) = arRptName(J, 0)<br>
&!
nbsp;
arRptName(i, 1) = arRptName(J, 1)<br>
arRptName(J, 0) = Temp1<br>
arRptName(J, 1) = Temp2<br>
End If<br>
Next J<br>
Next i<o:p></o:p></span></font></p>
<p style='margin-bottom:12.0pt'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> <br>
varRetVal = intRows<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br>
<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><em><i><font size=2 color="#6666ff" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#6666FF'>"Things are only
free to the extent that you don't pay for them." </span></font></i></em><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br clear=all>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Help STOP SPAM with <a href="http://g.msn.com/8HMEENUS/2731??PS=">the
new MSN 8 </a>and get 2 months <st1:stocktickeruk w:st="on"><st1:stocktickerca
w:st="on">FREE</st1:stocktickerca></st1:stocktickeruk>* <o:p></o:p></span></font></p>
</blockquote>
</div>
</body>
</html>