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

Thanks a lot RobSchultz, I didn't know about allapi. I downloaded the API-Guide and was very pleased with what I saw. Great reference for every VB programmer. Once again, thank you for your help, I appreciate it a lot.

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

FYI there's another way to do this that is much simpler, you insert 2 unvisible control in your form and set the tabkey before and after the control you want to trap. IE, if the tabkey of your control is 5, you set the first control to 4 and the second to 6. Then you catch the tab key when...

Simply use the Shell to open the file, wait for it to end, and the kill to delete it using the path in your textbox. For the waiting part, search the site and you'll find an example. Hope this helps.

Could you elaborate more by telling me the steps you took to create your dummy table via code and an example that uses the WITH END WITH syntax? How do you work with tabledef?

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

Thanks NickISD but I found the problem. There is a password on my MDB and I took the syntax from somewhere else on the web but it was wrong, causing me the ISAM error. I now have put the right syntax and everything works fine now. Thanks for your help guys, it's very appreciated.

Hi Nick, I tried the code above and got the error: ISAM driver not found. What library is this?

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'm trying to do the same thing with msjro.dll version 2.6 and keep getting an ISAM error. I'm using an access 2000 db and put the engyne type to 5. Anyone know why??

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

Will it be able to tell me which SPID is taking all the juice?

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 found the code to create a system dsn for an access database, tried it and works great !! I'll go with this solution instead but there's one thing that I don't like: You can see the mdb password in the registry !!! Guess I'll have to live with it. Still, if anyone finds out how to configure...

I use getsetting to retrieve a path that I wrote in the reg at installation. Now I want to use this path to create my connectionstring. The main form appears loaded with the recordset. I'm thinking of using ODBC instead and creating a new dsn via the installer that would contain the path. Do...