Recent content by nabiS2K

You need the VB Power Pack: (It's Free from a MS partner) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/vbpowerpack.asp

I have this thread in the SQL Servers forum, but it may be better suited for you OS gurus... thread183-915963 Basically, I have noticed that Windows XP Home does not seem to detect SQL Servers in the ODBC Connection Wizard, using SQLDMO, or NetApi32. Does anyone know if automatically...

I have referenced the following MSDN article on how to determine the version of the Windows OS: http://support.microsoft.com/default.aspx?scid=kb;EN-US;304289 Does anyone know how to take this one step farther to determine specifically which edition of XP is running, Home or Professional? Any...

I am using SQLDMO. Not NetApi or searching for the specific TCP/IP port, since as you mentioned Firewalls block it.

Thanks for the replies... [thumbsup] I am aware that Windows XP Home is not intended for a domain-oriented network, but I have not found any Microsoft (or third-party for that matter) documentation to suggest that MSDE or SQL Server 2000 should have a problem detecting servers in XP Home...

I have a Windows XP Home computer that cannot "see" network or even local instances of SQL Server 2000 or MSDE 2000. I have this problem with and without SP1 and SP2. However, it did not bother me until an app I wrote was unable to find the server(s) when a client used it on his XP Home laptop...

A pass-through query is an entirely SQL driven query (no pretty UI) that skips Access's internal query syntax checking and sends the SQL statement directly to the datasource, in this case SQL Server. As a result, the query returns records as fast as possible.

Go back to where you added a Group Header and also add a Group Footer. This will sum each group separately.

Yes I do know why... In the first select statement, you have two separate parameters in the WHERE statements: WHERE(((ExpiredMembers.DateUpdated)>=[Retrieve deleted members since what date?]... and in the second you have WHERE (((Members.DateJoined)>=[Retrieve new members since what date?]. To...

You are looking for the ListView control. It is part of the MS Common Controls dll.

There is one additional thing about Access. Since Access is not a client-server application, Access can unnecessarily overwork your network. With Access databases on a LAN, queries are noticeably slower for larger databases than for those on the local machine. For interest sake, MSDE is the...

It will be far faster for you to use temporary queries than to use the Find method. I would strongly recommend using queries. This is faster on Access tables as well.

Here you go: http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

You will need an append query for each of the different relational tables. You will also have to run them in order where you populate foreign key tables prior to detail tables.

Did you try Count(Leads.Agent) as Leslie suggested? This should work...