Recent content by dpaulson

Check in ODBC Data source administrator 32 bit to see if the driver is indeed installed. David Paulson

I'm on Win 10, but I have machines on Win 7 , and xp accessing the same Mysql database. I am using VB6 and ADO. David Paulson

What OS are you using? I don't set up a system DSN, As long as the driver is listed in the ODBC Data Source administrator (32 bit) you can use it. Just substitute your information in the connection string and it should work. Public Conn As Connection Public strConnect as string Set Conn = New...

I could not get the 64 bit drivers to work. I installed an older 5.3 32 bit driver and that works. The connector string that I use is strConnect = "Driver={MySQL ODBC 5.3 ANSI Driver};Server=YourServerIP;Port=3306;Database=YourDatabase;User=YourUserName;Password=YourUserPass;Option=3...

Please ignore this post. It does work, I am doing something else wrong. David Paulson

I want to modify my accounting app to use MySQL database instead of an Access database. Below is how I write my command and parameters for an access db. strSQL = strSQL & "FROM AR_Invoice_Detail INNER JOIN (Invoices LEFT JOIN AcctsReceivable ON Invoices.CustID = AcctsReceivable.CustID) ON...

How about "SELECT (field4 + field5 + field6 + field7 + field8) as field9 FROM Table WHERE Field1 = 'AAA' AND Field2 = 'BBB' AND Field3 = 'CCC'" David Paulson

Thanks strongm for pointing out that article. I now get the handle for the owner form, which really was the one I wanted. It all good now. David Paulson

The project is named 'Wadena Steel' after my company. It's just a accounting program I've been working on and off for 15 yrs David Paulson

This is the dump if I show a simple msgbox from activate event prior to calling the callingform function frmmonthendroutine frmMainMenu 29950730 2 frmMonthEndRoutine 11536150 2 Callingform frmMainMenu 29950730 3 frmMonthEndRoutine 11536150 3...

I would tend to agree with you, but this is the 'dump' that I am getting. frmmonthendroutine 'this is called in the frmmonthendroutine to show what forms are in the forms collection, as well as their handles, last number is forms.count frmMainMenu 29819658 2 frmMonthEndRoutine...

A bit of an update. I have verified that the 'frmMonthEndRoutine' is indeed loaded and listed in the forms collection, but I find that the 'lHwnd = GetNextWindow(hWnd, GW_HWNDNEXT)' returns the wrong value so it cannot be found in the forms collection. David Paulson

Hi, I have the following code in a module Public Function CallingForm(ByVal hWnd As Long) As Form 'Return the Form that launched the given Window Dim lHwnd As Long Dim oForm As Form 'get the Handle of the Window that Loaded this Window lHwnd = GetNextWindow(hWnd...

I don't think there is much of a downside to a client side cursor when the network is local, but if the database is assessed across the internet, your upload speed is a big downside and can make your app pretty much useless. David Paulson

http://www.tek-tips.com/viewthread.cfm?qid=113356 David Paulson