Search results for query: *

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

SQL 7.0 I have added a user 'John' into my database via EM GUI (Databases -> Security -> Logins -> New Login). When I try to add that user to the specific database (Databases -> DBname -> Users -> New Database Users) I get "Error 15023: User or role 'John' already exists in the current...

thank you... doing it right now!

VB6.0 SQL 7.0 I added a new field to a table manually on my Test DB. Now I want to write a script and have it ready for Production DB implementation. The goal is to just run the script and will create the new field as well as other changes to the DB and it would be ready for the new VB code. I...