Recent content by gordonl

I have two form buttons that I want placed one under the other on the web page. I also want these the same length. However, the length if the form button seems to be dependent on the length of the text in it - and since each has a different number of characters in it they are different...

All of a sudden I cannot create an exe file for my visual basic program. All that happens is that it hangs. I have found that when it hangs - if I End Task the C2.exe program in Task Manager, then VB recovers but I get an error message in a log file saying something about Linker problems. It...

I have written a visual basic program that uses SQL statements to pull data from an Access 97 database. The database connectivity I use is ADODB if this is relevant. My question is what data gets passed down the line. I have found if I have a large table with thousands of records then if I...

After a day of messing about I managed to log onto a test NT server using RAS and I found that the exact same program that was taking 10 mins to using the VPN connection, took 30 secs for the first time using RAS, and then 2 secs each other time - even if you shut the program completely down...

Thanks again, I do use ADO commands and not data controls and the database connection is declared as a public variable. So what you are saying is that I should not get vaildated each time?? I tested the program over 56K using RAS on NT server and I am 99.9% sure it worked OK. However, the...

The data itself is only 5,948 bytes so should only take a second or so over a 56K line.

Thanks chiph, Do you a know of a way of overcoming this so you that this delay happens only once at the beginning of a program. At the moment it appears to happen once each Form. However, on some forms it happens once each recordset. I am connected to an Access Database at the moment, presume...

When I try to run my program on a 56K line I have the following problem: I have the following delcared as a Public variable: Set dbconn = New ADODb.Connection dbconn.ConnectionString= "provider=microsoft.jet.oledb.4.0;data source=p:\mro\newsystem.mdb;" dbconn.CursorLocation =...

chiph Thanks that is fantastic - exactly what I wanted. I had been trying to find a method that could tell me if a recordset had been SET, but if it hadn't been and I tried to refernce it I got an error. I then tried the IsEmpty command but it says it only works with strings and integers...

Thanks for your replies. Jeff, you're right I can just set something to nothing even if it has never been set. I never thought of that. I still may have a problem though - if it is a recordset object that may have or may not have been set. If I just set it to nothing when it Has been Set and...

I am trying my best to set all the objects I use to Nothing when a form unloads. The objects I use are ADO recorsets and ADO commands. My problem is sometimes an object is not iniated using the SET statement so when I come to close it I get an error. My solution is just to SET it again as a...

Very Good Peter, Thank you. I have tried it and it now works fine.

I am using VB and Access Database. I am using ADO to connect the two. The select criteria is based on a datepicker control, and because the computer has a british set up, the value of this control is stored as day/month/year. However, when I use this value in an SQL statement it does not work...

I have a form with an OLE container that containes and embeded word document. Does anyone know a way to print this word document from a button on the VB form - and not have to open up the word document and to print it. I also want another button that will save the word document to the hard...

Hello, I am sad you never got any responses to this one, as I have just moved from Access to Visual Basic and would like an answer to this one also. I have found Access can do a lot of stuff easily that appears not to be possible with visaul basic - not without a lot of programming anyway. My...