MartyConnelly
martyconnelly at shaw.ca
Tue Jun 17 21:21:46 CDT 2003
I think you may have to open one of the ports 1433, 1434 or 1435 to allow internet access to SQL server depending on your config and authorization.. Make sure you have SQL SP3 (slammer) patch installed. Martin Reid wrote: > 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. > > ANyone here have any ideas? > > Martin > > > > ----- Original Message ----- > From: Mike and Doris Manning <mailto:mikedorism at ntelos.net> > To: accessd <mailto:accessd at databaseadvisors.com> > 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 <http://www.hargroveinc.com> > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > <mailto: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 > <http://g.msn.com/8HMYENUS/2728??PS=> and get 2 months FREE* > > ------------------------------------------------------------------------ > _______________________________________________ > 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 > >