Search results for query: *

I am using DAO and my code: 'Do the truncate here Dim dbs1 As DATABASE Set dbs1 = CurrentDb dbs1.Execute "Truncate Table " & TableName Gives me this error: Run-time error '3078': The Microsoft Jet databse engine cannot find the input table or query 'Truncate...

Hi all, I have another question along these lines. Now I need to write a Truncate Command in a VBA setting against a SQL Server table. Code just doesn't seem to be coming to me. TheKing [pc3]

I hope someone here has moved up to Access 2003, I have installed Access 2003 and Linked Table manager wizard will come up but the box will be empty. I have uninstalled and reinstalled on two different machines and still only get the black screen where my linked tables should be. TheKing [pc3]

Would any of you know of a WMI script/procedure that you can call to the Win32 class for formating unused disk space? I know there is one for all the diskspace, but unused kinda through me. TheKing [pc3]

Hello all.... I wrote a program that uses about 400 different select statements with around 20 different Recordset names. Set up this way Client side processing Public g_Database_Connection as String G_Database_Connection = (here is the connection string out of the ini file.) Now you set and...

Humm... what would you call a short timeout setting? Mine is set for 30,000 TheKing [pc3]

Ok, I will look into that. Thanks TheKing [pc3]

I am still new to TCP controls but a while back I bought a TCP control from the Company Called Dart. Well come to find out that their service isn't what you would like it to be. Here is my problem: I connect to a server with my VB application using my TCP component and it connects fine, sends...

OH man that makes so much sence. Thanks a lot. TheKing [pc3]

I need to shell out to a .jar (java) file. I have tried: intStart_Summary = Shell("C:\Program Files\SMARTPss\HateCrime.jar", vbHide) ' Run Jar Executable and I have tried: Shell ("C:\Program Files\SMARTPss\HateCrime.jar"), (vbNormalNoFocus) There must be something I am...

wow, that looks very simple, thanks I will implement right away. Looks like I need to learn about the file system object better. thanks TheKing [pc3]

I would like to do a check to see if there are any files in a specific folder. Example: in the folder 'Upload' I am having people upload threw a web page txt files. I will not know what the file name is for sure. Can I do a folder directory search and if a file is done uploading then I can...

I have made my first Application with using DirectShow in 8.1SDK. I am going to be making an install disk and was wondering if there were some files I should make sure get into my install disk? I can't test it here as the only machine here with a second video card (for use with a web camera)...

I had the same problem. But my problem ended up being that I has Direct X 9 on my machine b4 putting on 8.1sdk I had to put my hard drive into another machine as a slave. Then I took out everything that I could find that had to do with 8.1sdk. then it booted on its own, then I uninstalled DX9...

strongm that dll you sent me to is perfect. Did exactly what I needed for my project. Thanks again TheKing [pc3]

sure, but just a sample I would say since the sql file is 31kb large. after opening it in NotePad I copied out a couple lines and pasted below: DROP TABLE IF EXISTS Affidavit; CREATE TABLE Affidavit( PRIMARY KEY (AffidavitID), AffidavitID BIGINT NOT NULL, ORI VARCHAR(250)...

Thanks for all of that I will copy it out for sure. But at this time I have the SQL file already, I was looking for the command that I use in SQL+ to make the database from the SQL file. TheKing [pc3]

I am new to Oracle 9i and I would like to creat a database in Oracle 9i from an Access.2000.mdb. I found a program that converted the database into an SQL file. I really don't know what to do with it at this point. any ideas? TheKing [pc3]

sorry strongm, I did a key word search but didn't do the right ones I guess. Thanks for the info. TheKing [pc3]

Does anyone still have that Intel jpg converter library out there? I have a program that will take a still picture capture from a sony web/conference camera but of course VB will capture and save it as a .bmp file. about 180KB I need to then (command line) change it to a jpg hopfully around...