Recent content by JoseC

I ended up hardcoding the path to "Iexplore.exe" which is not good and not what I wanted to do, but the only way I could make it work. If it works by placing the URL in the START ->> RUN box, why not with the SHELL command?

NJLDoc, Thanks for your reply. They look very similar. What I am thinking is that, those PCs are running multiple applications that is slowing down the loading of WORD and therefore giving me a timeout on the OLE connection. I haven't seen it on PCs that are running just my App or less Apps at...

I got the code below to work. I even copy the current clipboard content and restore it later 'cause the spellcheck process erases it. Anyhow, at times; there will be a delay or something that will display a "SWITCH TO application" or "RETRY" message box that appears to the...

I agree! :)

Using the following code I found, I can read my "own" appointments for given date. But how do I read other peoples appointments?? Application will be used by a front desk receptionist and she'll enter a name and the VB app will respond with the individual's schedule for that day...

I am wondering the same thing... I am using VB6 the CRYSTL32.OCX to do a PrintPreview. The DB connection is up during the PrintPriview. How do I terminate that connection without terminating the VB application?

You must set a destination, see sample code: With CrystalReport1 .Destination = crptToPrinter .printreport End With Good Luck!

Asking again. :) I have searched the Seagate support area and come up with mixed answers. Still no solution.

Environment: VB6, SQL 7.0, CR6.0 OCX Using the following, I can get the report to PrintPreview okay. But it keeps the connection open. This VB app is a Print Engine, I pass data to it and it displays in PrintPreview to user. 1. How do I close the connection without terminating this VB app...

I am trying to automatically addrolemember rights to a user when their security clearance is set. I am trying the following Trigger. ---------------------------------------------------------- CREATE TRIGGER securityupdate ON MyTable FOR UPDATE AS DECLARE @login varchar(50), @UPDsecurity int...

tlbroadbent, Doh!! Okay, I made the changes, tried it, and it works! Thanks again.

tlbroadbent, I tried the following and although it is not coming back with an error, it's not creating the user. ------------------------------------------------------------ CREATE PROCEDURE user_create (@username as varchar(40)) AS declare @password varchar(25) set @password = 'password' --...

Thank you so much!

Components: VB6 SQL7.0 I am trying to add new users to for my application, the SPROC that I calling contains: ------------------------------------------------------ use master exec sp_addlogin @login, @password, MyAppDB use MyAppDB exec sp_grantdbaccess @login, @login exec...

Thank you so much, I still got some errors during execution but it did work!! I've got a couple of more of USERS to delete, thanks!!!