[AccessD] OT SQL Server

Martin Reid mwp.reid at qub.ac.uk
Tue Jun 17 12:50:40 CDT 2003


MessageI 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. 

ANyone here have any ideas?

Martin


  ----- Original Message ----- 
  From: Mike and Doris Manning 
  To: accessd 
  Sent: Tuesday, June 17, 2003 5:48 PM
  Subject: RE: [AccessD] List box misbehaving


  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.

  Doris Manning
  Database Administrator
  Hargrove Inc.
  www.hargroveinc.com
    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Don Elliker
    Sent: Tuesday, June 17, 2003 12:16 PM
    To: accessd at databaseadvisors.com
    Subject: [AccessD] List box misbehaving


    Hi folks,

    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. 

    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......???
    Thanks,

    _D





    "Things are only free to the extent that you don't pay for them".-Don Elliker 


----------------------------------------------------------------------------
    STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030617/180eab13/attachment-0001.html>


More information about the AccessD mailing list