Answer Questions
MikeV1 populating an Access database using visual basic 2005
I am trying to create a new employee application that gets input from a user in text boxes and then take that information and populate a database in Access that will later be pulled to the Track IT! database on SQLserver2005. How do i do it Thank you. IGiberson wrote: i have to declare the oledbcommand as a variable dont i and would i do that just as a variable pretty much yes - take a look at the link I supplied earlier about the OleDbCommand - there should be some examples but definately some explaination/documentation too! :-) there are a few ways of doing this but the easiest way probably would be to use a datagridview and dataAdapters. the datagridview is a control whi ...Show All
MauriceR Voice Recognition
I've been reading a lot of web pages that tell you how to do voice recogntion things, and all of them say to select the Microsoft Speech Recogntion component thing, but I can't find it! Where is it, and can someone point me in the direction of a good article on how to do voice recogntion things in Visual Basic (Unless someone wants to list the code here, but I doubt that. ) Thanks! You need to install the speech sdk 5.1 or .Net Framework 3.0 but you can use both with visual basic express. Thanks, Kyle. You told me what I needed to know. I'll tackle the coding later, I just wanted to find the component selection thing. I have the SDK AND the .NET framework V3, so I should be okay. Thanks again every ...Show All
mthompson125 Need To Create Search Bar For Database
Greetings, I am completely and utterly amazed at the lack of information on how to create or employ a search bar. This is the one simple attribute that has made the internet what it is today. Nearly every program I have ever used has a search bar which, when data is entered into the textbox and the search button is clicked, it returns matching criteria. However, I have searched (Imagine That) Google, Yahoo,LearnVisualStudio.net, MSDN, and Help for three days on how to create such a simple procedure and have found nothing. What I need to do: I am creating a database where I have all my Employees Information which includes columns: [Employee Number], [Emloyee First Name], [Employee Last Name], etc.... I have created the database and ...Show All
Dlloyd Search Function
Hi First off, i'm completely new to visual basic. I have a basic access database for making orders for a made up company and I have made an Order Form. I'd like to be able to search the Customer table field; First Name from the form and have the results displayed so that the user can click the matching one and have the form automatically fill itself out with the customers details. If possible i'd like the search to search both the first name and surname fields using what the user inputs into two text boxes, one for first name and one for surname with a command button to start the search. Any help would be much appreciated Lance I would create the text boxes to capture your search strings. Load the order ...Show All
nazdrug06 Drop Down Item Mouse Hover
I am using a context menu in a text box, and have a menu item called 'Quick BOM' - when the user hovers the mouse over this, a drop down menu for 'Quick BOM' opens that is dynamically created from an SQL query that populates this according to the part number in the text box. This all works fine. The next function I want to add is for an event to be called when the user hovers the mouse over the new drop down menu that will allow me to do further analysis of this part number (such as recall a description and place in a label field). There is a DropDownItemClicked event, but what would be most useful is a 'DropDownItemMouseHover' type event. Any suggestions on how to create such an event - the menu contents will change ...Show All
paraGOD Compare graphical data, but not so accurately? In VB
A friend of yours answered my first question about "Comparing Graphical data", but it was only for completely identical images, that source code will be posted later on. Now I want to know how to compare that graphical data but not so accurately, like, to compare every third, fifth, or whatever pixel in the image Is this possible Here is the source code: Private Function CompareBitmapImages(ByVal b1 As Bitmap, ByVal b2 As Bitmap) If b1.Width <> b2.Width OrElse b1.Height <> b2.Height Then Return False End If If b1.PixelFormat <> b2.PixelFormat Then Return False End If Dim bytes As Integer If b1.PixelFormat = PixelFormat.Format32bppArgb Then bytes = b1.Width * b1.Height ...Show All
c0d3bl00d3d problem of controls array in Visual Basic 2005
Hi: I wrote a project in vb6. That project contains controls array and I want to upgrade this project to vb2005 but I have some problems. In vb6: I have array of checkbox When the user check the checkbox It's index = I as integer then Create 3 elements in 3 arrays of combobox All this elements have the same index When I want to determine any combobox by the index of checkbox I will write code like this: For i = 0 To Check1.UBound If Check1(i).Value = vbChecked Then &nb ...Show All
cmfairbank Trialware timeout
What is the best method to make an application timeout after a given amount of days since install our use unless the product has been registered Thanks take a look at the shareware starterkit, it should give you a few pointers http://msdn.microsoft.com/vbasic/downloads/starterkits/default.aspx Cathal You could use a registry key and read in that key to see howmany days, hours or startups are done. Or you can make a file if your program firsts starts up. Encrypt this file or write into it in something that isn't directy readably by a text editor. Both methods work but are really easy to 'crack' if you don't protect the data inside well ennough. ...Show All
CirdanCelebrindal arrays
i am doing a quiz, capital cities of which country. i have stored the data in two arrays Country() and Capital(). i have to randomize the questions so they don't come out in alphabeticle order. all suggestions are welcome. thanks Zeldacat Dim Max As Integer = 50 Dim Countries ( Max ) As String Dim Capitals ( Max ) As String FIllCountriesAndCapitals () vb . Randomize () Dim Randomnumber As Integer = CInt ( Int (( Max * Rnd ()))) MessageBox . Show ( Countries ( Randomnumber )) Is it possible to use Random number to access values from your arrays Then you have to generate unique random numbers..... Take unique numbers and sh ...Show All
Dietz Webbrowser http://???
Hi, I have a webbrowser i made but when you dont put in the http:// by yourself it doesnt go to the webpage...Is there a way to make it place (http://) or (www.) in front IF IT DOESNT have it already. Try this: WebBrowser1.Navigate( URL ) System . Windows . Forms . WebBrowser. Navigate (ByVal urlString As String ) not uri Dim Url as string = "foo.com" If not Url.Contains("www.") then Url = "www." + url If not Url.Contains("Http"//:") then Url = "Http"//:" + url Ok, Now the Format of the URI cant be determined. Whats typed into the Text Bar " apple.com " Code Used: Private Sub cm ...Show All
kennm Missing Assembly Microsoft.SqlServer.ConnectionInfo while using ClickOnce deployment
hi, I am using VB.net and I have a problem while publishing my application using the ClickOnce deployment on a shared folder on the seever. On my PC, the application works fine where the VS2005 is installed. But when I tried to install and run the application on an end user machine , it gives me the following warning: "Unable to install or run the application. The application requires that assembly Microsoft.SqlServer.ConnectionInfo Version 9.0.242.0 be installed in the Glocal Assembly Cache (GAC) first." how can I solve this problem Thanks in advance Regards, Make sure that the client has .NET Framework Version 2.0 installed and the latest MDAC I'm having the same pro ...Show All
andrew jones14 connection to FTP server
I am trying to connect to a FTP server using the FtpWebRequest class in visual basic 2005. Right now, I am merely trying to get a list of files on the server. I have the IP address, the username and password to the server. I also had to install a certificate in my browser. I get a "The specified network password is not correct" - error when trying to test the code. I get it after the Client certificates statement. Public Shared Function ListFilesOnServerSsl(ByVal serverUri As Uri) As String Dim username As String = "username" Dim password As String = "password" Dim retStr As String = "" ' The serverUri should start with the ftp:// scheme. If Not (serverUri.Scheme = Uri.UriSch ...Show All
TSZ Code to Convert numbers to time
I hope I am in the correct forum it is my first posting I have a database which has three fields for Hours Minutes and seconds these are just numbers and have no relation to time. I need in a report,code that will convert the numbers to time and add the seconds to minutes and add the minutes to hours. Thanks Bartley Brendan: I have been looking for you for about 15 years without success. Please reply. John P. Sanger Spotty The report is created in access and the deatils are just variables in the database. Thanks Bartley What are you using to create the report. Crystal or something else... Are your values coming from a SQL Database or are they just variables in your application. ...Show All
minkee.s Serial Port probelms
Hi, I have a phone connected to COM1 on my laptop via a serial cable. I am trying to send the string ATD01234 but the phone will not try and make the call using my program. The phone responds, (makes the call), when I use Hyperterminal, (on COM1) and when I use my own program I get a response using a USB cable (COM4). Any clues as to why this is not working Below is the code I am using: Public Class Form1 Dim WithEvents serialPort As New IO.Ports.SerialPort Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load SerialPortNames() End Sub '------------------------------------------- ' Populate combobox with COM ports '------------------------------------------- Private Sub Se ...Show All
danni123 How do I copy bitmap data to a buffer?
I have an application that displays some images using PictureBox. There is a requirement to toggle between colour and monochrome or grey-scale versions of the image, so I've created a class derived from PictureBox that contains extra bitmaps that hold the various versions of the image, and then when the user switches between them, I just assign the relevant bitmap to the PictureBox. When the image is first loaded, the application generates the monochrome and grey-scale versions from the loaded colour version. This is where the problem lies. For each version of the image, I make a clone of the original, and then loop through X and Y, using GetPixel and SetPixel to change the colour based on a conversion formula. That also works ok, b ...Show All
