Search results for query: *

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

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

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

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

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

From VB6 how would you compact and repair a DB? I know that I have to use DAO (or at least I think I do) but I still can't seem to make it work. Thanks for your help

Can SQL SERVER do CrossTab Querys like MS ACESS can? I had 2 queries that I did in ACCESS the first one retrieved all the data and the second one put it into a cross tab that filled an array. I cut and pasted the first query into a view in SQL2000 that did the first query but could not cut and...

I just recently installed SQL Server 2000 on a machine with with W2K Advanced Server. I can only back up to a tape,CD, or the hard drive. It will not let me browse for a network folder in order to back up there. I have even tried to type in a address and it will not let me. I know this has...

I am trying to reproduce a query that was written with a Oracle DB and am trying to reproduce it in Access the query is as follows: strSql = "select a.param_value, b.datapoint_id from " & _ "epa.epa_testdata a, epa.epa_engtemp b where a.param_id (+) = " & _...

Hi, I know how to open up excel through VB but I can't make it open up a specific worksheet. Does anybody know how to make it open up a specific workbook then goto a specific worksheet. thanks for your help

Hi, I am using a Flex Grid and have set the word wrap property to true but the text will not wrap is there another setting that needs to be set as well? Thanks for your help