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 Chriss Miller 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: Tailgun
  • Content: Threads
  • Order by date
  1. Tailgun

    site search question

    I have a FrontPage site search installed but I need to modify it. The result will only show one or none in the result. I want to bypass the one to lead to the page directly and if none I need it to use a default page. Any suggestions or script to do this would be really helpful. thanks
  2. Tailgun

    Need help with 8.5 Dev editon hope this is the right place

    I have been using VB6 Enterprise along with Crystal 8.5 Dev edition the computer also has the 8.5 Enterprise on it. I have used it for a long time with VB6 no problem but all of the sudden when I load my VB6 application it tells me xqviewer.dll can't be loaded into my VB6 program. It has...
  3. Tailgun

    Xtal Dev edtion problem hope this is the right forum

    I have been using VB6 Enterprise along with Crystal 8.5 Dev edition the computer also has the 8.5 Enterprise on it. I have used it for a long time with no problem but all of the sudden when I load my VB6 application it tells me xqviewer.dll can't be loaded into my VB6 program. It has something...
  4. Tailgun

    stupid import question

    I know for you experts this is a stupid question but I'm a VB6 programmer and need help. I have a new SQL db with most of the tables having the same name etc as the one I want to import the data from but not all. I only want to import data from some of the tables not all. Then one of the...
  5. Tailgun

    XP SP1a problems with internet

    I have 2 XP Pro machines I have installed SP1a and the other updates from the Microsoft Windows Update site but NOT SP2. Both machines have the same problem. I can use IE for awhile (short time actually) then it stops working as do any of my other internet programs. It is not an IE problem since...
  6. Tailgun

    deleting records that have a column empty

    I'm somewhat new to Microsoft SQL2K and know just about enough to get myself in trouble so I need some help. If I run a query like Select* from tblClaim where FileNo is "" I want to then delete those records from the db. Meaning any record with the FileNo column being empty I want to delete...
  7. Tailgun

    VSFlexgrid data mode problem

    I'm using a component one VSFlexgrid Pro version 8. I am using this filter to filter the recordset. Adodc1.Recordset.Filter = "payappID = '" & Text2.Text & " '" In any of the bound Data modes available in the grid the filter works just fine. However I need to use it in the Data mode flexDMFree...
  8. Tailgun

    BOF and EOF problem with cmdbutton

    What is wrong with this code?? Please help while I still have some hair left. :) Private Sub cmdSave_Click() If Adodc3.Recordset.BOF = True And Adodc3.Recordset.EOF = True Then Adodc3.Recordset.CancelUpdate Adodc3.Recordset.Close Set Adodc3.Recordset.ActiveConnection = Nothing Else...
  9. Tailgun

    Error updating a grid

    I have a form with Component one True DBGrid 8 it is bound using ADODC control with this code and the grid is set to allow update. Select * FROM tblPayAppLineItems INNER JOIN tblProjectLineItems ON tblPayAppLineItems.LineItemID = tblProjectLineItems.LineItemID If I make a change to any...
  10. Tailgun

    inserting a txtbox number into a certain column in a grid

    I have a form with a textbox that contains a number the form has a grid. I need to insert the textbox number into one of the columns in each row in that grid. Any suggestions would be really appreciated. Thanks
  11. Tailgun

    Keep getting a type mismatch

    Keep getting a type mismatch in the critera in this -------------------- Select * FROM tblPayAppLineItems INNER JOIN tblProjectLineItems ON tblPayAppLineItems.LineItemID = tblProjectLineItems.LineItemID WHERE tblPayAppLineItems.payappID = '" & CLng(frmPayApp.Text1.Text) & "'...
  12. Tailgun

    code help with a grid

    I cannot seem to get this to work no matter where I place it in the grid events. I am trying to make sure that those two columns added together don't exceed another column and if it does I want to show a msgbox. ================== If TDBGrid1.Columns(2).CellText(Bookmark) +...
  13. Tailgun

    Error in Join operation

    here is the code that is giving me the error. I'm new to joins so maybe somone can help. Select * FROM tblProjectLineItems INNER JOIN tblProjectLineItems ON tblPayAppLineItems.LineItemID = tblProjectLineItems.LineItemID
  14. Tailgun

    Can't get 8.5 report to be landscape using VB6 Dev Edition

    For some unknown reason I can't get Crystal Reports 8.5 Dev editon which is embedded in my VB6 SP5 to be landscape. I do have another report that is portrait but when I try to open a new report by Project-Add Crystal Reports 8.5 and include the viewer etc i cannot expand the report size from...
  15. Tailgun

    auto updating a txtbox with the total from datagrid

    I have a datagrid that the user can edit, delete. add etc and it works fine. The total from one currency column needs to be automaticly updated after the user makes changes and he clicks a Save cmdbutton. At the moment with this code I can only make it work by using a seperate command button to...
  16. Tailgun

    not sure how to solve this it is like a transaction

    I have developed several apps in VB6 but still a newbie with this type of app. A user puts some data in a grid and I save it in a table. The grid has a fixed number of columns but the rows vary depending on his input. That part works just fine. Now I want to for want of a better term do a...
  17. Tailgun

    Anyone familiar with TrueDBGrid 8 ?

    Components One TrueDBGrid 8 question. I need to somehow go thru all the rows in the grid and if any row containing certain 2 columns in that row that are = I need to change the background and disable another column in that same row. So far with all the other requirements this grid seems to do...
  18. Tailgun

    Crystal Reports 8.5 portrait and landscape pages

    Is it possible using 8.5 in one report to have the first page landscape and the remainding pages portrait ?
  19. Tailgun

    DataGrid Column bkcolor

    Is it possible to set a DataGrid's background Column color to a different color for each Column?
  20. Tailgun

    How to do this as a transaction

    I have a VB frontend and an Access db. The user enters info into 2 forms each is saved into a seperate table. No problem. However now he wants to do a transaction so I have a form that has tabs for the info from each entry from the original 2 forms. The original forms saved have a number of...

Part and Inventory Search

Back
Top