1,130 Posted Topics
 | Here is one sort... [url]http://www.vbforums.com/showthread.php?t=231925&highlight=sort[/url] and a list of sorting routines... [url]http://www.vbforums.com/showthread.php?t=473677&highlight=sort[/url] Good Luck |
| | Re: Qbasic Program Sounds like you will need to keep track of those previous numbers with some variables and its been a long time since I had to do anything to do with QBasic but an array would serve you nicely. Then you would need another variable to keep track of how many … |
| | serkan sendur, Please start your own thread No. You will have to make your own form that looks like a message box. Good Luck |
| | Well with VB you need to have the correct library installed. i.e. for an office 97 access datbase you would need to have office 97 installed with the method you are trying to use. On the other hand if you use DAO, RDO, or ADO, more often than not the … |
| | FindWindow, EnumChildWindows, SendMessage API's Good Luck |
| | Set gridCounter.DataSource = [COLOR="Red"]dataCounter?[/COLOR] Where is it defined? Set gridCounter.DataSource = [COLOR="red"]rsMyRs[/COLOR] Good Luck |
| | Sorry Michael, that is .NET only and won't work in VB6. Once you have the path to the temporary internet folder and if you can enumerate through its files by using DIR/FSO/FindFirstFile-FindNextFile/DriveListBox-DirListBox-FileListBox then you can use the FreeFile Function-Open Statement-Input Function-Line Input Function- and the close statement to read the … |
| | Should be something like... [code] myrs.Open " SELECT memberpersonal.name,memberpersonal.memberid, FROM memberpersonal, INNER JOIN memberunion ON memberpersonal.memberid = memberunion.memberid where memberunion.memberid = " & cmbUnion.Text , mydatabase [/code] Good Luck |
| | This is because of one of the quirks of ADO. -1 means that it has found records but does/did not get an accurate count. A couple of ways to get the accurate count and to test to see if you have records are as follows... [code] If adoRs.RecordCount <> 0 … |
 | I believe you need to download MDAC 2.5... [url]http://www.microsoft.com/downloads/en/results.aspx?productid=&freetext=mdac&displaylang=en[/url] |
| | Where is .SalesRep declared and where is its parents with statement? Good Luck |
| | Unless the two tables are exact (TableDefs) then they... Is this VBA?  |
| | Simple way is to add a module and declare the public variables there. Good Luck |
| | jephthan, I thought about flagging your post but then I thought I would share a story with you, but who knows, someone else might come along and flag it... When I was working with a unnamed company, they hired a guy nearly strait out of college at nearly double the … |
| | See adobe's site and grab there PDF print driver... okay here it is... [url]http://www.adobe.com/support/downloads/thankyou.jsp?ftpID=1500&fileID=1438[/url] this is the installer that will check your system and download the postscript drivers so you can print to PDF. Then in your code you will need to change the default printer that you print to … |
| | Re: Listview issue Okay, the part you tried to highlight in red is constantly returning zero and it should be something like... [code] ... = Combo1.ListIndex [/code] That is, if what you need is the index number but if your field is 1 based and not zero based like the combo then you … |
| | For sorting do a search for sorting vb6. Good Luck |
| | [code] varname = Replace(varname, "'", "''") [/code] Good Luck |
| | Okay, this looks like it may help... [url]http://vbnet.mvps.org/index.html?code/comctl/lvledger.htm[/url] Good Luck |
| | It might be they way you are using the select max. For future reference (without spaces) use the [ code ] [ / code ] tags to display your code (makes it easier to read). Perhaps you should do a count or if the field is a unique id, do … |
| | Kehar, You failed to mention what kind of database. Access, MySQL, SQL, Progress, Alpha, Oracle, Fox Pro? However, for most of those it is as simple as having a lookup table to populate your combo box and to change the table your queries look to. BUT, for some things like …  |
| | If you are talking about the ADODC (ado Data control) and the MSFlexGrid or the MSHFlexGrid then yes you can populate either grid without the use of the control. However, the easiest way is to bind your datasource to the controls datasource property but you do not have to. You … |
| | Well, it really depends on exactly what you are doing... If you have something like this... Procedure01 calls procedure02 Procedure02 calls procedure03 03 calls 04 04 calls 05 .... Then what you are doing is building up the stack space and thus you can see the memory expand. However if … |
| | Well lets start with your declaration statement... [code] Dim car, color, door As String, cost, cost1, cost2, cost3 As Single [/code] Just so you know, car, color, cost, cost1, cost2 are all varients while only door is a string and cost3 is a single. Next off, since you are doing … |
| | Re: Visual Basic Use the data form wiard with all possible combinations of form types with each of the code/class/control options. |
| | Wrong forum, you need the dot net forum... |
| | Or there is the formatnumber function... [code] ?formatnumber(1/ 2946.33,8) 0.00033941 [/code] Where the "8" after the comma tells the function how many places after the decimal you want. Good Luck |
| | see... [url]http://www.vbforums.com/showthread.php?t=381167[/url] Good Luck |
| | In the most simplistic way, you can use the shape control for the head and line controls for the rest of the body. Stepping up from that you can use a picture box control to draw in via line and circle. Then from there you could use a predifined image … |
| | If you are talking about where you have the color tags that show up as text then I would say you have to open the connection before you can test it. From what I see you have only declared the variable con as a New ADODB.Connection but have not acutally … |
| | Is the excel sheet used for input? Meaning does the excel sheet contain the names of the books and the prices? If so then it is not one time. Good Luck |
| | To begin with VBasic 10 would be VB.NET... Second, Jupiter 2's reply is not entirely correct... There are out there programs that "say" they can reverse engineer programs, i.e. decompile programs and while they are capable of doing such things, the result is less than readable. For each sub/function/property/event etc. … |
| | Re: animation help 33 pixels? Man your object is moving fast! Are you sure that the "play" area is a multiple of 33? Are you sure you are not talking twips? [code] Option Explicit Dim GoingLeft As Boolean Private Sub B3R1_Timer() On Error GoTo B3R1_TimerError If GoingLeft = True Then 'make sure the … |
| | I know other office applications have the ability to record macros and if power point does, then record a macro of what you want to do, view the code and for the most part move it over to VB6. If not, don't know what to tell you... Good Luck |
| | Re: Database Select * From YourTable Where UniqueID = 93 Although, I'm willing to bet the answer to your question is not going to be that easy. For us to help you better we could use some more information like some sample data, the structure of you table, is there any possible … |
 | So you say it runs on your computer but not on another. Did you create an install package with the Package and Deployment Wizard (A.K.A. PDW) or use Inno to do so and if you did then did you install in on the other computer? |
| | Okay, As long as none of the fields that you mention are of an autonumber field you can do something like... [code] strSQL = "INSERT INTO Table1(LineNumber, JobName, Batch, Coder, DocDate, DocChar) SELECT Table2.LineNumber, Table2.JobName, Table2.Batch, Table2.Coder, Table2.DocDate, Table2.DocChar FROM Table2" [/code] Then execute via command object and what this … |
| | For the most simplistic version you could check the creation date of some file you created against the now function, do a date diff based on "d" (day) and if >= 365 display message/shutdown program. However, user could get around this by resetting the date time on the machine. Same … |
| | Okay, is this data that you captured written to a file? I ask because you use the past tense "captured" as this is not a NRT (Near Real Time) application. If it is a NRT application and you recieve this data in chuncks then the way you handle this data … |
| | Okay, the closest you are going to get as far as I know is... [code] Dim aTemp(0 to 1, 0 to 1) As Integer [/code] But then you would have to do... [code] aTemp(0,0) = 1 aTemp(1,0) = 2 aTemp(0,1) = 3 aTemp(1,1) = 4 [/code] Good Luck |
| | Re: DLL You cannot create a dll in VB with C++ coding/syntax. However, you can create a dll in VB with VB coding/syntax that does the same as what you want to accomplish with the C++ code but you may have to jump through some hoops. It all depends upon what you … |
| | Sounds like you need speed throughout. So I would suggest C, C+, C++, and also would suggest anything that uses a lot of overhead in the way of libraries you should stay away from and this means .NET. You can however have all your inportant code that needs the speed … |
| | Well, to find the average of any group of numbers it is the sum of numbers divided by the number of elements. Good Luck |
| | Yeah, if your looking for a specific unique identifier based upon the text of the combo box that the user selected and your database has been normalized and you have defined the relational fields then... [code] Private Sub ComboCountry_Click() SQL = "SELECT tblState.State, FROM tblState INNER JOIN tblCountry.iCountryID = tblState.iCountryID … |
| | Re: Hangman Game Well since you have command buttons on the form you cannot use the form's keypreview property but you can use any of the following events of the command buttons as long as they have the focus... KeyDown, KeyPress, KeyUp Now, as for checking if the letter is within the word/phrase … |
| | What mode? 16 or 32? If 16 on 32 bit machine it just might be your problem but it has been such a long time since I worked on 4 that I am just grasping at straws. Good Luck |
| | See SaveSetting, GetSetting in vb's help. Good Luck |
| | Re: downloading WinZip has this functionality... [url]http://www.winzip.com/prodpagese.htm[/url] Good Luck |
| | Perhaps a boolean array with elements that equal your animation array elements that you can check against for specific element pauses/freezes. Just a thought... Good Luck |
| | A definition at the top, a Java example, then a VB6 example... [url]http://compsci.ca/v3/viewtopic.php?p=146070&no=1[/url] Another... [url]http://www.tek-tips.com/viewthread.cfm?qid=1387082[/url] Good Luck |
The End.