Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gordonl
  • Content: Threads
  • Order by date
  1. gordonl

    Form Buttons - How can I align them?

    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...
  2. gordonl

    Is there a maximum VB module size?

    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...
  3. gordonl

    What Data gets transferred using an SQL query and an Access Database

    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...
  4. gordonl

    Time taken to run SQL over 56K line.

    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 =...
  5. gordonl

    Setting Objects to Nothing Problem

    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...
  6. gordonl

    SQL Select statement with dates (British!!)

    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...
  7. gordonl

    Printing an OLE containers content

    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...
  8. gordonl

    Emedding Word document in SQL Server

    I want to store a word document that is embedded into a VB6 form in an OLE container to an SQL server. And then be able to retrieve the word document into an OLE document on a VB6 form at a later date. I can do this easily if the database was Access. Surley then SQL server can to it also?????
  9. gordonl

    Can SQL server store OLE objects (eg word documents)

    I have an Access database that I want to upgrade to SQL server version 7. However, the Access tables store word documents - but I can not see the OLE datatype in SQL server. Am I right in assuming there is no way for SQL server to store such data types. What about SQL server 2000.

Part and Inventory Search

Back
Top