Search results for query: *

I need to add a column of values to one table (TableA) in the right order. The new column on TableA is 1ColX and is empty. Another table (TableB) has the values for 1ColX in 2Colx, and both tables have a column called CustKey. Each record inserted into 1ColX should then have the same CustKey as...

Hi all, I started working at a new company and have discovered the pervasive usage of "Select 1 from.." in their stored procedures. Why? It just returns 1. Here's one use: ============================================== if exists (select 1 from dbo.sysobjects a join sysindexes b ON a.id =...

Merry Christmas and Happy New Year! If I want a message to pop up during an install made with the PDW (I want a popup that says something like "Be sure to read the ReadMe file for further setup instructions, you doofus" that they can click OK to unload, is this possible? Thanks...

Hi folks, in some of mt VB apps it is necessary for the user to go into the control panel, ODBC settings, and then choose the default driver (Microsoft dBase driver) then type in the System DSN (Goldmine) prior to using the product. Although this isn't THAT big a deal, I'd rather have the...

Hi all, I got a new dev computer so I had to re-install Visual Studio (6) on it, then since I want to package an app for distribution, I went to the Add-in Manager to add the Package/Deploy wizard, and much to my display is isn't there! What am I missing or forgetting please?? Thanks --Bill...

I'm accessing a .dbf database over the network and using ADO to do so. The ADO application works fine. Now when I open the database using Terminal Server, then try to run the app, I get this error: 80004005 [ODBC driver manager] data source name not found and no defauld driver specified. I tried...

Folks, This topic always generates lively responses, every time it comes up which is often. I believe the experts here, because they are experts. But I wonder this: there are machine-specific licensing apps that seem to pull some kind of number out of a machine when you install it, then you...

Why would the ErrrorHandler get ignored, and raise a 'Run-time error' instead? The code: ======================================== Private Sub cmdDDE_Click() On Error GoTo ErrorHandler 'other stuff here ErrorHandler: Select Case Err.Number Case 282 ' "Can't find dde conn&quot...

With this code: ==================================== ErrorHandler: Select Case Err.Number Case 9 ' "subscript out of range" error. Exit Sub Case Else Resume Next End Select Resume ==================================== both the 'Resume next' and...

Hi all. I'm new to this ACT forum, so please 'scuse me if this is an "old" topic. Essentially, what I need to know is where I will find VB/Act api's. Put another way, I have developed some VB apps that interact with the GoldMine CRM as add-ons, (they communicate with Goldmine thru ADO...

Hi all. What's your favorite DSN-less ADO connectionstring to SQL Server 7.0? Thanks! (VB 6.0) --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

For the installation to the server I'll use the PDW to package all of the files associated with my program. But for the app to be run from a workstation (over the network), the workstation only will need the .ocx's and the MDAC installed. So I want to distribute a disk with an installer for just...

I've seen programs that, when they run, aren't visible except that an icon appears in the system tray, then disappears when the program quits. Anybody know how this little trick is accomplished? Thanks. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Is it possible to write a query that will pull one random record each time from a table? Here's an example of what I mean: Customers send us thank you's in appreciation for our product. We put the text of these thank you's into a table called "tblThanks" The record id is a guid...

The Package and Deploy Wizard creates 1. Support, 2.Cab, 3.Setup.exe, 4.Setup.lst. I want to zip the installer for people to download as a self-extracting installer. Do I need to include the Support folder, or can I leave it out? Thanks... --Bill One may not reach the dawn save by the path of...

Hi all, this is my first question to this particular forum so pardon me if I'm asking a question that has been asked many times b4. Is there a list of ACT api's out there somewhere (for use with VB 6.0)? Or are they even needed? I'm developing an app which ultimately will write data into the act...

OK folks, I've fallen in love -- with a code forum! Doh! One year ago, almost to the day, I was forced to start seriously learning VB (or starve to death in an unemployment line!) and over a year, I have learned so much from you pros at tek tips, that now I'm becoming one. Becoming -- not...

Some of you might recall this query from a previous thread of mine: ----------------------------------- cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\common\;" & _ "Extended Properties=dBASE IV;" & _ "User...

This works: SELECT accountno FROM tblTable WHERE Key5 = '' (Key5 is indexed) This fails: SELECT accountno FROM tblTable WHERE Secr = '' (Secr is NOT indexed) Anybody ever seen this b4? Thanks! --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

I created an app that picks up names from a table and displays them in a combobox BUT WAIT! 'Johannes Hoek' (with the umlat over the e) shows in the box as 'Johannes Ho+k'. Looks like a unicode issue. Can VB apps be set to be unicode-compliant? Thanks! --Bill One may not reach the dawn save by...