2,155 Posted Topics
 | The links looks VERY suspect to me James. Give us more information on what and how you want to loop or include a picture as an attachment here. We will gladly help from there...  |
 | Here is a few solutions... This is because it runs a service which creates registry keys under the SYSTEM account. When VB tries to enumerate the keys under HKCR\TypeLib it fails and gives the error because the user running VB6.EXE (even if it set to run as administrator) does not … |
| | Have a look at [THIS](http://www.codeproject.com/Articles/15222/How-to-Use-Stored-Procedures-in-VB6) link.  |
| | It seems that you have declared the object but did not set it, the error is refereing to "Report" Add the following... Dim Report As New rstoreinmaterial Set Report = New rstoreinmaterial ''This line is new... Report.RecordSelectionFormula = "{DetailsStore_InOut_Material.RepNo}= " & Val(RepNo.Text) & " and {DetailsStore_InOut_Material.projectno} = '" & ProjectNo1 … |
| | This sounds like someone needing to get a project completed, expecting us to do it. ;) Unfortunately you need to show some effort from your side - any errors in your code etc.. we will gladly help from there. |
| | multiple rows of same employee? what will be returned that will be added to new table? There is code for both but with more info we can determine what you need.  |
| | Your error occurs because - the mainForm is to be loaded in modal mode, no problem. You then have a reference to an object called ProjectMainDate which is not part of your project. In other words.... You are telling vb6 to load mainForm that is in a project called ProjectMainDate. … |
| | Tokipot, nobody here will do the entire project for you. this is a helping community where you must at least show some effort from your side. Show us some code and we will gladly help with error resolving etc. Please read our rules [HERE](http://www.daniweb.com/community/rules). |
| | Is p_id not set to an auto increment number in your database? If so, it will return an error if you are trying to overwrite the number after it has been set to auto. |
| | The crviewer.dll error is because you do not have crystal reports (or the incorrect version!!) installed on your pc. You need to have the version that is referenced in your application installed for it to run properly. Your first error - "not defined" is because you have not declared a … |
| | Where will Text1 get its data from? If it is from the grid, I assume you used code like - Text1.Text = DataGrid.Col(0) ''and so forth for all other fields... > refer = DataGrid1.Col refer = Text1.Text You gave refer 2 values here... a bit confusing. Also use conventional naming … |
 | > There are also 7 rows (but in one column only) for each values Coloumn of what? not sure what you are reffering to here.. How do you go about setting the random allocation? I'm not sure what you require to do, please give me more info Abe. :) |
 | Hi Mark, Just add another listbox to your form, lstNames... When adding the scores, add the name to this listbox - lstNames.AddItem PlayerName Remember to loop through it to get all names loaded as you did with their points... Now, AFTER sorting listbox points, sort the names in the same … |
 | The error warns you that no value was given OR returned. Maybe there is no value under Employee_Gender but you are making a call to it. Check your database to see if there is values available to show. |
| | > Now my questions are: Is my database connection correct? (I'm planning to put the database in the Windows folder) You are going to have multiple user access violation errors here. To keep it simple, just copy the database to the users c: folder, no violations here that I encountered … |
 | Indeed, integer has no problem returning data without the qoutation marks, strings does however. Nice in resolving your problem, some kudos... :) |
| | > I have a problem for my system Registration > in times of printing a record of student We are all extremely effiecient, we can however not read minds.. :) What problem/error. what code? |
| | I have multiplied a very big integer and the sum made automatically added the "E" and the decimals after that. 1 000 000 000.123456789 * 123456789.123456789..... Answer returned = 1.23456789138698E+17 This allows 31 DECIMALS! |
| | What code do you have so far? If any code, where do you get errors? |
| | I've asked moderators to move this to vb.net. This is the vb6 forum. I'm sure you will get more responses there than here in vb6. :)  |
| | After some reading, it seems that access 2007 (never happened in 2003) has a bug when you enclose the field name in enclosed [] brackets. Remove the brackets and see if that solves your problem... @Nutster, the SELECT code is fine, used in ms access 2007 Also try and run …  |
 | In your Word document, do ctrl-F9. Within the braces that word gives you, type the following: HYPERLINK "C:\\My Documents\\MyExcelFile.xls" So it looks like { HYPERLINK "C:\\My Documents\\MyExcelFile.xls" } But note that you can't type the { } braces by hand. You must use ctrl-F9 and type between the braces that … |
| | This is a vb.net question. I've asked the mods to move it over there. Irrespective, the solution would be-- commission = (Sales * commissionRate) / 100 |
| | It depends on where your root folder is placed i.e. in XAMPP it will be in the httpdocs folder and you probably will have a folder for your app as well. you then need to specify the path to that folder - http://192.168.1.10/MyAppFolderNameHere/mywebpage.php To check if you can connect to … |
| | |
| | Which version of MS Word are you using, 2007 or 2010? Also have a look at [THIS](http://cybertext.wordpress.com/2008/04/27/word-2003-automated-tables-of-figures/) link, might contain your answer. |
| | What scale? Where does data come from? etc. etc. There is no information left to help you with... |
| | Use a loop to load the results... Dim x As Integer For x = 1 To 14 LeagueTable(x).LName = PlayerName LeagueTable(x).LPoints = Points LeagueTable(x).LTourn = TournamentGames LeagueTable(x).LTotal = TotalGamesPlayed next x |
| | Is text1 and other controls web browser controls or vb6 form controls? What code do you have to validate the login? |
| | This looks like MS Access 2007. The INSERT to SELECT is then 100% for appending a record. Assuming that the correct record was selected, the code will run fine. There is however no other "shorter/quick"method to update the data, you have to call every field and set its data. You … |
| | Your CommandText is incorrect - .CommandText = "update employee set employeeid ='" & Val(Text1.Text) & "', name='" & Text2.Text & "' WHERE employeeid='" & val(i) & "'" ''If empid is ONLY a number, you do not have to use the ' to enclose the id... ''Also, you can not set … |
| | |
| | to create a new workbook you can use something like - Dim iCountMake As Integer, iRowMake As Integer, iCountModel As Integer, iRowModel As Integer, iCountType As Integer, iRowType As Integer Dim objExcl As Excel.Application Set objExcl = New Excel.Application objExcl.Workbooks.Open (txtExcellPath.Text) objExcl.Visible = True ''objExcl.SheetsInNewWorkbook = 1 ''objExcl.Workbooks.Add Dim r … |
| | You do not have to use Data Report, you can use something like the Listview Control etc. The Listview can sort data in columns etc. |
| | Where would the data be coming from? a Database? If so, which Sql statement are you using to retrieve said data? |
| | Listview will be working with coloumns and rows etc. Entirely new question, as Bit said, this thread is solved, you need to start a new thread... |
| | Re: help Add the following code after your SQL string... strSql = "SELECT * FROM tb_absensi " & _ " WHERE nrp='" & cmbnrp & "'" & _ " AND tanggal = " & CDate(lbltgl.Caption) If rs.State = 1 then rs.Close End If rs.Open strSql, Conn You then opened your recordset, let … |
| | Re: VB6 Grid Control Filter records by using a proper sql statement. It would read something like the code below. You do however need to give us much more information. [CODE]Rs.Open "SELECT * FROM MyTable WHERE MyField = '" & Text1.Text & "' ORDER BY MyField DESC", con, adOpenStatic, adLockOptimistic[/CODE] |
 | The code involving printing of listview is a bit more involved. The below example prints the data only in a report format and it sizes itself to display all of the values' text. It does not print icons or other ListView display formats. When the user selects the Print command, … |
| | Being a virtual monitor I presume that you are using a picture box as your monitor.... You can use the following code to dim the brightness... Add a picture box (Picture1, a command button (Command1) and a textbox to the form. Set the picture box ScaleMode to 3-Pixels, and AutoRedraw … |
| | The code should be... Printer.PaintPicture Picture2.Picture, 0, 0 and not Picture.Image |
| | You are using sql server without user name and password authentication. Seems to be your problem right there... |
| | Print it to where, your form, another textbox, printer? |
| | Hi Sanket, this has been posted in the wrong forum being vb6 and not C... :) I've asked that it be moved. |
| | You can create a menu toolbar and call it when you have clicked on something in your toolbar. PopupMenu mnuYourMenuNameHere |
| | Have a look at the Google search [HERE](https://www.google.co.za/search?q=plot+a+continuous+graph+with+serial+communication+in+vb6&sugexp=chrome,mod=9&sourceid=chrome&ie=UTF-8). I'm sure you will find your answer in there. |
| | Joshua, this thread is more than a year old. Please open your own thread from [HERE](http://www.daniweb.com/software-development/visual-basic-4-5-6/4/contribute). We will gladly help, just not from here. |
| | You need to give us much more information- what will handle the progress bar, data, some loading of pictures etc? What code do you have so far for the p/bar? show some effort from your side. in another form? not sure what you mean here, p/bar in form 1 and … |
| | More Michael, welkom by Daniweb. Ons reels is dat ek dit in engels hou... I deliberately used ActiveWorkbook rather than ThisWorkbook - make sure that you understand the difference. Consider the following (and choose a workbook from a different directory to see the different path names). Sub Test() Dim filename … |
| | As nutster pointed out, "help" is a reserved word. Change it to something help like "MySubHelp" etc.... Also, as pointed out, where do you make a call to the function. if not called, it will not execute. :) |
The End.