a_jam_sandwich

When you create you deployment you can do all the above from (File Types) when creating your setup file. Andy

To use the streamwriter you first need to create a new instance of it before writing to. where you declare the streamwriter replace with this Dim flwriter As New IO.StreamWriter("c:\jmyfile.txt") and remove line 3 'flwriter = File.CreateText("c:\jmyfile.txt")' Now it should work Andy

SQLConnection.ConnectionString = "data source=xxx.xxx.xxx.xxx;initial catalog=databasename;persist security info=False;user id=username;Password=password;packet size=4096" xxx.xxx.xxx.xxx is either the ip or servername username is your login in your database password is your password in your database Andy

Have a look at my report editor on my site. Its still work in progress but for what u want it should be fine there is the DLL and an example all source included Have a look Andy

Access97 was easy but 2000+ is a lot harder. Its a case of scanning through dictionarys or using a brute force approch of trying different letters to try and break the code. My suggestion is make a Access2000 database with a lengthy password containg letters and numbers. Andy

Ive got both installed never had a problem with either Andy

Cheers for the replys it is as I thourght so I did some tests turns out the insert of 100,000 records can take place in 2.1 minuites so all is not too bad. Andy

Im currently writting an application for mailing and I need to insert 100,000's of records every few days into the SQL Server 2000 database. Is there a very very fast way for me to insert these into the database application? I know about the bcp.exe for importing but is there another way using .NET Cheers Andy

same for anything that is a parant to other controls these inc Groupbox, panel... Andy

FTP. do a search for FTP Class there is some threads should give you an idea Andy

Are you trying to run the application install from a web server? If so check if the file is located in the correct place, from the example above in the root of the webserver. If not and you want to run the file from a shared resource then you need to enter the following '\\computername\appname' Hope this helps Andy

@@IDENTITY Works fine in access2000+ Dim MyConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "/Allt I Allo.mdb;User ID=Admin;Mode=Share Deny None") myConnection.Open() Dim MyCommand As New OleDbCommand("INSERT INTO test (hej1, hej2) VALUES ('hej3', 'hej4')", MyConnection) ' This is your missing command your need to run the INSERT Query before getting your ID MyCommand.ExecuteNonQuery() ' Get the Last INSERT ID MyCommand.CommandText = "SELECT @@IDENTITY" MsgBox("Last ID was : " & MyCommand.ExecuteScalar()) MyConnection.Close() MyCommand.Dispose() Andy

Make sure you set the KeyPreview property on the form to true for the keydown event to function Andy

VB.Net, VB6, Delphi, PHP Andy

How about removing the column and reinserting it. Andy

Well check the regional settings in Windows control panel and set the date to the desired format Andy

Had that a few times reinstall the Framework fixed it right up :) Andy

Sorry Hog been preocuppied with playing games DOH!, but i must add Day of Defeat is great. Anyway to load an XML file into dataset see below Dim MyDataset As New Dataset Dim MyXMLReader As Xml.XmlTextReader = New Xml.XmlTextReader(Application.StartupPath & "\MyXML.XML") ReportDataset.ReadXml(MyXMLReader) MyXMLReader .Close() ' And now it in the dataset Table(0) Hope it help m8 :) Andy

What code are you using cause ive never had problems :) Andy

When ever im loading configs from XML what i tend to do is load it into a dataset read whats needed from within the dataset then dispose of the dataset. Andy

As long as you have IIS5 And the net distribution it will work fine. And VB6 and ASP.NET talking to your SQL Server is fine Andy

Yes it an access command Andy

Why dont you set the format of the date in the SQL? e.g. SELECT Id, Format([Exp_Date_e],"dd\/mm\/yyyy") AS MyDate From MyTable Andy

Just create a control that you define a 2 dimentional boolean array to hold the screen. You can indivually turn point of the screen on by giving then a true value e.g. Screen(10,10) = True Remember you have to write the onscreen paint as well. Andy

Then you have a tedius task you will have to define each letter and draw them on your form as and when needed you will also need to define the form as a grid system so you no where to draw from. Andy