ChrisPadgham

you will need to provide more info. Can you provide the code.

isn't your SQL wrong, shouldn't it be INSERT INTO empinfo (empname) VALUES ("???") you will need to concatenate in the actual emp name instead of the ???

probably something in cloud technology would be good, it is quite hot at the moment

At the stage you are at, you need to focus on develop the data model (database design) for your application, the programming will come later. Think about what data you want to store and a relational data model that could be used to represent that data.

so what is the database and how are you trying to back it up

and what does this have to do with computer science, looks more like pure mathematics to me

you never reset current, after the first pass of the inner loop and it is sitting at the end of the list and it is not reset for the subsequent pass

Sounds to me like you need a web service, time to check with the website owner whether one exists or if one can be created. Assuming there is one, the owner of the website should have documentation on how to utilise it.

for a start shouldn't it be DESC not DEC and if you are talking to MS SQL Barcode ID cannot have a space in it, eg BarcodeId if you are talking to MSAccess then it needs to be inclosed in square brackets [Barcode ID]

install the software and plug it in. Data coming from the barcode reader appears to your program as if the user had typed it in on the keyboard

As Waltp says, if you want to replace the whole contents of the text box or if you only want to replace a substring in the text box text1.text = replace(text1.text,"original","new) Replace function [URL="http://msdn.microsoft.com/en-us/library/aa241892(v=vs.60).aspx"]documented here [/URL]

should local host have a period after it

This forum is really about helping with technical problems not doing your work for you. Micrsoft have some very good on line tutorials which you can do that will teach you these things.

a web app is accessed through a browser, a window application is a stand alone program that runs on the PC

Can you explain more about your application and what you want to achieve (not how you want to do it) There may be another solution to your problem

i wouldn't bother doing it. Save the image in the file system and it's pathname in the database, you will save yourself a lot of problems later.

so are the wrong records being selected or is it the correct records and the wrong data in the record

[CODE]dim TwoDArray(10,10) as Int16[/CODE]

you can use DOMdocument to process XML in VB, you use the method LoadXML(pathname) to load and there methods and properties to iterate through the XML file. A quick google search will show you how.

hmmm not really fully normalised though. How many Min/Max power combinations could you have? not that many I would have thought. If you are going down this path, why would you not just store the price rather than the Bracket id in the Wiring table. then you would not need …

Make it the Primary Key then set it to autoincrement and the database will assign an id for you, no need to worry about it in the code.

you are in the wrong section, this is a Visual Basic discussion group

it looks very much like an third party library, go to add-ins menu and click Add-in Manager, see if you can find something that looks like this to add to the project.

The problem is that you are trying to change standard windows behavior which is not good for the usability of your program, people will find it difficult to learn and use if it does not behave in an expected manner. Perhaps you can think about an alternative approach to achieving …

Rather than calculating the Duration possibly [CODE] appointmentTime = starttime do until appointmentTime >= endtime cmbTime.Items.Add(appointmentTime.ToString) appointmentTime = appointmentTime.AddMinutes(AppointmentDuration) loop [/CODE] note that if Appointment duration does not divide evenly the last appointment will overrun the end time. If this is not acceptable you will need to add the AppointmentDuration …

Are you referring to a FileOpen dialog box

This forum is not really designed to do your homework for you. Do the design and if you have a particular problem with it someone will help you.

[CODE] myquotedstring = chr$(34) & "My name is Rick" & chr$(34) [/CODE]

one reason that it happens is that removing redundancy means that the redundant fields need to be recalculated each time they are required. take for example InvoiceTotal, the value is redundant because it is simply the sum of the InvoiceItem values. This means that instead of holding an Invoice Total …

The jet engine is single threaded so if one process is holding a lock everything else will wait. It is quite OK where there is not a great number of concurrent users but it becomes problematic with the number of concurrent users rises.

The most robust way is to import the data into a staging table, each column in the staging table is text 255. Do your validation there before inserting the data into the product table. Alternatively you could open the excel spreadsheet as an embedded object and work through it cell …

I know this is not what you asked but if you just want to check if it is a valid date then you can use the isdate() function.

I don't think peek is the correct method, you should something like .readline or .readalltext also your code is processing 3 rows and 2 cols but your data is 2 rows and 3 cols

i think line 13 should be cmd.commandText = strCommandText & Values

Can a purchase order have more than one product on it. if not, put a foreign key (ContractId) in the tblPurchaseOrder table. if so, put a foreign key (ContractId) in the tblPurchaseOrderLine table.

AND will only return one record if there is only one record matching the where clause. If you have multiple rows that match you will get multiple rows back, for example if your table holds the following data FLD1 | FLD2 | FLD3 XXX | 111 | A XXX | …

If you have not written C before then I think you will find VB easier and faster

Can I question why you want to take a screen shot. Presumably the data on the screen is derived from information stored on the webserver, why not just build a report of that data and email that.

Yes since incident has a many-to-one relationship with student you need a separate table to hold incidents (probably called something like "Incident"). Personally I prefer an autonumber field as a primary key of the Incident table, say IncidentNo. StudentId should be included in the Incident table as a foreign key.

Well for a start you will need a relationship between Employee and User if they are not the same thing. Can you have users who are not employees, if not dump the User table and store the UserId and Password in the Employee table. The Bill will not only require …

Possibly the simplest solution then is to install a serial port (RS232) on your PC Otherwise check if the supplier has provided an API or ActiveX control than you can use to talk to the device

in the bottom example shouldn't you be using the alias sndPlaySoundA in your call

I presume the image path is stored in the field imagem_box.Text are you saying that when you execute the insert command the data in column imagem_curso does not contain the forward slashes

Check whether maximizer uses a relational database to store its data, if it does you may simply be able to link the tables in you database to extract the data.

another approach is to compare to a formatted string something like format$(tranDate,"mmm-yyyy") = "jan-2012"

This is one of the most obvious applications for the use of recursion but it is not really for the faint hearted. As WaltP says this needs some design however in simple terms you write a subroutine that takes a folder as an argument. the code in this subroutine processes …

The EXE you are refering to is the program executable I presume. You will need to create an installation EXE that packages up all the files you want to distribute. Installshield seems to be the product of choice for this purpose these days

Actually in Access 2002 I think you will need to use * as your wildcard not % As mentioned above by autocrat you first need to establish your data model. Probably something simple with two tables the first containing a list of phone functions and a description field. The second …

you need to use the isnull or nz function for example [CODE] If not isnull(tradeReceivable) Then sqlStr = sqlStr & " receivable = '" & CDbl(tradeReceivable) & "'," End If [/CODE] if the value of tradeReceivable is null then you do not need to include it in the SQL it …

I think you need a new entity called something like Roster that contains WardNo, Nurse, Date Also since it is a hospital you probably need shift in there as well since there will be at least 2 shifts per day and obviously the supervisor needs to be on the same …