Thanks, I did see that but didn't realise the menu changed when you clicked the CSS menu you wanted until I went on the link again, that will be perfect. In the end we're all just the same

Thanks Peter, will try that. In the end we're all just the same

You can still do it the same way you did it 4 years ago using ADO.NET. If this is not legacy data, by that I mean you can change the structure without breaking other applications, merging this data into one table will make life a lot easier. Create a Family table with Id and Name fields. Then create another table called Shellfish with all the same fields and include a FamilyId field. Then insert the records from the other tables. You can do this by creating queries in Access. The reason I suggest this is because it will make developing your UI a lot easier. Normalising the data schema will make a huge difference. Also is there any requirement for the data to be stored in Access? Access has an upgrade wizard which will make it easy to convert to a SQL Express database. This will enable you to use Entity Framework which will make development quicker if you don't include the learning curve. Once you have done that, filling your ComboBoxes, ListBoxes, TextBoxes etc., will be a piece of cake. If it is a legacy system you are probably resigned to cutting a lot of code in your Data Access Layer to replicate what I have mentioned above using ADO.NET. FamilyListBox.DataSource = myData.GetFamilies(); ... private void FamilyListBox_SelectedValueChanged(object sender, EventArgs e) { CommonNameListBox.DataSource = MyData.GetShellFish(); } private void CommonNameListBox_SelectedValueChanged(object sender, EventArgs e) { ShellFish shellFish = CommonNameListBox.SelectedItem as ShellFish; CommonNameTextBox.Text = shellFish.CommonName; ... } You will also need to set the DisplayName property for the ListBoxes. Hope that helps but it is a hard question to answer in a few words. "You get that on the big jobs."

Hi, 10 milliseconds, yes that's what I meant, I wanted the progress bar to go up 1 every 10 milliseconds until it hit the maximum value then stop, btu the timer stop isn't working. The timer doesn't appear to stop, or I think the way I have the code, its won't stop as it trying to go one higher than the maximum value of the progress bar and not stopping when it gets to maximum value. I just was not sure where to put the timer stop code so that the timer would stop when progress bar gets to its maximum value, I think this way it will stop when it gets one over its maximum value, which it can't do. In the end we're all just the same

Hi, I was using Microsoft Expression Web 2 to do this In the end we're all just the same

Dot't use style.visibility = 'visible' use style.display = 'none' Rating always..... WELCOME Be a good listener...Because Opprtunity Knock softly...

Dave McCool wrote: I would like below the image text saying what the species is and when you click the text (want text to be hyperlink) it's like this ... Dave McCool wrote: var theImages = new Array() Dave McCool wrote: theImages[0] = 'Images/Nepticulidae/Stigmella_Aurella/Stigmella_aurella_Adult1.jpg' theImages[1] = 'Images/Lasiocampidae/Drinker/Drinker_Moth_Adult_Male1.jpg' var theImages = new Array() ; var theText = new Array() ; var theLink = new Array(); theImages[0] = 'Images/Nepticulidae/Stigmella_Aurella/Stigmella_aurella_Adult1.jpg'; theText[0] = "This is a butterfly?"; theLink [0]= 'HTMLfiles/Nepticulidae/Stigmella_Aurella.html'; theImages[1] = 'Images/Lasiocampidae/Drinker/Drinker_Moth_Adult_Male1.jpg'; theLink[1] = 'HTMLfiles/Lasiocampidae/Drinker.html'; theText[1] = "This butter is fly?" Dave McCool wrote: function showImage(){document.write('<img src="'+theImages[whichImage]+'">');} function showImage(){ document.write('<table><tr><td>'); document.write('<img src="'+theImages[whichImage]+'">'); document.write('</td></tr><tr><td>'); document.write('<a href =' + theLink[whichImage] + '>'); document.write(theText[whichImage]); document.write('</a>'); document.write('</td></tr></table>'); } this is very close to what you are asking

Thanks, your right. I'll see what I can do, I know IE is annoying. Its just that the tex seems harder to read this way and if people find the text a bit hard to read, they won't stay long. I'll see what I can do. In the end we're all just the same

Hi Dave, First, for stage, prefer a drop down list to choose the stage and the results change accordingly, just show one type of stage, say a table showing the Pieris Napi at adult stage only. What you suggested on having a drop down list to chose the scientific name would be far better, how would I do this so you can choose what you want proir to creating the table, would an input form work best for this, choose the scientific name and stage on a small form then press a button to take you to a chart on that species. I know how to create the form, but not how to get the information onto a chart Havn't used much with charts or inputting data except on tables latley, so I am a bit rusty. In the end we're all just the same

Hi Dave, Thanks for the info it was useful, sorry for late reply In the end we're all just the same

Create a stored procedure in your database and send the textbox values as parameters or build a query in your code and perform insert/update using Command object. जय हिंद

You should do something like that: Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged Dim txt, SQL As String txt = Me.TextBox1.Text.Trim 'you should connect to DB only if lenght is greater for example 3 If txt.Length > 3 Then SQL = "select EMP_ID from EMP_TABLE where EMP_ID like '" & txt & "%'" Dim dt As DataTable 'call some your function that returns datatable or. write code here 'dt = getDatatable(SQL,"SOMETABLE") If dt.Rows.Count = 0 Then MsgBox("This employee does not exist") End If End If End Sub

try following code If Directory.Exists(path) Then 'path contains the path of directory Dim dir_info As New DirectoryInfo(path) Dim file_infos() As FileInfo file_infos = dir_info.GetFiles("*.mdb") End If hope this helps Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

Here i search the table and display data in the Grid http://www.codeproject.com/KB/cs/N-Tier22.aspx[^] Is this Similar to what you want ? Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

Dave McCool wrote: Any ideas? Any ideas for what? That's all basic fundamental programming stuff. led mike

I have the array almost completed and stored array code in module (Bits of the code here): Public txtRemainingBalance(10) As String Public txtCustomerName(10) As String Public txtAddress1(10) As String Public txtAddress2(10) As String Public txtAddress3(10) As String Public txtRegNo(10) As String Public txtCarModel(10) As String Public ComboBox1(10) As String Public txtPurchasePrice(10) As Decimal Sub CalltxtCustomerName() txtCustomerName(0) = "Not Defined" txtCustomerName(1) = "Not Defined" txtCustomerName(2) = "Not Defined" txtCustomerName(3) = "Not Defined" txtCustomerName(4) = "Not Defined" txtCustomerName(5) = "Not Defined" txtCustomerName(6) = "Not Defined" txtCustomerName(7) = "Not Defined" txtCustomerName(8) = "Not Defined" txtCustomerName(9) = "Not Defined" End Sub Sub CalltxtAddress1() txtAddress1(0) = "Not Defined" txtAddress1(1) = "Not Defined" txtAddress1(2) = "Not Defined" txtAddress1(3) = "Not Defined" txtAddress1(4) = "Not Defined" txtAddress1(5) = "Not Defined" txtAddress1(6) = "Not Defined" txtAddress1(7) = "Not Defined" txtAddress1(8) = "Not Defined" txtAddress1(9) = "Not Defined" The "Sub CalltxtCustomerName" and similar names just hold the "Not defined" text that displays when array is run. On my third form, I have list boxes that display whats in the array in listboxes. Here is the code on the display button on that form: ListName.Items.Clear() ListAddress1.Items.Clear() ListAddress.Items.Clear() ListPostcode.Items.Clear() ListCarReg.Items.Clear() ListCarModel.Items.Clear() ListCarCost.Items.Clear() ListCarMake.Items.Clear() Dim i As Integer For i = 0 To 9 ListName.Items.Add(txtCustomerName(i)) ListAddress1.Items.Add(txtAddress1(i)) ListAddress.Items.Add(txtAddress2(i)) ListPostcode.Items.Add(txtAddress3(i)) ListCarReg.Items.Add(txtRegNo(i)) ListCarModel.Items.Add(txtCarModel(i)) ListCarCost.Items.Add(txtPurchasePrice(i)) ListCarMake.Items.Add(ComboBox1(i)) Now, all I want to do is on the form 1 and 2, make a button that stores whats in the text boxes and addes it to the index of the array, txtAddress1, txtAddress2 etc.. and a

Thanks, but I am not 100% sure how to do this. I took out the code so it looks like this: Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click If txtIntrest.Text = ("") Then MsgBox("Please Enter Intrest Rate", MsgBoxStyle.Exclamation) Exit Sub End If If Not txtIntrest.Text.Equals(myline) Then Dim pass As String = InputBox("Enter the Password", "Enter Password", "", ) If pass = "Password" Then Dim intrest As String = InputBox("Enter The New Intrest", "Enter Intrest Rate", "", ) txtIntrest.Text = (intrest) Dim theFile As FileStream = File.Create("ir.txt") Dim writer As StreamWriter = New StreamWriter(theFile) writer.WriteLine(txtIntrest.Text) writer.Close() theFile.Close() Exit Sub End If End If End Sub So the password box just closes when the wrong password is input. I want the password box to keep displaying istead of closing and if you type password wrong three times, this code to execute: MsgBox("You have had three attempts to input password, Program will now close for security reasons", MsgBoxStyle.Critical) Application.Exit() but I was told I could do this with a loop, but was not sure how I had code: Static passnum As Integer Do passnum = +1 Loop Until passnum = 3 but was not sure where to put it so it worked, any ideas? In the end we're all just the same

I got that to work, just changed "Dim oForm as Form" to "Public oForm as Form", thanks. Now how would I remove all items I added to combo box without removing all items? Also, when you click button, I want the combobox to focus on the new added item In the end we're all just the same

depends on what you want say you have 2 forms frm1 and frm2 frm2 is opened by clicking a button on frm1 then you can hide frm1 like you are doing without problems now from here it depends on what you want if you want both forms to close when the user presses the close button from frm2 you use application.close if you only want frm2 to close you use me.close (and bring frm1 back out of hiding) use the frm2.close event to do this hope it helps If my help was helpfull let me know, if not let me know why. The only way we learn is by making mistakes.