ChrisPadgham

the view out of MVC is the GUI. it is basically about separating the data model from the user experience, with the controller managing the interaction between the two.

I think you will need two "End If"s, as one is missing that matches line 15

check to see if you have a default value specified, both for the textbox and for the field in the database

please start your own thread if you have a question.

Here is a link to some free unicode controls for VB6 they may help, [Click Here](http://www.vbforums.com/showthread.php?p=3261531#post3261531)

if may work for the first 14 days of the month but if it is currently 20th of June then adding 15 will give you 35th of June which not many people have as a birthday. Try adding 15 to the getdate with the dateadd function before using day function …

see an example here [URL="http://www.codeproject.com/Articles/24234/ActiveX-Control-to-Use-DataGrid-in-VB6"]http://www.codeproject.com/Articles/24234/ActiveX-Control-to-Use-DataGrid-in-VB6[/URL] once you are underway with your code, if you have a specific problem post it and someone will help you.

Just map the drive with the database on it to each computer. Link the tables from that database into your application.

what part of Oracle are you interested in

don't think so. if you only have the exe you are in trouble.

as jx_man said you need to hold the amount remaining somewhere else, ie a different table. create a stock table that holds the remaining stock for each item. you need to read this for the item concerned, subtract the amount sold and update it.

Can I suggest you try toad.

esorison, please start a new thread if you have a question. and you need to supply more info than above if you want a good answer

try something like Set fso = CreateObject("Scripting.FileSystemObject") path = "C:\folder1" fso.createFolder path

set focus to the form frmItem.setfocus

if it is connected to an asynchronous port, eg Com1 then simply open it like a file open com1 for output as #1

you will need to provide more details to get help

[Click Here](http://www.regular-expressions.info/)

There are basically two approaches and it is a matter of taste which you prefer. For functions that the user does not have priveleges for you can choose to make the command buttons, text fields etc either disabled - in which case they will still appear but greyed out not …

your use of transactionid as a sort criteria will cause you problems since the transaction you add will have a transactionid out of sequence. I suggest you use date and time rather than just date that way you can select all transactions greater that the date/time of the inserted transaction.

Why not have two listboxes one for name, one for URL, make the second listbox not visible. When they click on a row in the first, select the URL from the second.

You may like to investigate the defaultValue property for the other name text boxes. When they enter the name in f.wholename set > f.FillNameBox1.defaultvalue = f.wholename.value

I think you need [player stop] in somewhere like viewWillDisappear

Try this [CODE] myForm1.setfocus unload ME [/CODE]

[CODE] Dim intCount As Integer = 1 Dim intStore As Integer Dim strStars As String Dim intDividedBy As Integer intCount = 0 Do intCount = intCount + 1 intStore = CInt(InputBox("Enter the sales for store number " & intCount.ToString())) intDividedBy = intStore /100 strStars = intDividedBy.tostring & "*" lstChart.Items.Insert(0, "Store …

select table1.conkey, reg, when, [where], [type], connum from table1, table2 where table1.conkey = table2.conkey it is not good to use keywords as field names, like where and type, consider renaming your fields. it will be worth it in the long run.

In the form load, set focus to your text box. The data scanned from the scanner appears to your program as if the user has typed it in. It is usually terminated with CR so you can place data in the lost_focus event of the text box to 1. insert …

if it is not in the source it is not on the web page, the source being the source of the web page.

Please post the code you have so far, we are not here to write your homework for you.

change the first parameter to be initWithTitle (ie capitalise the W)

replace the or with and (&&)

You have too much time on your hands Jx_Man

well if they are an array don't you have one module that handles events for the textboxes in that array

Nobody has answered because you have not asked a specific technical question. The forum does not supply solutions but if you have written something that does not work someone will help you debug it.

The problem with WIA is a number of scanners don't fully support it (or don't support it at all) I used a product called EZTwain on one site where I had this problem which you might like to check out. You can download a trial version for free and the …

Your post contributes nothing to this thread. Please start your own thread if you have a problem you wish to discuss.

check out the instr function eg if instr(1, stringToSearch, "b") > 0 or instr(1, stringToSearch, "d")> 0 then msgbox "found" end if

if you are talking about ptr1 then it is destroyed when you exit fnCall2 and recreated the next time you enter the subroutine. You cannot rely on it retaining its value.

it would help if you indented your code. lines 6/7 should be below line 15, you can't use the variables until you have assigned them line 19 is wrong, drop the =0 line 23 should be else { line 31 probably should be }

You have created the recordset object at line 2 but you need to assign it an actual recordset using a SET statement Set rs = ......

You can use the isnumeric function do MonthUsage = InputBox("Please enter a monthly usage value") if not isnumeric(MonthUsage) then msgbox "Please enter numbers only" until isNumeric(MonthUsage) MonthlyUsages(usages) += val(MonthUsage)

From memory, I think you also need to set the keypreview property on the form otherwise the keypress will be sent to the control that has focus

There are some good sales and inventory systems on the market, it will end up cheaper and quicker than writing your own

Nice piece of code, I could have used this a number of times, and will from now on.

please post the sql that is not working

line 34 should be [CODE]intGrade = intScore/intPossibleMarks*100[/CODE] that will give you a score as a percentage then you will need a select case statement to assign a letter to the score. something like [CODE]SELECT CASE TRUE CASE intGrade > 85 strGrade = "A" CASE intGrade >75 strGrade = "B" CASE …

are you planning to embed a browser in your application or did you want to shell out.

Looks like just the spot for a bit of recursion. create yourself a subroutine that creates the upper and lower case version of an ordinal position and then have it call itself until you reach the end of the string.

You are missing an [CODE]End If[/CODE] after line 9

I think you should set your start up to Sub Main. Then write a main subroutine that displays your login form modally. When you have validated the user display your first form.