Search results for query: *

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

When using DAO to cycle through recordsets in this manner, the process will be much slower than necessary, as you notice. The most efficient way to perform this kind of update is with an append query which joins the two tables together and only copies the unique records. This will run much...

You should use the DSUM function. Review this hyperlink for help on how to use the function: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/html/output/F1/D2/S5A0DF.asp Let me know if you have any more questions or run into trouble.

It's possible the query is having a data type issue since the first query does not have a single value for the each record in those fields. Union queries will use the data types from the first SELECT statement as its data types. [hourglass] Would it be possible for you to change the NULLs to...

Try this in the box: SUM(CountOfAgent) since CountOfAgent is name of the Count field. ;-) Sorry I didn't reply sooner... I've been in lala-land... it's beautiful this time of year.

Yes... You will want to add this to the WHERE clause of the query... ([YourLineNumberField]/3 = Int(YourLineNumberField/3)) This will only choose rows that are evenly divisable by 3. If you want to include row one as well. Just add another item that says: Or ([YourLineNumberField] = 1)...