http://forums.devx.com/ VB6 and earlier. en Sun, 26 May 2013 00:51:56 GMT vBulletin 60 http://forums.devx.com/images/misc/rss.png http://forums.devx.com/ http://forums.devx.com/showthread.php?185247-Visual-Basic&goto=newpost Thu, 23 May 2013 00:42:50 GMT I need someone's help, I created a work book in Excel, I have two tabs Inventory control and count sheet. I want to link some information on the Inventory control sheet to the count sheet. How would I do that using VB. ]]> VB Classic jdean1081 http://forums.devx.com/showthread.php?185247-Visual-Basic http://forums.devx.com/showthread.php?185245-How-to-detect-user-activity&goto=newpost Sun, 19 May 2013 18:38:03 GMT Is there a way to determine if any keyboard or mouse activity has occurred in a predetermined time interval? I'm trying to find a way to automatically disable my programs edit mode if there has been no activity (i.e. person entered password enabled edit mode & walked away). The timer part is simple. I haven't been able to determine how to reset the timer based on any activity. ]]> VB Classic ksquared http://forums.devx.com/showthread.php?185245-How-to-detect-user-activity http://forums.devx.com/showthread.php?185233-Software-edit-file-*.skin&goto=newpost Sun, 05 May 2013 07:33:16 GMT UI Design with skin form, software can edit the *.skin file ?

For example:
http://www.planet-source-code.com/vb...xtCodeId=74755
http://www.caulacbovb.com/mp_details.php?pid=104432 ]]> VB Classic dong http://forums.devx.com/showthread.php?185233-Software-edit-file-*.skin http://forums.devx.com/showthread.php?185231-max-value-with-inner-join&goto=newpost Fri, 26 Apr 2013 13:40:35 GMT Hi,

I'm using Visual Studio 2010 and I'm trying to make a query that return tha maximum value of CodDekafix from the table Indice and get other values from others 3 tables with the same value CodDekafix. The code is below:


sql = "SELECT * FROM Indice " _
& " WHERE CodDekafix=(Select max(CodDekafix) From Indice) " _
& "INNER JOIN (((dekafix1 INNER JOIN dekafix2 ON dekafix1.CodDekafix = dekafix2.CodDekafix) " _
& "INNER JOIN dekafix3 ON dekafix2.CodDekafix = dekafix3.CodDekafix) " _
& "INNER JOIN dekafix1_2L ON dekafix3.CodDekafix = dekafix1_2L.CodDekafix) " _
& "ON Indice.CodDekafix = dekafix1.CodDekafix ORDER BY Indice.CodDekafix"

But the result is an error: Syntax error (missing operator) in query expression

Any suggestion?

Thank you a lot,

Edson ]]> VB Classic Edson_Abreu http://forums.devx.com/showthread.php?185231-max-value-with-inner-join