Search results for query: *

I am using VB 6.0 and calling the SHELL function: SHELL(runsth.exe) But I am not sure whether the program "runsth.exe" will have retunr code. Because I want to know if the process "runsth.exe" failed, will it returns error or not. Any one can tell me how to capture the...

I want to print a watermark in the datareport, which is as big as A4 size. So that I think I needs to do it with the printer object, instead of datareport. But I can't find it, please help.

I am using VB 6.0 to control Excel for to do some thing, and then save as a new file. But I find that the excel application is still holding the excel, although I already quit it. Would anyone help me, please? Here is my coding: -------------------------------------------------------- Dim...

I am using VB 6, can any one tell me, how to check whether the LPT1 is connected to a printer? Actually, I don't install any driver, so that I just put the content to LPT1, but if the LPT1 is not connected to the printer, the program will hang~~~ Please help.

I am using VB6, actually, I have such conditions: 1. I using VB6 to control a Word document to perform the following: "wordApp.Selection.Fields.Update" But since there is a lot of pages in Word document, so that it needs a long time to wait for a process: But, I want to set a rule...

I am using Access 2000, but I find that I can't use "Full Outer Join", does Access 2000 suppoer Full Outer Join? But, in access, I can use left outer join / right outer join. Why? Here is my SQL statement, please help: select * from (select Field1, Field2 from Table1 where Field2 =...

I am using WinME, with 512MB RAM, P4 1.7G CPU, 10G HardDisk (5G left). I am using a VB 6.0 Program to control Word2000 to insert many pictures (Around 16 pictures x 250 pages = 4000 pictures), and then, need to refresh before printing: So that I use the following code to "Select All...

I am using MS Access 2000. I find that the Access File size is too large, so that I delete some out of date records. But I find that the size is still the same as before. Can anyone tell me why? How to decrease the size after delete the unless records, please? Thank you.

Can we create Stored Procedure in Access? I know that we can pass "parameters" to Access View, but can we use "IF, Then, Begin, Else ..etc"? Please help. Thank you.

I am using SQL 7. And have questions for the speed of the following SQL statement: 1. Comparing "Select * from TableA Inner join TableB on TableA.Field1 = TableB.Field2" Vs "Select * from TableA, TableB Where TableA.Field1 = TableB.Field2" Which is faster? 2. Comparing...

I want to print special character (Not a, b, c, @, $, &), because all of them may be used by others. So that, I want to print out "F1", "F2"... or "Ctrl+something". But after checking the "Character Set", I don't know which one is "F1&quot...

I am using VB 6, and want to e-mail with attachment automatically, without any user control, I find that I can do it with OutLook by the following: Set olMailMessage = olApp.CreateItem(olMailItem) With olMailMessage .To = pToAddress .Subject = "Testing...

I am using VB 6, want to execute a dos batch file, then, I use: Shell "UPLOAD.BAT" But I find that it will only call the batch file, without finish it, it will return to the program immediately, how can the program know whether this command is finished or not?

I am using VB 6, with True DB Grid 7. While I update the grid, it should call the function "AfterColEdit", but it doesn't, why? In a more strange situation: If I call another form, and then go back to call the original form again. Then, I update the grid, it call the function...

I just create two replications from a SQL 7 to another SQL 7. One is snapshot, scheduled 1st Sunday every month. Another is transactional, scheduled every day. But they may be changed later. So, are there any method that I can get the schedule properties of the snapshot / transactional from...

I want to write a VB program, to check whether the replication in the SQL Server is finished or not and success or not. But how? Are there any Store Procedure that I can use to check the status of replication?

I want to write a VB program to act as a Piano, do anyone know where can I find the related information / coding for the following, please? 1. "How to control "play different sound while pressing different key.", including different tone and different time length." 2. How...

I am using VB 6.0 to control MS Word 2000 for print out. But I can't control to print the document in duplex. I am trying to use: wordDoc.PrintOut Background:=False, manualduplexprint:=True or wordApp.ActiveDocument.PrintOut Range:=wdPrintAllDocument, Item:=wdPrintDocumentContent, Copies:=1...

I am using VB 6, just created a datareport and want to have a preview, and I use, drtemp.Show Then, error message prompted "Can't show non-modal form when modal form is displayed". If I change the dtremp as MDIForm = TRUE, then another error message prompted "No MDI Form...

I am using VB 6 and Word 2000. Originally, I insert a picture to word document (Link to file, let say Picture1.bmp instead of save to document). It is OK. And then, By VB 6, I delete the original picture1.bmp and then copy another picture, let say Picture2.bmp, to picture1.bmp. Then, I select...