ChrisPadgham

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.

Please start your own thread if you have a problem

I think it is important for you to get a start, once you have got something, if you have a bug you can't find, post it and someone will help you.

didn't you also ask this question in the VB.Net forum, which are you using.

Sorry I missed the additional pages

Why do you have the details in a second table. It doesn't look like you need it, just move all the fields in the details table into the Customers table. If you wish to persist with the design you have then the insert into customers table at line 7 does …

is this access or excel you are talking about

I don't think this approach can handle strange charaters in the password like ( or ). Check that your password only contains alphanumeric characters.

[CODE]SELECT Materials.Item_Name, Proj_Mat.qty FROM Materials, Proj_Mat WHERE Materials.Item_Code=Proj_Mat.Item_Code AND Proj_Mat.Proj_Id=CurrentProjId[/CODE] CurrentProjId is obviously the project you wish to report on

30 is pushing it a bit for MSAccess but in theory you should be OK. Just use one table and one form. Given the number of concurrent users I would be inclined not to use bound fields. Instead have a save button which builds an SQL INSERT statement to insert …

if you want to write for Apple devices you will want to learn Objective-C

Please start your own thread if you have a new question

what technical documentation do you have on the gateway

In the click event of the combo box set a filter on the form [CODE] Public sub combo1_click me.filter = "StudentName='" & me.combo1.text me.filteron = true end sub [/CODE]

look on itunesU for iPhone programming by Paul Hegarty of Standford University. His on-line lectures are free and explain this well.

See here for connection strings for mySQL databases [URL="http://www.connectionstrings.com/mysql"]http://www.connectionstrings.com/mysql[/URL] create you own database with a name that is relevant to the application you are developing

please start your own thread in the appropriate forum

the forum is about solving problems that you are experiencing. Do your design and if you have something you can resolve, post it and someone will assist you.

This is a duplicate is it not.

I don't think a listview control is what you want. I think it would look more like a normal question screen if you had an array of radio buttons. On your form, place one radio button, then copy and paste it, VB will ask if you want to create a …

so where is the code that establishes the adodc2 recordset and what is the error you are receiving