Well I've try also the code below:

Dim openForm As Form = Nothing

For index As Integer = My.Application.OpenForms.Count - 1 To 0 Step -1
openForm = My.Application.OpenForms.Item(index)
...

try to remove the bracket "[]"

If [Store_Barcode]![Barcode] = [Personal]![Barcode] Then

or try to look the value if it is DBNull. dbnull is not a string type in which if you will try to use it...

looks like you are not doing your part! It seems you abused the forums. WE DON'T MAKE ASSIGNMENT FOR YOU. or at least you are willing to pay as what ithelp said? SHOW SOME EFFORTS MAN!

in what line did the error occured?

For intX = 0 To cmbCountry.ListCount - 1
If UCase$(myrs!country) = UCase$(cmbCountry.List(intX)) Then
cmbCountry.ListIndex = intX
...

so does this thread solved?

It depends on what criteria you have for the validation... like if you want the idnumber to be all numbers only, etc...

In your second form make a constructor

Public Sub New(ByVal row As DataRow)
Me.InitializeComponent()

'Add the other initialization here...

End Sub

use a loop that will check the mdichild's forms then close them and then open the form you wanted to open...

For Each frm As Form In Me.MdiChildren
frm.Close()
Next

Dim frm1 As...

add also in your login checking about sql injection or else it will be easily to hack...

can you post your code here?

you can also use database to manipulate the data you needed or save the file in the text file

Module Code:
Public ButtonPressed As String

Button1 Code:
ButtonPressed = "Button1"

Button2 Code:
ButtonPressed = "Button2"

to get what button is pressed...

best way of practice in sql is that if you have a joined tables then use the keyword join (INNER JOIN, LEFT JOIN, RIGHT JOIN ETC...)


Dim sqlSelect As String

sqlSelect = " SELECT MP.name,...

yup please specify waht db you are using and what connection you use, is it either DAO or ADO.

first is what field is your primary key? is it the dept_code or dept_name?



Now, what you want is a little bit complicated WHEN your primary is the dept_code.

Why? because if your primary...

juan dela cruz indeed.

well at least do some homework first before asking a favor sniff.sniff.sniff

Well it's very clear as the sunshine. You have just used the "rs" but not declaring/setting it.

can you show your code here?

here check this out. (http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/ecb3b06e-8e3f-4c0f-9fc3-5e3fd28a852a/)

hey dont be so mean debasis... It seems he want an ERP program. It's huge attari I tell you. coz that's what I'm working on here... cheers.

Try the change event, if there's an cancel property on their parameter then use it. or maybe the mousedown event.

Hi,

If the problem is duplication then you must check first the primary keys. How many primary keys in your table, one, two, or more? OK, suppose you have a table name Employee and have three...

ERP project? what's your problem? can you post it here?

Hi Fellas,

Situation:
1. In your database table i.e customertable have 500 records/rows.
2. A datagrid in a form can shows 100 visible of rows.

"Since the datagrid can show 100 visible rows i...

just make an algo on that then use the conditional statements.

Hey who used this? I don't remember I've replid to this thread. Who the f**k hack my account.

in your timer event deduct the opacity of the label in every tick og the timer then after it was about 50% change the color to black or white then back the add the opacity in every tick until it will...

Move to vb.net forum. well.. try to look at here (http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/758a465b-d36d-4a38-ac73-95fdc5a4df3c/) for the solution

will you must have an inventory table in your database. have a column for "ItemID", "ItemDesc", "QuantityIn", "QuantityOut", "QuantityRemaining"

so you can update now your inventory table...

sorry i didnt read all replies... lol. veena already answered it...

hmmmm. let me say. you have a listbox for the names of persons, ryt? so when you select a person's name i.e. as what you've said is 'matt' then when you clicked the button "Load User Info" other form...

well, you will trigger the timer inside each timer so if 1st timer is going to finish the job the second timer must be enabled in order to run the second timer and so on...

... you mean you want to add the names of the databases in the listbox? or the reply og rombusia is what you needed.

Will as of now I stop using VB6 so I have no VB6 here in my PC. but regarding with your problem I think there's a method or function that indicates the form whether is it activated or not or opened...

In the form load of the form you want to center put this code


Me.Move (mdiMain.Width - Me.Width) / 2, (mdiMain.Height - Me.Height) / 2

can you please put a screenshot of your searchform here. As what you have said you have a multiple criteria for your search, ergo it has a 99% of possibility that it will retrieve more than one...

Welcome to DANIWEB tol...

Can you post your code here, then we'll give you back-up!

if you just remove the data in the listview, and when your listview was not bound in the database, everytime you load the form the data you remove will back again since you dont remove it in the...

Here, hope this would help.

http://www.sql-tutorial.net/