Recent content by sflau

It works. Thank you so much.

Here is the further information: Actually, I run the following coding: strCmd = "runsth.exe" lngExecOK = Shell(strCmd) lProcessHandle = OpenProcess(&H100000, True, lngExecOK) lReturnValue = WaitForSingleObject(lProcessHandle, 10000) CloseHandle lProcessHandle I want to...

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 get it, thank you.

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 also use VB to control Word for mail merge. I agree with "TerraSamba". use "wrdApp.ActiveDocument", instead of "worddoc". And If you want to open WordApp every time: Set wrdApp = CreateObject("Word.Application") You need to close it when...

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

It works, thank you so much.

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.

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.