Search results for query: *

Hi, I'm trying to write the content of an excel cell with a binary image file and can't get the chr(0) to insert. If i send the vb string, it stops as the first occurence of a nullchar and if I send char per char, it just won't put the chr(0) in between all of the chars. I tried with the...

I'm creating my own "surveillance" program that will ping and check server services and e-mail me when they're down. I know how to do the pinging part but can't find anything on checking remote services. My guess is that it's part of win32 API but not sure. Any help will be very...

I'm trying to create a new column in an access 2000 database via ADO and it works fine but when I just can't seem to find the right syntax to set the default value to 0. I've looked evrywhere and tried lots of syntaxes but they all give me a syntax error in alter statement. Could somebody tell...

I'm trying to completely close an mdb file that was open previously in the same application using ADO. I do a close on it and set xx=nothing but i still see the ldb file present, meaning that the file is still open by the program. Is there a way to close it completely without terminating the...

I'm using the dbengine.compactdatabase function in my program to compact an MDB database. If the client has office 2000 with access installed, everything works fine but if he only has access runtime 2000 installed, I get an automation error. Is there a normal reason for this? If I try to...

I set up a dataenvironment comming from an ODBC source and configured the ODBC on both machines (web server and mine) and created a simple html page to display a table from SQL. Everytime I look at the page in explorer, everyting loads up fine without any errors but the textbox containing a row...

I recently dropped 90% of a big table that had a dozen indexes. When I did a SP_SPACEUSED on the table, it told me that the index size was 2.1 gigs but there were only 90 megs of data (139000 rows). What can I do to reinitialise the indexes so that the space they occupy reflects the new amount...

I've never seen this. While i'm writing my code, vb6 completely closes without any error messages. I'm not even in runtime, i'm just writing stuff !!! If someone eveer experienced the same behavior, please let me know what the problem is !!!

I need to create variables from a mdb file. The table contains var names and the formula that goes with it. In the formula, you can find another var with it's own formula. I need to put all this in variables (aprox 200) to be able to calculate the formulas. Ex: var:TEST formula: (TEST2 + 60)...

I'm looking for a way to see the processes activity and cpu/io percentage they're taking, kind of a task manager with the percentage and all. I'm using sql 7.0 and a dual processor board. The purpose of this is to identify bottleneck processes within sql when I see my server's disk drives...

I've looked at all the other posts concerning adodc and could not find an answer to my question. I'm trying to give the adodc on my application form its connectionstring depending on a registry value that contains the path of the mdb file. Every time I refer to my adodc thru code, it tries to...

This question is simple but I don't think everyone knows the answer. How many vars can you give a function when you call it? Is it infinite?

I'm trying to put a textbox in the report footer that sums up the results of sub reports in the detail pane. I tried putting =sum([srpt_test]![txtfield]) and =sum([srpt_test].[txtfield]) but it doesn't work. The only way I found to do this is to work with the format event of the subreport and...

I'm running an access program that updates 2 excel files with results from sql queries. I would like to know how to determine if either of the excel file is open (with locks)and if so, who has it open. That way I can inform the user of the access program with a msgbox who's the guilty one. I've...

I'm running an access program that updates 2 excel files with results from sql queries. I would like to know how to determine if either of the excel file is open and if so, who has it open. That way I can inform the user of the access program with a msgbox who's the guilty one. I've seen it...

I'm running an access program that updates 2 excel files with results from sql queries. I would like to know how to determine if either of the excel file is open and if so, who has it open. That way I can inform the user of the access program with a msgbox who's the guilty one. I've seen it...