ChrisPadgham

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

in the first instance create a control array of text boxes, put one text box on the form, copy and paste it, VB will ask if you want to create a control array to which you answer Yes. Then past the remaining 13 text boxes. [CODE] randomise for i = …

well I can't see anything referring to an object Employee ID but I am thinking you probably need to move line 18 above line 11. not much point in trying to use drTrans until you have assigned it a value.

have you checked out if you can get the data via a web service in XML, it will be far simpler and more robust to process it that way.

I think you should stay with a traditional relational design if you are planning to implement in a relational database. see below the table to hold bar visits. barsVisited (visitId, PersonId, BarId, DateVisited) the difficuly with your design is that it does not allow questions like "how may people have …

use the datediff function, inspite of its name it handles times as well as dates.

how does someone log in? are you displaying a login form and if so when? if it is in the form load event before you call CreateIdFolder ensure that it is displayed as modal otherwise the form load event will continue processing and not wait for the user to log …

Rather than bothering with a log in screen you may like to authenticate off the windows login [CODE] Function getUserName() Dim wshNet as object Dim sUser as string set wshNet = CreateObject("WScript.Network") sUser = wshNet.UserName set wshNet = nothing getUserName = sUser End Function [/CODE] you can then query a …

This forum does not write you assignments for you. Have a go yourself, if you have a piece of code that you cannot get to work post it and someone will help you debug it.

if you double click on the button it will open a code window, this is where you write the code to calculate the price. If you don't know how to write Visual Basic code here is a resource you could look at [URL="http://visualbasic.freetutes.com/learn-vb6/"]http://visualbasic.freetutes.com/learn-vb6/[/URL]

that is the simplest way

since you have the code structured like it is you will want to place the same piece of code in a number of places, accordingly, it is probably better to put it in a function, line 40 becomes [CODE] lblSalOutput.Text = CStr(assistant + addLoading)[/CODE] then your addLoading function looks like …

at line 24 you should not have VAL function this is to convert a string to a number and room price is an integer. if anthing you shoul probably use Cstr

the scanners I have used simulate keyboard entry. That is, what is scanned appears as if the user has typed it on the keyboard. set focus on a textbox then scan and the data from the scanner will be placed in the text box. it is usually terminated with a …

Can I suggest you look at MS Access in the first instance. It is a good starting point for learning about developing database applications. Whilst the programming is in VB not C# for a new comer it provides all you will need to develop your application.

doesn't sound like a VB.Net problem, I suggest you look at your system config and what else you are running on the PC

please format your code

What are you trying to compare to "xx", are you sure you don't mean [CODE] If mainPath.Substring(0, 2) = "xx" Then[/CODE]

Please ask a specific question. what code have you developed so far?

in itunesu look for stanford university lectures by Paul Hegarty on iPhone development, this is a good start

Doesn't Enabled=False do that

If you have not experience with programming, can I suggest you learn the language first on a simpler problem and work up to this

I think NO, for a start you would probably be violating copyright.

you need to check whether the text box contains anything before you attempt to open it. After line 6 put an if statement [CODE]if textbox1.text <> "" then[/CODE] and after line 9 [CODE]end if[/CODE]

The answer is still the same, once you have identified the offending entry [CODE]ListBox1.Items.RemoveAt(IndexOfSingleItem)[/CODE]

you need to include the join on the user table, something like [CODE]AND a.userId=u.UserId[/CODE]

can you format your code please

[CODE] for i = 1 to 6 OrderMenu(i).ItemName = "" OrderMenu(i).ItemCost = 0 next i [/CODE]

you could try the cursorChanged event

we prefer specific questions here. If you have trouble with some code please post it and we will have a look

they thread is very old, please start your own, however there has been a number of recent posts on barcode scanners it may help to read these first.