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 derfloh 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: testeng
  • Order by date
  1. testeng

    Fixed length strings vs variable length strings

    Is there any advantages (perfomance / efficiency) gains to using a fixed length string?
  2. testeng

    open a acess module / procedure from excel

    Well that did it I tried on a machine with a clean install of office 2000 and the code worked fine. Sorry to have bothered everyone.
  3. testeng

    open a acess module / procedure from excel

    remou yes i did try late binding but it did not help same error vbajock No security yet this is all in development at the moment havn't gotten that far in yet. The machine I am testing I had to install the dll for Access 2003 for testing another application. I am starting to think that has...
  4. testeng

    open a acess module / procedure from excel

    yes i did set the reference although by the error message telling active x cant create object it doesn't appear that it is really set.
  5. testeng

    open a acess module / procedure from excel

    I am using Access and XL 2000 and through VBA I want xl to call a procedure in an access DB I have set a reference to access in xl but it still crashes each time it trys to set the object to a new access.application here is my code what am I doing wrong and is there a better way to do it. I...
  6. testeng

    listview how to hide a row

    Thanks xwb & strongm
  7. testeng

    listview how to hide a row

    Is there a way to hide a row in a listview? As the listview is being populated with rows of data some of them I want to keep hidden from the end user but still in the listview to use later in the program. I could store that data in an array but now I am more curious of how to hide a row in a...
  8. testeng

    hierarchy table

    Thanks SqlSister
  9. testeng

    hierarchy table

    I am sure there are several post for this but I haven't found one I really understand yet. I have a hierarchy table with 3 columns in it ParentID, Description, ChildID. I would like to use a query to get all of the ChildIDs and its childIDs from a ParentID. I know this is simple but I just...
  10. testeng

    Stored Procedure Return Parameter

    I am trying to return the @@Identity field from a stored procedure after a row is inserted but I keep getting an error that it can not convert it to a integer error. I have returned parameters before but always an integer value what is the trick to returning a string? Thanks is advance
  11. testeng

    Search for running apps and stop them

    Does any one know how to get a list of all running apps on a PC and stop/close certian ones? Thanks
  12. testeng

    VB6 looking for help to load from SQL server

    Are you looking for a connection string?
  13. testeng

    Add data to a combo box/listbox

    Hi I am new to .net and having a hard time switching from VB6. I have a list of employess and there ID that I would like to put into a combo box and display there name but when selected only pick there ID. In VB6 the code was .additem for the employee name and .itemdata(x) for the ID. How does...
  14. testeng

    Create Table in Access

    I would like to create a temp table that will be very large so I would like to be able to index certian fields after I create the table but so far I can only create a primary key and thats it. Here is my string: strSQL = "CREATE TABLE AutoIncrementTest (ID int identity, F1 varchar(40),F2...
  15. testeng

    Best Practices

    I am curious if this it the proper way to do this. If in your app you connecting to 2 different DataBases should you create 2 seperate class modules for each DB or just one for the DB that the majority of the app is for and just create a connection in the routines (or just a Public function)...
  16. testeng

    Return Parameter

    Does anyone know how to return (to VB6) if the user clicks the cancel button in a crystal reports print dialog box
  17. testeng

    export data from a a text file

    Does anyone have any code on how to read from a text file. I have a application that puts data into a text file(note pad) in multiple columns I would like to go in and export that data into a DB. What would be the best way to do that? Thanks for your help
  18. testeng

    Insert Multiple Rows

    Hi, Can some one tell me why this statement will not work I have tried it with Acess 2000 or SQL2000. Insert into TABLE1 (FEILD1,FIELD2) values (1,1),(2,2),(3,3); It errors out everytime I have never tried to do multiple inserts before just heard about it has anyone had any success? Thanks in...
  19. testeng

    Need Help with Flex Grid

    Is there an easy way auto size a MS flex grid like in Excel(EntireColumn.AutoFit) maybe it just me but I can't figure it out. Thanks for your help
  20. testeng

    Help with Flex Grid

    Is there an easy way auto size a MS flex grid like in Excel(EntireColumn.AutoFit) maybe it just me but I can't figure it out. Thanks for your help

Part and Inventory Search

Back
Top