why not make function that will open another program which will create a database?

weel theres a function to let the user select a directory, used it to where you save you database to be created. you can also use that to open the database. I think the control is Dialog, opendialog...

you will add a code during runtime? I don't know it its possible but to make a work around on that... make a code/function that will be soon called of the control you will be going to add. You can...

check the fields if it allows null value. if not then put a trappings to force the user to enter a value on the field.

ooops! sorry, please omit the Set keyword or maybe not, I forget its years when I stop vb6 but anyhow it must be that way. Do you know how to use a recordset? You pass a query then the recordset will...

Dim rs As Recordset

Set rs= deSub.conn.Execute("SELECT clientnumber FROM individualsubs WHERE firstname = '" & txtfname.Text & "' AND surname = '" & txtsurname.Text & "'")Set ri =...

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?

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.

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?

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/

yEAH! I agree with Qveen, used the hide button then make a global variable that stores the name of the form...