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!

Register Log in
  • Congratulations strongm 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: *

  1. garethn

    How do I set a report to LANDSCAPE!!!

    Do you two know how (or know someone who does) that knows how to set the page on a html based report to landscape....Is it something like this...(it doesnt work) <html> <head> <title>Shop Floor Data Capture</title> <style type=&quot;text/css&quot;> P.breakhere {page-break-before:always} @page...
  2. garethn

    Could not locate registry entry for OLE DB provider 'LTF11'.

    LTF11 was the name of the server I was trying to connect to. i just need to know how to link two servers. need two fields from different dbases on diff servers
  3. garethn

    Could not locate registry entry for OLE DB provider 'LTF11'.

    Three servers - I want to be able to create a view on server A from two tables on Servers B and C. I have tried the following but received this error. Server: Msg 7403, Level 16, State 1, Line 1 Could not locate registry entry for OLE DB provider 'LTF11'. sp_addlinkedserver 'xxx','','LTF11'...
  4. garethn

    Write from TXT file to SQL table . Problem with strings/intergers

    thanks will try that
  5. garethn

    Write from TXT file to SQL table . Problem with strings/intergers

    While Not EOF(1) Input #1, strLine ' I THINK THIS next LINE IS THE PROBLEM ** I need to figure out if its a val or a string some how ???? For x = 0 To UBound(ColumnAttr) 'MaxFields ColumnAttr(x).Value = Val(Mid(strLine, ColumnAttr(x).Pos, ColumnAttr(x).Len))...
  6. garethn

    Write from TXT file to SQL table . Problem with strings/intergers

    Im trying to write from a text file to a table in SQL . Ive dimmed everything correctly (i Think) but when it comes to write the line into the table the code doesnt accept my VALUE as a string....it thinks it is a number...so ignores what is in the text file (which is a char) Private Type...
  7. garethn

    Need to add leading zeros to a variable

    I have a variable (ProductID which currently looks like this 5426 I need to add leading zeros to this field to make it up to 18 chars long...so it looks like this 000000000000005426 currently have the length of the string 'read/loop array For r = 1 To rcount ProductID =...
  8. garethn

    Need to read an Excel spreadsheet into VB as a Record Set ??!!

    I need help opening up an Excel spreadsheet and reading the spreadsheet columns into a records set (as you would with a normal database. Ive got the basic code but Icant seem to get it to work : Dim db As Database Dim rs As Recordset Dim filepath As String Dim sheetname As String Private Sub...
  9. garethn

    Populating SQL table from and Excel spreadsheet

    I need a small bit of code that will open an excel spreadsheet and read through certain cells and return these details back to program. I can then carry out the next steps to write to a an SQL table.
  10. garethn

    Locking rows in a TDBGRID

    Im currently filling a tdbgrid with an array formed from a table.Im then adding new records to the table by adding new lines to the grid and writing these to the table. I need to lock all rows that get read into the grid but NOT the new ones im creating. Im trying currently to use the...
  11. garethn

    write from one array to another

    still cant reomve blanks from an array i have this code that creates an array which writes to a grid.When it populates the gris there are blanks in between the totals(these are the records that make up the totals) I need to shuffle the grid or array up to remove the blanks...
  12. garethn

    write from one array to another

    how do i write from one array in vb to another. I have blanks in my first array and want to exclude these from my grid.

Part and Inventory Search

Back
Top