Search results for query: *

I am trying to convert the following query from using a subquery in the SELECT statement to using JOINS instead. I have been working on this a while now without much success. Select a.CustID, a.CustOrdType, a.OrdDate, (SELECT TOP 1 b.OrdDate FROM OrderTable b WHERE b.CustID = a.CustID AND...

Hello, I am running across performance problems with queries that reference tables in separate SQL databases. I am using SQL7 with five databases on a single machine. The databases merge with other external databases from time to time, and the table structures are identical in each database...

Hello, I am running across performance problems with queries that reference tables in separate SQL databases. I am using SQL7 with five databases on a single machine. The databases merge with other external databases from time to time, and the table structures are identical in each database...

I am trying to implement the Find method against and ado data control using multiple criteria and it doesn't seem to work. Here is what the code looks like frmEditRuns.Adodc1.Recordset.Find ("RunNumber = " & varRun & " AND StationNumber = " & varLine) This code works fine...

Tek-tips and its members are by far the most useful resource I have found on the Web. Two thumbs up! You guys have saved me more time and frustration than I can quantify. Thanks for your generosity [2thumbsup]

I have created an application that references an Active X exe at different times. Over the development process, I have installed and uninstalled and moved the programs around quite a bit on the PC (win2k server). Now, when I reference the Active X exe, I get a "program not found...

I have an Active X executable running on Windows 2000. The executable is accessed from different programs on the PC. When I set the PC up, I was logged in as Administrator and everything worked fine. Now I am logging in with a different logon (with Administrator Privileges) and I keep getting...

I have an Active X executable running on Windows 2000. The executable is accessed from different programs on the PC. When I set the PC up, I was logged in as Administrator and everything worked fine. Now I am logging in with a different logon (with Administrator Privileges) and I keep getting...

Does anyonw know the way to get an XP Pro Laptop to work on two networks without using a domain server and roaming profiles? I have a laptop that gets moved between two different offices. Can the network settings be pre-set somehow so that the user doesn't have to change network settings...

This may be a simple question, but I cannot find a straightforward solution. I am using text boxes in VB6 that are bound to an ADO Data Control. I cannot programatically change the value in the text box and have the bound element update the database without setting the focus to the text box...

I am trying to duplicate the process of double-clicking on a file in the Explorer window from within Access. For example, double-clicking a file called document.pdf will automatically open the Adobe reader and load the document. I have tried to use the Shell command to accomplish this, but it...

I have a Windows 2000 PDC that I am trying to install Routing and Remote Access on. I go throught the wizard for setting up a VPN Server, and the whole server suddenly shuts intself off of the network. I have two NICs in the server and a Cisco 2600. The configuration is kind of strange for the...