ChrisPadgham

Approach to what, are you loading the rows into a database?

surely you could have looked this up in microsofts reference material [URL="http://msdn.microsoft.com"]http://msdn.microsoft.com[/URL]

Can I suggest you give it an alias [CODE]SELECT CONCAT( Table_Name, '.', Column_Name ) AS TableCol FROM [/CODE] then use TableCol in your code.

seems awefully hard work. Why don't you just create a new table with the key field as unique and append the existing table, the new table will not have any duplicates

so what do you want to achieve, when they click a letter it returns the names from the file that start with that letter?

is it because the class name and the instance name are the same. how about [CODE]dim frmCustomers as New formCustomers[/CODE]

Read up on linked tables, you can link the tables from one database in the other then use an SQL INSERT statement in your VBA to insert the data. [CODE]Currentdb.Execute "INSERT INTO table_new (F1, F2, F3) SELECT F1, F2, F3 FROM table_old[/CODE]

try [CODE]SELECT Student.StudentNum, Student.FirstName, Student.LastName, Student.Initial, Event.Event, Event.EventDate, Transaction.Status FROM (Student INNER JOIN Event ON Student.StudentNum = Event.StudentNum) INNER JOIN [Transaction] ON Student.StudentNum = Transaction.StudentNum; [/CODE]

the way calculators normally work is that You type the first number You hit + You type the second number You hit = (or plus again) So you need some variables to remember 1. the first number that was typed, 2. the operator that was clicked Your numbers should be …

If a file is being held open by another process there is no way for you to delete it until that process terminates or releases the file.

This appears to be generating HTML, where does Excel come into it.

your zip file appears to be corrupt

if you are saying that the item is to be available in multiple but not necessarily all areas then you need to create a new table call ItemArea, for example. ItemArea (ItemAreaId, AreaId, ItemId) then change the relationship to insert this table between Item and Area in you model.

you can remove line8 by formating your date in line 7 [CODE] IDS = "APCSO" & format$(now,"ddmmmyyyy") & idhand[/CODE]

you need to concatenate the name to the string. The way you have it you are including the literal txtName.Text whereas you want the contents of txtName.text. [CODE]lblMessage.Text = "It looks like cloudy weather today, " & txtName.Text[/CODE]

not to mention that you haven't set the connection string to anything.

Can I suggest you simply install XP rather than windows 7 on the PC.

you are in part thinking of this incorrectly. You are providing two services to your clients; the obvious one, providing your manpower billed on a time basis. You are also providing your availability (or response time if you like), that is your customers have developed an expectation that if they …

why don't you try opening the csv file as a datasource rather than a file similarly the xls and use SQL INSERT INTO myXLdb (col1, col2, col2) SELECT col1, col2, col3 FROM myCSV

what is the problem, what is it producing and what did you expect one thing you might like to look at is J is declared as an integer, IndexOf takes a int32 as a parameter, but it may not matter, VB may to the conversion for you

rows 23 - 37 can be replaced with a single SQL statement [CODE]cmd.CommandText = "UPDATE booking_details INNER JOIN Table_Details ON booking_details.TableId = Table_Details.TableId SET Table_Details.Reserved = "No" WHERE (((booking_details.ReservationId)=" & Id1 & "));" [/CODE] not only less code but it will execute much much faster than manually looping through.

this looks like something you should be doing in your firewall. VB6 is an application development tool

you can get that info from an API call, here is a link that will show you how [URL="http://support.microsoft.com/kb/213267"]http://support.microsoft.com/kb/213267[/URL]

hex is only a way of representing a number for human consumption, they are held in binary after all. What is the data type that is holding the number, is it a text string or an integer. That will determine what your findfirst looks like. Text fields have quotes around …

check out the eval function from the microsoft script control [URL="http://www.devx.com/vb2themax/Tip/18773"]http://www.devx.com/vb2themax/Tip/18773[/URL]

The "database stuff" is one of the first steps, before you understand what data you are going to store and how it is organised you can't really design an application to maintain it. First think of all the data elements you want to collect student name, date of birth, amount …

not that I am not a great fan of VB6 but don't you think it would be more appropriate to tackle your assignment in a more modern language, say vb.net alternatively, it is a piece of cake in MS Access

Have you tried stepping through it in debugger, set a break point at the spot it is adding the "0" on the front and check out what is wrong with your logic or instead of [CODE] f &= ZeroPad(line, 7) & vbCrLf [/CODE] use the format function [CODE] f &= …

you don't need a two dimensional array. Read a name from the file, then loop through the names that you have loaded until you find one that is less than this one. insert the name in the list before this entry. when you are complete read the list from the …

for printing see this post. [URL="http://stackoverflow.com/questions/4268777/how-to-used-print-dialog-box-for-print-a-document"]http://stackoverflow.com/questions/4268777/how-to-used-print-dialog-box-for-print-a-document[/URL]

Either that or, after you have loaded the table, open its tabledef and check the field name of each field, changing if necessary.

So is ByVal the default?

I don't really think that shelling out to a batch file is particularly good. It might be better to write to the printer directly yourself. you can open it as follows [CODE]open PRN for output as #2[/CODE] As far as previewing, why don't you load the lines from the file …

the biggest problem you will have is establishing a unique primary key. They cannot be set from the server because if the server is down you will not be able to add new rows. Possibly the most practical solution is for each client machine to have a unique id. the …

add a button to your form and copy the code you have above to the click event.

Look for documentation on the UPDATE keyword, you use SET with that.

please post what your database looks like, ie what tables does it have and what fields are there in each table.

shouldn't line 4 be AS not S

sounds interesting, let us know what you come up with.

why are you storing the priveleges in a separate table, you could have another field in the Usertbl to hold them. Then change your select to read the priveleges, rather than the count that is there are the moment.

well in the first instance, probably the number should be generated by the database. secondly, this field should have an index indicating no duplicates, eg the primary key, then there is not this situation can occur

If you are writing them out again as text strings why not just declare them as string on lines 10 & 11. If you want to validate then try using the IsNumeric function, ie [CODE]if not isnumeric(dblYearlyIncome.text.tostring) then msgbox "some error" exit sub end if[/CODE]

The problem is you are just swapping the numbers. if you want to insert 7 in front of 3 you need to need to move the numbers in 3 - 6 up one in the array i.e. 6->7 5->6 4->5 3->4 and then put 7 in position 3. note that …

so now is the time to plan your program and write some code. If you experience problems post the code snippet and someone will help you fix it.

you are best to use XML interface DOMDocument to iterate through the contents of this XML file and add to your list box.

The Val function returns the numeric value of a character string. therefore on line 25 the value of the 4th argument will be 0 not "Assembly Design"

try posting your data model we are guess at the SQL without knowing how your data is structured

you don't need to disable the header. In your code before line two put some code like [CODE] if e.RowIndex < 0 then msgbox "Please double click on the cell you are interested in" exit sub end if [/CODE] it is better to provide instructive feedback to your user than …

you can use an SQL INSERT statement eg "INSERT INTO mytable (newname, newamount) VALUES('Fred',25);"

It is hard to believe that you will be able to write something that will search faster than word can if you leave it in word format. If you load the data into a database first then searching on the database will be much faster.