Yes I discovered that previously. What I want to do is to create a multiple user access inside the excel sheet.

Hello, I wanted to develop a code in VB inside MS Excel that allows the user to select his name from a drop down menu placed in an Excel Cell. Then the code asks the user for a password against his username and further unlock selected columns for him to edit. I have created a drop down list via this help: http://spreadsheetpage.com/index.php/tip/create_a_drop_down_list_of_possible_input_values/[^] How to proceed further for asking the user for a password?

I created a reference to a file at some location in the hard drive in a vb.net application.

db_optb.Image = Image.FromFile("F:\Documents and Settings\Raza\My Documents\My Pictures\quiz_pics\opt_bg_post.jpg")

The program executed fine. But when i took the whole project folder to another PC and executed it there it gave a 'File does not exist' exception. Definitely the file was not there in this PC. So can place the file in the project and refer it in such a way that taking the project to any other place does not create problems?

I want to read a sentence from a textbox characterwise and as soon as the space character comes the prevoiusly occured characters are to put in a label. I am having problems in array data types. Here is the code. Private Sub file_open_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles file_open.Click Dim count As Integer = 0 Dim objreader As New System.IO.StreamReader(file_name.Text) TextBox1.Text = TextBox1.Text & objreader.ReadLine & vbCrLf Dim myArray1() As Char = TextBox1.Text.ToCharArray() Dim myArray2 As List(Of Char) = New List(Of Char) For Each c As Char In myArray1 If c <> " " Then myArray2.Add(c) Else id.Text = myArray2() ' here is the issue Exit For End If Next End Sub

I have written a code to read a text box character by character and copy the characters into another array. As soon as the space character occurs the process should stop. the Program is giving argument null exception at runtime. Any solutions. Here is the code. Private Sub file_open_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles file_open.Click Dim objreader As New System.IO.StreamReader(file_name.Text) TextBox1.Text = objreader.ReadLine TextBox1.Text = TextBox1.Text & objreader.ReadLine & vbCrLf Dim myArray() As Char Dim myArray2() As Char myArray = Me.TextBox1.Text.ToCharArray For i As Integer = 1 To 70 If myArray(i) <> " " Then Else Array.Copy(myArray, myArray2, i) End If Next End Sub

I have written a code to change the back color of a label twice during execution to give it an animation effect. The idea says that :

when the button is pressed change the color from black to red.
Then a null loop is placed to create some delay and then the color changes back to black.

<pre lang="vb">Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
box.BackColor = Color.Red
For delay As Double = 0 To 900000000 Step 1
Next
box.BackColor = Color.Black
End Sub</pre>

But its not performing as desired. The label doesnt become red and i doubt the program is executing the delay first. Any idea whats the issue?

I have written a code to give a sliding effect to 5 command buttons. It runs fine with default background but when i change the opacity of the form OR put a picture in the background it behaves slower rather much slower than what it does normally. What might be the issue? Any ideas to resolve it. Here is the code.

Public Class Form1
Dim slidevar As Integer = -10
Dim slidevar1 As Integer = -60
Dim slidevar2 As Integer = -120
Dim slidevar3 As Integer = -180
Dim slidevar4 As Integer = -240
Dim delayvar As Integer = -300
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    Button1.Location = New Point(-1000, 10)
    Button2.Location = New Point(-1000, 80)
    Button3.Location = New Point(-1000, 120)
    Button4.Location = New Point(-1000, 160)
    Button5.Location = New Point(-1000, 200)
End Sub

Private Sub Button1\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

End Sub

Private Sub Button\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button.Click
    slidevar = 0
    slidevar1 = 0
    slidevar2 = 0
    slidevar3 = 0
    slidevar4 = 0

    Button1.Location = New Point(-1000, 10)
    Button2.Location = New Point(-1000, 80)
    Button3.Location = New Point(-1000, 120)
    Button4.Location = New Point(-1000, 160)
    Button5.Location = New Point(-1000, 200)
    Timer1.Enabled = True


End Sub

Private Sub Timer1\_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick


    If slidevar < 65 Then
        Button1.Location = New Point(slidevar, 10)
        slidevar += 6
        If slidevar4 > 65 Then
            Timer1.Enabled = False
        End If
    End If


    For delayvar = 1 To 100
    Next

    If slidevar1 < 65 Then
        Button2.Location = New Point(slidevar1, 80)
        slidevar1 += 5
    End If




    For delayvar = 1 To 100
    Next
    If slidevar2 < 65 Then
        Button3.Location = New Point(slidevar2, 120)
        slidevar2 += 4
    End If


    For delayvar = 1 To 100
    Next
    If slidevar3 < 65 Then
        Button4.Location = New Point(slidevar3, 160)
        slidevar3 += 3
    End If


    For delayvar = 1 To 100

I have created a VB.NET app, a small mcq based quiz. Now when i run it on a different resolution than my PC then all the items(labels,textboxes etc) on the form get scattered. How can we create resolution independent applications?

In windows forms application we used to add a data source to the application and then dragged & dropped the fields to the application, that worked fine. I tried the same in the WPF app but it's not dragging it there on the window. Can we use the windows form data binding method in wpf or is there any other procedure?

I am trying to show another window using the visible property as: Window2.Visibility = Windows.Visibility.Hidden I have written the command in window1 on a command button. But its giving an error "Reference to a non-shared member requires an object reference." Any solutions??

I have created a simple web application and published it to the local host, running fine there. Now when i upload the same files present in the Inetpub/wwwroot folder, to my FTP Site and open the Default.aspx page, it shows the html code instead of the application. Any Idea whats going wrong?

I created a simple aspx page on Visual Studio 2008 Web Developer using VB. It had three textboxes and a command button and used to do some calculations upon the given data on pressing the command button. It worked fine when debugged and run. Then i created a html page and made a simple hyper link to the aspx page. The link is opening the page but not displaying its contents but displaying the code instead. Any Solutions??? Visit www.raza.najam.com.pk and click the ASP Page.

I am developing a web application in ASP.NET using Visual Studio 2008. I am developing it in .NET framework 3.5. Now is it necessary for the users to have .NET framework 3.5 installed on their systems?

I wanted to ask this way. I have a query for my data grid view as: SELECT ID, Name, City, Fee, Technology FROM [uni list] WHERE (Name = 'Data') where data is used as a string and this works fine BUT.. When i refer the filter case to a textbox it doesn't work. It takes this whole thing as a string and not producing the desired results. SELECT ID, Name, City, Fee, Technology FROM [uni list] WHERE (Name = '[text].textbox1') How can this be resolves

Can we use the text of a textbox as a query filter in VB? If yes how?

I have an access table containing several records. Infact records of universities alongwith their fee structure. The task is to sort out the universities according to a given range and display that list in VB 2008 form. Has anybody got any reference regarding this?

I have several group boxes on top of one another but the problem i am facing is their merging with each other. How can it be avoided?

I have a biodata form containing lots of text boxes for entries from the user. Has anybody got any idea or reference that how can i transfer this data to a MS Access Database?

I have this stuff in my "FontStyleSheet.css" but stilll the font is not Calibri on the site. I have the .ttf file in the root folder as mentioned here. // @charset "utf-8"; .FontStyleSheet { font-family: Calibri; font-size: 12px; } @fontface { font-family:Calibri src: url("C:/Users/Raza/Desktop/IEEE test/Calibri.ttf") } selector { font-family:Calibri } //

Kindly let me know the difference between Visual Basic and VB.Net.