1,130 Posted Topics
 | and your question is??? |
| | Re: SQL to VB 6 Create an ODBC DSN and test it to make sure it works. Then use the Data Form Wizard with the ODBC option. You will find it under Add-Ins>Add-In Manager. Run this wizard as many times as needed to create every combination of form type with code/class/control. Then save this project … |
| | Re: getting error 91 avisek_cts, I'm glad to see you created your own post so ignore my comments in the other thread you perhaps accidently posted to. Next time if you do something like that, click on the Flag Bad Post link and explain your boo boo. Switch these two... [code] AcroExchApp.GetActiveDoc Set AcroExchApp … |
| | |
 | Here is a way to check to see if the server is up and running... [url]http://www.tek-tips.com/viewthread.cfm?qid=1560292&page=1[/url] which should be sufficient for your needs. Good Luck |
| | Several ways.... [code] Dim F As Form, M As MDIForm For Each F In Forms If F Is M Then Else Unload F End If Next [/code] [code] Dim F As Form, M As MDIForm For Each F In Forms If F.Name = "MDIForm1" Then Else Unload F End If … |
 | By roll, I take it you mean enrolled in such class whatever number it may be... So, you have a TableOfClasses table and a StudentsTable table and you want to know how many students have been enrolled in whatever class. So lets add another table, TableEnrollment. The fields of this … |
| | Only problem is the hard drive serial number can change like when you reformat the hard drive. It is also able to be changed through code. So making a serial number based upon this will cause problems not only for your customer but for you. Good Luck |
| | Data Form Wizard... You will find this under Add-Ins>Add-In Manager Good Luck |
| | Re: Report Designer Easiest way is to have then purchase crystal reports designer and you just add the necessary references to your project. That way you will have distributed the necessary dlls and such to each of their machines that use your program but they only need to purchase one seat license to … |
| | Once you have compiled your code into an executable use the Package and Deployment Wizard to package up your project or use Inno (free). It should add all the required dependencies to the setup package but you will have to add the reports manually (both the PDW and INNO have … |
| | Whew! That is going to be a tough no matter how you look at it and as I look at it more it just may be impossible with the numbers you have given... Lets take the four different mixtures to begin with and for arguements sake, they are all bags … |
| | Text1.text = "some string" Text1(Index).Text = somestringvariable Good Luck |
| | To get last on use a select top 1 field from table order by unique ID (auto number field) Break it apart with split on the - character Use the upper bound of array (1) with the val function to put value into a variable. variable + variable + 1 … |
| | Use findwindow to get the handle of the window and then use SendMessage with WM_SETTEXT const. (You can't supply this info in the bat file?) Good Luck  |
| | While I have been a customer of various printing places I know very little of what goes on behind the scenes so I have to ask a couple of questions that may help you in determining a value for your product. Does your product tie into anything that can help … |
| | |
| | You may need to use the SetPrinter API if you cannot set a custom paper size through the printer object. And if you use crystal reports then you will have to also specify a specific paper size there also or you will get multiple "pages" of blanks. Good Luck |
| | 1) Remove the Dim fs from inside the loop 2) When concatinating string use the & character as the + is for additon of numbers 3) Debug.Print Val("10 pencils") Good Luck |
| | Can't use a for each... [code] Dim I As Integer For I = 0 To Printer.FontCount - 1 Combo1.AddItem Printer.Fonts(I) Next I For I = 0 To Screen.FontCount - 1 Combo2.AddItem Screen.Fonts(I) Next I [/code] I believe that screen.fonts will return more fonts (at least on my computer). Check the … |
| | If you need a tutorial there are nearly hundreds out there... [url]http://visualbasic.freetutes.com/learn-vb6-advanced/lesson8/[/url] Now, as for your code I see that on this line... [code]conn.ConnectionString = connString[/code] you do not have connString defined anywhere nor can one see what if any value connString holds and then on the next line were … |
| | have you looked into the graph control? Good Luck |
| | Couple of ways. Are you using an ODBC DSN or are you going DSN Less? DSN Less see [url]http://www.connectionstrings.com[/url] Good Luck |
| | Yes, this is all about API... The Private/Public Declare Function/Sub is the give away. Now what this code does is it alters the forms opacity level, which means the higher the alpha value the more opaque or less transparent the form is. As for learning API there are many sites … |
| | Re: Timers question Actually to calculate this, even the hard way, you don't need a timer you just need a for loop and a couple of variables to see the results after X number of iterations. Good Luck |
| | Re: datacombo For examples on how to do various things use the Data Form Wizard. You will find this under Add-Ins>Add-In Manager. Search my handle and data form wizard for the full suggestion. Good Luck |
| | as an example... [code] strSQL = "SELECT Table2.iID, Table2.iNum INTO Table3 FROM Table2"[/code] Good Luck |
| | Okay, you will need to delve into the world of the API to accomplish what you want to do. You can start with FindWindow or FindWindowEx to get the hwnd of another application. Then to read text from a window you will need to use SendMessage with the const WM_GETTEXT … |
| | You need to use the .AddItem method to add items to the combo box. Good Luck |
| | Okay siu17, Please take the following as constructive comments from someone who has been a team leader and an integrator. Even though there is a default property for a lot of things like your text boxes, you should not rely upon them but explicitly use the dot syntax to show … |
| | Yes it is possible, and with way too many ways in which to describe in just a single post. So lets break your question down into simple strait forward tasks. First, you have badge ID's. How do you display them? ComboBox, Grid of some sorts, or is user supposed to … |
| | Then that means you have two records with the same value that you are displaying. Good Luck |
| | You need the VB.NET forum... [url]http://www.daniweb.com/forums/forum58.html[/url] |
| | Use the Rnd function (see VB's help), with randomize. Use an array to hold the values, and use a sorting routine or just a simple For Loop structure to make sure a duplicate number is not generated. Good Luck |
| | Flesky, Please, in the future, start your own thread and if you need to reference an older thread copy its URL into your post. Now, when you start your new thread, please mention if you are using VBA (Excel, Access, Word, etc), VBS, or VB 6.0. Thanks and Good Luck |
| | This may also happen with a JOIN query in a PARENT/CHILD relationship. For every record in child that matches parent, parent will show a record. If not using a join query see post above. Good Luck |
| | Search barnsandnoble.com or amazon [url]http://books.barnesandnoble.com/search/results.aspx?WRD=beginning+visual+basic+6.0&box=beginning%20visual%20basic%206.0&pos=-1[/url] [url]http://books.barnesandnoble.com/search/results.aspx?WRD=visual+basic+6%2E0&box=visual%20basic%206.0&pos=-1[/url] [url]http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Daps&field-keywords=beginning+visual+basic+6[/url] [url]http://www.amazon.com/s/ref=nb_ss_gw?url=search-alias%3Daps&field-keywords=visual+basic+6[/url] Good Luck |
| | Normally used in classes, for setting retrieving property/variable in class. Think also activex, user controls, objects, and such. From VB's help... Set Declares the name,arguments, and code that form the body of a Propertyprocedure, [B]which sets a reference to an object.[/B] Let Declares the name,arguments, and code that form the … |
| | For MD5 there are a couple of ways... See strongm's post about 1/4 of the way down in this thread... [url]http://www.tek-tips.com/viewthread.cfm?qid=535644[/url] or there is a post at [url]http://www.pscode.com[/url] that is a module that calculates the MD5 hash. (Strongm's is faster). Good Luck |
| | Use the click event of the combo and set the text of the text box to the text of the combo box... [code] Text1.Text = Combo1.Text [/code] Good Luck |
| | Several ways in which to do this and it all depends upon how your database is designed and the code you have. It could be something as simple as rs.delete or strSQL = "DELETE FROM Table1 WHERE FieldCriteria = " & SomeCondition Good Luck |
| | [code] strSQL = "SELECT SUM(FieldAmount) AS TheSum FROM MyTable WHERE FieldCriteria = " & SomeCondition [/code] Good Luck |
| | Actually cguan_77 you are not far off... [code] Private Sub btPrint_Click() On Error GoTo btPrint_ClickError Dim frm As IspecialForm Set frm = Me.ActiveForm frm.GetTextBoxInvisible frm.Refresh 'CommonDialog1.Flags = cdlPDReturnDC + cdlPDNoPageNums CommonDialog1.Action = 5 CommonDialog1.PrinterDefault = True CommonDialog1.CancelError = True CommonDialog1.Orientation = cdlPortrait CommonDialog1.ShowPrinter frm.PrintForm Printer.EndDoc frm.SetStartDesign Exit Sub btPrint_ClickError: If … |
 | 1st, if you need to, install the MySQL drivers on the other machine. 2nd, create the ODBC DSN on the other machine to point to your instance of MySQL. 3rd, create an install package with the PDW or Inno and instal program on other computer. Or to answer your question … |
| | Re: delete recordset First question is... If you are creating an employee database, why do you want to create duplicate tables and duplicate records? Then, when an employee employment ends, why do you want to delete the employees records? These records could have important tax information. Perhaps a bit better explanation/plan of what … |
| | Okay, start a new standard exe project. Add reference to DAO 2.5/3.51 Declare a tabledef variable [code] Dim T As DAO.TableDef [/code] Highlight TableDef and press F1 Click Example and choose the second one down. Good Luck |
| | See cguan_77's post. They have the right answer. Good Luck |
| | nikhil2911, Perhaps I should not suggest this, but there are many calculator projects out there. See [url]http://www.pscode.com[/url] for some or search the web vb6 calculator. Now, the reason I have doubts for suggesting the above is, I don't want you to plagiarize someone elses work, but if you look and … |
| | [code] Unload Form1 Unload Form2 [/code] Every form? [code] Dim F As Form For Each F In Forms Unload F Next F [/code] Good Luck |
| | Why are you worried about the numlock key? You shouldn't need to be worried about the numlock key, at least not in this application. Good Luck |
The End.