Search results for query: *

Hi, I have a Kodak CX4210 camera. Connecting it to XP, it uses the XP Windows Image Aquisition 2 Drivers to connect. But the camera does not support the command DeleteAllImages. And this appears to be the only way to delete images programatically from WIA Automation in VB6. Does anybody know...

Hi, I'm trying to find out how to monitor the progress of a long (several hours at worst) INSERT query. The (Test) Query INSERT INTO TEST (bob) SELECT CaseID FROM Cases The problem Command.Execute( , , adAyncExcexute) The VB thread continues fine, but the FetchProgress event does not fire...

Hi, We develop multi user data access systems based on VB6, ADO(2.6), OLE DB provider for SQL Server and SQL Server 2000 Here is the situation. A recordset holding a single record is opened client side and the connection to the database is tempClosed, no locks are held. The operator then...

I can create PKs and Unique Clustered and Non-clustered indexes on multi line udf's But I'd like to create a non-unique clustered index for the table that is returned as it is then joined to several other tables. I can't do: CREATE CLUSTERED INDEX ON tblOut (ColumnName) it throw invalid use...

Hi, We screwed up (actually Alex did) Our All-In-One Wonder Database building/upgrading tool has gone a bit rogue and has created every NVARCHAR column with the DEFAULT contraint of (N'#BLANK#') due to a bug. But nobody noticed and one of the clients is live ¬¬; Does anybody know where that...

Hi, First off, here is how I generally write my stored procedures (sprocs) I create a view, add and join all the tables and do as much configuration as is possible in a view. Then copy/paste to Query Analyser and format it nicely, drop all the junk and write the complex stuff. What I always...

Hi, I'm running Crystal 7.0.1.100, but I know we have patched countless different things, with version 8 database and export patches, CRW and CRPE critical patches smart viewer patches, etc., etc. Does anybody know of a guide to all the crystal DLLs? And a change log for all the versions of...

Hi, I'm running crystal reports 7.0.1.100. A text field on the report contains the text "Debt Type Sub Totals" in Georgia 9pt, and at 100% and 150% zoom, the text appears to not fit it's text box. At 200% the text fits fine. Our rule of thumb has always been, if it looks OK at 200%...

Hi, I can already do this using UUIDGEN.EXE -oNewGUID.txt and readin that file into VB. But for the sake of elegance, does anybody know how to create one in VB? I can't declare CoCreateGUID in VB, probably because VB doesn't support C structures.. :( Cheers, James.

Hi, Following on from the MouseEnter event problem. I now need a suitable target for the events, because I'm trying to do drag-scrolling. Meaning: I have a form with a control array of picture boxes, each picture box contains it's "Film" (more picture boxes containing graphics)...

Hi Mouse move is all very well, but I'd like to know how to detect if the mouse leaves a control. Is it possible? Cheers, James.

The Task: Insert A4 images into a word document and print them using OLE and VB. The code was created by recording macros and modifying the VBA code. The print jobs go into the queue, but the server reports "Print job deleted" in it's event log. This does not happen if I use .SaveAs...

OK, heres what I got so far, I can drag from the treeview, storing the Treeview.SelectedItem.Key in the Data object. It arrives in the ListView, and I can just do MsgBox Data.GetData(vbCFText) and I have received the Key (not particularily usefull, but it shows that it works.) What I need to...

I have a large complex query in a stored procedure for searching on Cases. It currently runs in 8 seconds. Yesterday I fluked a FROM clause that caused it to run in 2 seconds. I was pleased. I then managed to lose all my work. I am now not pleased. The Query Analyser showed the Plan to use...

Using SQL Server 2000 IIS 2000 IE5.0 InterDev 6 Running IIS and SQLS on a dual P3 800. IE running on a P4 1.7 over a 100baseT LAN. And only I (the developer) am hitting this web page. On the front page there are several pull downs with quite a few items in them (100's), now... Running the...

Hi, here's the code. <DIV style=&quot;width: 100%; height: 450px; border: 1px solid black;&quot;> <DIV style=&quot;width: 50%; height: 100%; border: 1px solid fuchsia&quot;> </DIV> <DIV style=&quot;width: 50%; height: 100%; left: 50%; border: 1px solid aqua;&quot;> </DIV> </DIV>...

My page looks like Banner --------------------------------- | | Information | Nav | | | | | | There are (usually) three div's in the informatin frame, a header, footer and data section. I want to be able to dynamically set the...

My page contains a form, which action's itself. If the submit button was pressed, a hidden field is marked with goSubmit. In this situation the data in the form must be passed to the next form. is there any was to simply pass the request string's parameters (?bob=bill, etc.) to another page? or...

I'v given up with the InterDev Scripting model, I hate it. But without it I can't do This <SCRIPT LANGUAGE=vbscript RUNAT=server> sub thisPage_OnEnter() [Some stuff] end sub </SCRIPT> Becuase the thisPage object doesn't exist without the Sctipting model thing. So does anybody...

Is this a bug? Test image with white background, picture of a plane on top, alpha = 80% The image just looks gray and washed out, NOT transparent. ta, Jim,