Jx_Man 987 Nearly a Senior Poster Featured Poster

using Focus() function...
try this code :

If DropDown.SelectedItem = "Yes" Then
      TextBox1.Focus() ' If Yes go to textbox1
Else
      TextBox2.Focus() ' If No go to textbox2
End If
Jx_Man 987 Nearly a Senior Poster Featured Poster

yeah, its easier to use listview.

Jx_Man 987 Nearly a Senior Poster Featured Poster

Debug?? debug cannot be execute alone. debug must be follow with Print or Assert.
i think debug.print use to see what the result. i mean it is not using inf form but for debugging.

Jx_Man 987 Nearly a Senior Poster Featured Poster

u mean change the value of what was display on label?
and what the meaning of this :

let say i have value,,,, length is label and 10cm is text box for length in a form

i didn't get the point...explain more detail..

Jx_Man 987 Nearly a Senior Poster Featured Poster

Make a new form to do this. use timer to set how long it will shown.
so after login, Note Form will shown for a few second and disappearing then go to form after login(main menu or other).

Jx_Man 987 Nearly a Senior Poster Featured Poster

you're Welcome...
Don't forget to mark this thread solved.
Happy Coding Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Add in your declaration :

Const MAX_PATH As Integer = 260
EkoX commented: :twisted: +3
Jx_Man 987 Nearly a Senior Poster Featured Poster

set BorderStyle of Form properties to None

Jade_me commented: riht +1
Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

so, its already generated and stored.
so u just load the id from database.

Jx_Man 987 Nearly a Senior Poster Featured Poster

use picture box or image. then use that code to show it.

Picture1.Picture = LoadPicture("F:\Pictures\Icon\CloseX.ico")
Jx_Man 987 Nearly a Senior Poster Featured Poster

Picture1.Picture = LoadPicture("F:\Pictures\Icon\CloseX.ico")

ITKnight commented: working +1
Jx_Man 987 Nearly a Senior Poster Featured Poster

why you don't use Listview...

Jx_Man 987 Nearly a Senior Poster Featured Poster

you mean, display photo from folder?

Jx_Man 987 Nearly a Senior Poster Featured Poster

yeah, i know that. i mean that id pattern.
ex : UK1000
UK1001.

Jx_Man 987 Nearly a Senior Poster Featured Poster

give an example of id?

Jx_Man 987 Nearly a Senior Poster Featured Poster

varCommand = New SqlCommand("insert into tbl_rop values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "',)", varConnection)

Wrong code, where u want to insert?what column Name of table?
eg :

cmdStudent1.CommandText = "INSERT INTO Student(Id, FirstName, LastName,Age) VALUES('" & Trim(txtId.text) & "','" & Trim(txtFirstName.Text) & "','" & Trim(txtLastName.Text) & "','" & Trim(txtAge.Text) & "')"
Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi..
File ->Make YourProjectName.Exe

Jx_Man 987 Nearly a Senior Poster Featured Poster

specify more?

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi i found this code on the web that works but can someone tell my how does this works

u said it works but you want to someone tell u how it works?confusing statement.

Jx_Man 987 Nearly a Senior Poster Featured Poster

if there is 4 column in one table then you're right. as alemzadeh, use SelectedIndexchanged Event to get Key and search on table by the Key then display it in each combobox.

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi..Welcome to Daniweb

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi..Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)
you can post your problem in C Section

Jx_Man 987 Nearly a Senior Poster Featured Poster

hey dude thanks a lot for ur reply. The thing i asked is in this way
In database in register table i stored the following
Firstname abc
Lastname xyz
Username hello
Password hi
From register table i have inserted Username and Password to Login table. So Login table database consists of the following
Username hello
Password hi
Now after connecting to database writing the code and the execution starts.

Login form
Username hello
Password hi
(After this i am able to go to welcome form but it should display saying as follows)

Welcome abc
I hope that you got my point.

what is your effort to do this??where is your attempt?so u want people do your work..

Jx_Man 987 Nearly a Senior Poster Featured Poster

have u a searching procedure?? i mean, you can display on datagrid. post it.

Jx_Man 987 Nearly a Senior Poster Featured Poster

populate each combobox with each table.
use key to search data in every table. so your table must be connected each other.
Now the question :

id
description
ap code
seg code

- it is your database and tables named is Id, Description, Ap Code, Seg Code (4 table) Or it is One Table with column named Id, Description, Ap Code, Seg Code (1 table-4 column) ???which one??

Jx_Man 987 Nearly a Senior Poster Featured Poster

maybe using text file to save setting...

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...welcome to Daniweb Peter :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi Zafar...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi Luke...Welcome to Daniweb Friend :)
visit this following links to learn how to connect access with vb.
- VB And Ms Access
- VB6 Database Guide
Then try it, if u get some problem post it here.
Happy Coding Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Marc :)
Hope you'll see around vb.net section and share with us.

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi GaGa...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Post in vb.net Section, this for vb4/5/6 section.
Thanks friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

how about a simple code to debug us

as a rules friend :
"We only give homework help to those who show effort"
If u have an attempt, we'll longer to give a help and a simple coding as u want for directing, but please you must have an effort first. OK.

Jx_Man 987 Nearly a Senior Poster Featured Poster

dim rpt as new crystalreport1()

what is crystalreport1? crystalreport viewer or a page of report after generating?

Jx_Man 987 Nearly a Senior Poster Featured Poster

COUNT function to count how much record in current column.
SUM function to added all value in current column.
AVG function to get average of all value in current column.
etc...
Well Great to solved your thread by your self.
Happy coding friend :)

Sawamura commented: good explain +1
Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi...Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

Your code is right, none wrong with your code. what i mean is if you post in vb.net please use vb.net code, don't used vb6. i know that both of them is still same. but just use right code in current section. please don't mind it... i m sorry if u get upset with.
Happy coding friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster
Jx_Man 987 Nearly a Senior Poster Featured Poster

Hi Welcome to Daniweb Friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

you're Welcome friend :)
Happy Coding.

Jade_me commented: absolutelly +1
Naruse commented: thx again +1
Jx_Man 987 Nearly a Senior Poster Featured Poster

you're Welcome friend :)

Jx_Man 987 Nearly a Senior Poster Featured Poster

??
hmm...sorry if this code some like yours...
well, i have a book for this.