Search results for query: *

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

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.

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

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.

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

Thanks xwb & strongm

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

Thanks SqlSister

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

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

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

Are you looking for a connection string?

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

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

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

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

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

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

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

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