<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am working with SQL Server 2000 on my pc at home.
Linking to a WIndows SharePoint Server in the USA. The WSS server cannot see the
SQL Server and I have been told to make SQL Server "outward facing" I have not a
clue what that means. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ANyone here have any ideas?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Martin</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=mikedorism@ntelos.net href="mailto:mikedorism@ntelos.net">Mike and
Doris Manning</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 17, 2003 5:48
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] List box
misbehaving</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=514554116-17062003><FONT face=Arial color=#0000ff size=2>As
you have quickly learned, listboxes don't always like being overlayed...
either move it to somewhere else or make it invisible in the section
of code that makes the subform become visible.</FONT></SPAN></DIV>
<DIV><SPAN class=514554116-17062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=514554116-17062003><FONT face=Arial color=#0000ff size=2>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.hargroveinc.com">www.hargroveinc.com</A></FONT></DIV></FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Don
Elliker<BR><B>Sent:</B> Tuesday, June 17, 2003 12:16 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] List box
misbehaving<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Hi folks,</P>
<P>I have an XP app that is giving me the business. Bound form with a
tabcontrol for various memo fields. A list box with a separate data source
(query of another table related to bound form recordsource) An
invisible subform which is the same data as the mainform but in a more
'Excel-like' display. When they request to see the data as presented by the
invisible form I make it visible (Ta Dah!) It overlays some of the controls
and the listbox is one of them. The listbox refuses to be overlayed...it
floats on top of the subform. I have played with everything I can think of -
including deleting the control and compacting and repairing, then
re-creating the control. It still floats on top (super-annoying) -I checked
for requeries of the listbox. I checked taborders and remnant code,
there are no repaints or restore commands. </P>
<P>Interestingly, I cannot get the listbox to 'move to back' nicely...it
flickers but stays on top of the Box it sits on - none of the other controls
act this way. Also, if I maximize the form...it doesn't misbehave...but
that, of course, is NOT the solution......???<BR>Thanks,</P>
<P>_D<BR></P></DIV><BR><BR><BR>"Things are only free to the extent that you
don't pay for them".-Don Elliker
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></DIV><BR clear=all>
<HR>
STOP MORE SPAM with <A href="http://g.msn.com/8HMYENUS/2728??PS=">the new
MSN 8</A> and get 2 months FREE* </BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>