419 Posted Topics
 | > the secondary axis i want it to be fixed in the line of the primary axis in the left side Assuming that this means that you want both axes to have the same range, then something like this will work. With Chart1 ' Y1 = first Y Point, Y2 …  |
 | > arr is a binary data file stored in a database Assuming that this means that "arr" is a byte array that has been loaded from a database, then change: ` Photograph1.Image = Photograph1.Image.FromStream(New IO.MemoryStream(arr))` to: ` Photograph1.Image = Image.FromStream(New IO.MemoryStream(arr))` FromStream is a shared method on the Image class. … |
 | I do not know if this is required, but you are missing the termininating ";" `"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\20130305.xlsx; Extended Properties=Excel 14.0;HDR=YES;"` You mention x64, did you install the x64 version of [Microsoft Access Database Engine 2010 Redistributable ](http://www.microsoft.com/en-us/download/details.aspx?id=13255)? |
| | You may find looking at the Data Connection Dialog code instructive. [Release of Data Connection Dialog Source Code](http://archive.msdn.microsoft.com/Connection/Release/ProjectReleases.aspx?ReleaseId=3863) |
| | @Andre, The NZ function allows for substituting a Value for a Null. Something like this: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName]) is analogous to: If [AnotherFieldName] is Null Then [AnotherFiledName] =0 End If If [AnotherFieldName] = 0 Then Return 3 Else Return [AnotherFieldName] End If OP: The expression should be processed by the database engine …  |
 | Chris, When you write "the pages alignment of the tables is off" do you mean the physical positioning on a given page or do you mean that they are not appearing on the Excel tab that you expect? If it is a physical positioning problem (the table is not at … |
 | April, Look at your button handler. You are creating anAccount each time. Move the declaration of anAccount to the class level. Also, rethink your logic. Would it not be better to call Deposit with an amount to deposit?  |
| | Try something like this: Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sorter As New lvMonthSorter sorter.MonthColumn = 0 ' set the column that holds the month sorter.Order = SortOrder.Ascending ListView1.ListViewItemSorter = sorter End Sub End Class Public Class lvMonthSorter Implements System.Collections.IComparer … |
 | >MsgBox "Found here " & Rng Rng is an object. If you wnat the address use Rng.Address. But move to be inside your if block just in case that Rng is Nothing. |
| | The only **automatic** substitution that I am aware of being allowed in a connection string is the "|DataDirectory|". `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.accdb` The default definition for DataDirectory is the application directory, but this can be redefined like this: `AppDomain.CurrentDomain.SetData("DataDirectory", Environment.GetFolderPath(Environment.SpecialFolder.Personal));` The obvious caveat is to redefine it before trying to use the … |
| | Based on the fact that you currently have this working, It appears that the returned recordset for the first entered character is not to large to fit into the available memory. The question is why are you querying the database for subsequently entered characters? Load a datatable based on the …  |
| | For future reference: [SQL Server Data Type Mappings](http://msdn.microsoft.com/en-us/library/cc716729%28v=vs.90%29.aspx) |
 | > "A first chance exception of type 'System.NullReferenceException' Don, Most likely you have misnamed one of the Textboxes or it is not parented to the form. Try adding the if-block shown below. Me.Controls("something") will return either a control named "something" or Nothing (null) if the requested control does not exist … |
| | Pass "false" in the Close method; wordDoc.Close(false); |
 | Sometimes this happens when the solution files get corrupted. Delete the "projectname.snl" and "projectname.sou" files and then using VB open the project definition file "projectname.vbproj". |
| | It would help if your showed the code that you are using. At this point I can only guess that the method you are using calls Image.FromFile followed by Image.GetThumbnailImage and is not properly releasing the GDI resources. If this is the case, take a look at this: [Load Image … |
| | Don, This type of coding is seductive at first glance, but can be a major PITA to maintain. Say if at some point you decide that you need to use a RichTextBox (or some other control for that matter) for one of the fields so that you can take advantage … |
| | Just to let you know, I am also pretty much self taught in programming and hold two engineering degrees. In fact, it was my distain for doing mundane computations that provided the impetus to become more proficient at programming. It takes time to to develop skills whether they be in …  |
| | Since you are making a calculator, I am going to assume that you what to mimic the behaviour of most calculators in that when you type in a number that the most significant digit shifts to the left while the entire number is aligned on the right side of the … |
 | >So I take my favorite word and mix it with numbers, like: b1u2l3l4s5h6i7t I see into the future and Ene Uran's account has been hacked. :)  |
| | Re: MS Word Here is a Word VBA macro that will split a table whenever the page number changes. It appears that you are fluent in Word Interop so it should not be too hard for you make the needed changes to convert it to VB.Net and add your Title Insert code. Sub … |
 | >when i enter a position in my form in a text field then the button that is in the same position get activated private PointConverter pc = new PointConverter(); private void button2_Click(object sender, EventArgs e) { Point pt ; Button b = null; try { if(!String.IsNullOrEmpty(textBox1.Text)) { pt = (Point) … |
 | It sounds like you want a way to enumerate through the files in a directory. [Directory.EnumerateFiles](http://msdn.microsoft.com/en-us/library/dd383458.aspx)  |
| | Don, Do all of those 170 columns define a single record? If so, I suspect based on your past references to excel that you have a lot of redundant data in there. Since you are defining the database, it behooves you to ensure that it is well designed before you … |
| | I am not saying this is the source of your error, but it is sure a strange statement. `Not e.Result.ToString & "" = ""` Unless there a Cancelation pending before the DoWork event fired, `e.Result` should always be some type of string object, either "ok" or an error message. In … |
| | Oh boy blinky buttons! : ) Give this button a try: Public Class FlashyButton Inherits Button Private WithEvents FlashTimer As New Timer Private _AlternateBackColor As Color = Color.Green Public Property AlternateBackColor() As Color Get Return _AlternateBackColor End Get Set(ByVal value As Color) _AlternateBackColor = value End Set End Property 'AlternateBackColor … |
| | You have mixed together various statements that are not necessarily related. ConnectionSettings() ' this does what? ' I assume that con is a MySqlConnection defined elsewhere ' don't need to open connect, the dataadapter will handle open/close 'con.Open() Dim sql As String ' you do realize that this dataset will … |
 | >after this there existed a variable with the name and value as requested This sounds like a key-value pair to me. Perhaps a [Dictionary](http://msdn.microsoft.com/en-us/library/xfhwa508.aspx) will work. |
 | >How come I can not print it? Please show all your code. |
| | I will admit that web stuff is not my strong point. But would not the final document received by the webrowser control you are using hold the same HTML as your function retrieves? You can receive a lot of documents before navigation is complete due to scripts executing on the … |
| | [coding virus using vb script .vbs](http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/294413/coding-virus-using-vb-script-.vbs) Granted it is pretty pathetic, but some fool is looking for help to run the code shown. |
 | > Hi to all,This is the error rise::"Unable to cast object of type 'System.Int32' to type 'System.String'". I suspect that the error is occuring in one of the `dr.GetString(#)` statements. Try. `dr.Item(#).ToString()` instead. Substitute the actual integer for "#" in the above statements. |
| | Please show us the code you use to add the tabpage otherwise we are just making uninformed guesses as to what the problem may be. |
 | Pass a reference to the RTB in in custom menu item's constructor or add a RTB property to it. Private RTB as RichTextBox Public Sub New(RTB as RichtextBox) Me.New() Me.RTB = RTB End Sub or Private _RTB As RichTextBox Public Property RTB() As RichTextBox Get return _RTB End Get Set …  |
| | Try recasting the document to a [IHTMLDocument3](http://msdn.microsoft.com/en-us/library/aa752541%28v=vs.85%29.aspx) use getElementsByTagName on the new cast object, |
| | Friend just makes them accessible throughout the current assembly (similar to Public, but not accessible outside the defining assembly). If the control does not need to be accessed outside of the control in which it is declared, then Private is fine. Friend is the VB default for autogenerated code; nothing … |
| | Well, let's look at your code that determines if it is a right trianle. If (s1s + s2s = s3s) Then ' Display the result triResult = "You have created a right triangle!" End If If s1=3, s2=5, and s3 =4 will the above test that you defined be true? … |
 | My 2 cents worth on this is if this site actually allowed us to put articles under the tuturial tab that could be referenced a lot of this would be less painful all the way around. I would actually like to see the Tutorial section be a wiki of sorts. … |
 | Here is another way. Private Declare Function AssocQueryString Lib "shlwapi.dll" Alias "AssocQueryStringA" _ (ByVal flags As AssocF, _ ByVal str As AssocStr, _ ByVal pszAssoc As String, _ ByVal pszExtra As String, _ ByVal pszOut As String, _ ByRef pcchOut As Long) As Long Declare Function ShellExecute Lib "shell32.dll" Alias …  |
| | You have everything you need already. You just need to create an instance your class. PlotParameter pm = new PlotParameter(); pm.AreaId = "id-1"; pm.ParameterName = "fred"; pm.ParameterValu = "wilma"; |
 | YouTube users may find this interesting: [Legal liability for YouTube viewers](http://news.cnet.com/8301-13739_3-9936833-46.html)  |
| | Might as well take it the rest of the way and get the top 5 that the OP wants. SELECT TOP 5 Count(ContactInfo.CustomerID) AS CustomerCount, ContactInfo.City FROM ContactInfo GROUP BY ContactInfo.City ORDER BY Count(ContactInfo.CustomerID) DESC Note that this can return more than 5 records if multiple cities have the same … |
| | What is the problem that you got with the answer you received here: http://www.daniweb.com/software-development/threads/448193/.nethow-can-i-split-my-full-name-2-get-the-1st-name-to-put-in-1st-name-lbl#post1936112 Also, Please read [this.](http://www.daniweb.com/software-development/vbnet/threads/424836/please-read-this-before-posting) |
| | I guess mileage will vary. I ran you code under VS2008 on a 32-bit XP and Vista and got similar results. Note that my Vista laptop is way under powered. The XP machine has 2 GB Ram were-as the Vista machine has 3-GB ram. Compiled Any-CPU, Release build. The interesting … |
 | see: [Embedding DLLs in a compiled executable](http://stackoverflow.com/questions/189549/embedding-dlls-in-a-compiled-executable) |
| | The Access violation is probably due to you running VB6 as a standard user. Try running it as an Administrator. VB6 is an old program designed when nearly everyone ran with full privileges. I get the same thing on my XP machine running under a normal account. VBA under Excel … |
| | Most likely your query is failing to retrieve any rows. > strSelect = "SELECT * FROM dbo.hrEmployeeInformation WHERE eiEmployeeID = '" & dhcboEmployeeSelect.Text & "'" Is "eiEmployeeID" stored as text or is it a number? If it is a number, remove the single quote (') from the the Select statement. |
| | Re: power operation If you can live with the 28 digit accuracy of the decimal type for the result of the exponentiation, then you can implement your own power function. private void test() { Int32 v = 11; Int32 d = 23; Int32 n = 187; decimal exp = DecPower(v, d); decimal m … |
 | Re: Set timer You have indicated that you have a database. Why not store the info there? What type of database is it? Registry based systems are easy to crack. Usually, all it takes is for the user to identify which key your program has added and delete it to reset the counter. |
| | >I do have the ability/habit of picking up the accents of people I am listen to though. @Nuster I also have that affliction and it can be quite embarrassing at times. Once I was the butt of the jokes at the office after sending two hours on the phone with …  |
The End.